3 ms·

Huh? SQLite is nearly 20 years old, and is only intended for small scale use.

• bob1029 6y ago
  It 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 ago
    Oh, 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 ago
    SQLite 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 ago
    I 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.