One-Process Programming Notes
This is a good article, but I feel like using Postgres instead of SQLite on the server side would achieve his goals even better:- No need to link with C code. There's a pure go driver for Postgres.- You get the 'psql' command to inspect and change the database, even while the web app is running.- You get a lot more database features.- You can keep the deployment simple by running Postgres on the web app server until you need to scale up.- Conversion to a full blown cloud database and horizontal scaling is just a matter of configuration.I understand the desire to keep the stack as simple as possible, but it looks to me like Postgres would actually be simpler than SQLite for the server side.