Hacker News new | ask | show | jobs
by zie 4 days ago
Yes, I'm sure the WASM binary for PG has a big perf hit. If you are just using it for testing, it probably doesn't matter?

Why does the perf hit matter to you? Are you trying to run WASM binaries of PG in production? That seems like a terrible idea.
1 comments
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.
link
zie 1 day ago
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

link
Imustaskforhelp 17 hours ago
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 :)
link