Hacker News new | ask | show | jobs
by Imustaskforhelp 2 days ago
No, I am not running WASM binaries of PG in production given its perf hit but I would like to have the simplicity that I have with sqlite.
1 comments

My advice: Just use SQLite. Don't use PG if you don't need it. I mean PG is awesome. I use it all the time, but I also use SQLite all the time too.

SQLite is also a replacement for fopen()[0]. if you need to read/write data files, I recommend using SQLite instead. Replace your CSV's with SQLite, etc.

0: https://sqlite.org/whentouse.html

Yup its a really decent advice overall but I feel like there were some few use-cases I think where postgres made more sense but I found the initial setup to be slightly more complex than sqlite and oh I love both sqlite and postgres and was just thinking of merging somewhat all the things that I like about them haha but I get what you mean, both sqlite and postgres are awesome :)