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:<p>- No need to link with C code. There's a pure go driver for Postgres.<p>- You get the 'psql' command to inspect and change the database, even while the web app is running.<p>- You get a lot more database features.<p>- You can keep the deployment simple by running Postgres on the web app server until you need to scale up.<p>- Conversion to a full blown cloud database and horizontal scaling is just a matter of configuration.<p>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.