3 ms·
After developing with Postgres for several years and then moving to sqlite for dev, sqlite is a breath of fresh air. Now our policy is that everything goes into
by nouveaux 8y ago
After developing with Postgres for several years and then moving to sqlite for dev, sqlite is a breath of fresh air. Now our policy is that everything goes into sqlite db unless the data requires multiple writers. The fact that you have to keep a process running and updated is reason enough to not use Postgres if you can help it.
For instance, we have processes that fetches and stores data from APIs. It's trivial to share this with other developers for dev purposes. This data is read only and it reduces an annoying step of loading the data into Postgres.
This is coming from someone who starts projects with only Postgres for many years and I do love Postgres. Sqlite is an underrated tool in the web dev world.
- Scarbutt 8y agoReally though, I would bet 95% of wordpress websites will make do with sqlite.
- bschwindHN 8y agoI'm using sqlite for a small project but I was kind of disappointed to learn how annoying it is to drop or rename columns. Especially when you write migration scripts with up/down statements, it's kind of a pain compared to postgres. But otherwise it's been fine to use, a good starting point for internal projects.
- h1d 8y agoHow do you browse the data on the remote server with any GUI tools? Last time I checked not even DataGrip could do it.