2 ms·
This is my primary answer as well. I have no problem with Postgres as a solution, but I will only invite additional complexity into my life when absolutely requ
by bob1029 7y ago
This is my primary answer as well. I have no problem with Postgres as a solution, but I will only invite additional complexity into my life when absolutely required by the business constraints.
SQLite is dead simple compared to Postgres (or any other hosted solution). I can copy a SQLite .db file from a production machine to my local box and be reviewing rows/running queries within seconds. Also, sharing SQLite databases with other users & developers or even using them as a contract between systems is a very compelling set of use cases. Finally, going from a blank windows machine to a working development (or production) environment is very quick if your application exclusively uses SQLite to store its data. You simply stop thinking about databases after a while because everything just works.
- jbverschoor 7y agoFor me, the single file is the nr 1 reason. It sluist works, the file is the data.. very clear.