Hacker News Reader

Why not try a real database like Postgres? It's not as light-weight, but when operations get complicated, real databases are much easier to work with. I had a website that started with SQLLite, but when it got complicated enough, I spent two days to migrate the whole thing to Postgres. With current LLM coding agents, it's not that hard.

View on HN

Honestly, I love PostgreSQL, but now I have another server or service to run. SQLite is just a file and often, that is enough.

PGlite offers the "real database" compiled to WASM, which can then be embedded similarly to SQLite. You don't have to choose between PostgreSQL and "just a file".

Yeah pglite is exquisite. Now I don't have to write separate code for client and server side queries.

For example, I have a compiler that compiles a DSL to a DB query which returns a list. Now that query can either be on data in the browser or can be on data on the server. Now I don't have to write the logic twice!

Reply on news.ycombinator.com