Frontend

SSR and SPA with AlephJS because:

Nice SSR
Really nice SPA link stuff
Easy framework overall
Easy locale translating stuff
It can export to static pages, for use with possibly tauri

Style

Options are:

Tailwind css
Material UI
Bootstrap

Aditional notes

Fresh
- (good) Uses preact
- (good) Doesn't even ship JS by default to the browser
- (bad) Needs a server, so no static hosting
- (bad) Not as fancy as alephjs, more "do yourself" stuff.

Backend

Requirements:

JWT
SQL (sqlite?)

Possible libraries?

Fresh
- (good) Has a pretty nice way to handle requests with the web Request and Response APIs.
- (good) Very close to the Native API.
- (bad) No middleware support.
Oak
- Kinda similar to ExpressJS
- A big community with middlewares for many things.
TinyHTTP/Opine
- Very much like ExpressJS

Database

MongoDB is Web Scale
sqlite
- Easy to host
PostgreSQL
- Actual production database
- Array support omg