3 ms·
SQLite is the hottest new thing on the block.
by bob1029 6y ago
SQLite is the hottest new thing on the block.
- mkl 6y agoHuh? SQLite is nearly 20 years old, and is only intended for small scale use.
- bob1029 6y agoIt was intended as a joke in context, but I believe SQLite is far more capable than most will give it credit for. This is especially true for applications which you only ever intend to run on a single logical machine. But, even for those applications requiring multiple nodes, it can still be a powerful tool if you assume clustering & replication duty in your application logic. For any use case, SQLite is one of the best ways to persist structured data to local disk.
- mkl 6y agoOh, I agree about its utility, and use it myself. It seems like a different category of tool than the other DBs under discussion, though.
- sohamsankaran 6y agoSQLite is incredible, especially for embedded applications. It's one of those perfectly-scoped tiny pieces of software that consistently makes my heart sing.
- waheoo 6y agoI try to use sqlite for all projects until i cant. Its a little scary how much it can actually handle, and how lazy and sub optimal it is to reach for a "real" sql server before you need it. Having the database as a simple file right next to yoyr application is incredibly convenient not to mention how brain dead things like backups are to grok.