8 ms·
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 w
by wwind123 2mo ago
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.
- abrookewood 2mo agoHonestly, I love PostgreSQL, but now I have another server or service to run. SQLite is just a file and often, that is enough.
- 9rx 2mo agoPGlite 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".
- vatsachak 2mo agoYeah 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!
- deleted 2mo ago[deleted]