What is SQLite?
Who uses SQLite?
Why developers like SQLite?
Here are some stack decisions, common use cases and reviews by companies and developers who chose SQLite in their tech stack.
SQLite is a tricky beast. It's great if you're working single-threaded, but a Terrible Idea if you've got more than one concurrent connection. You use it because it's easy to setup, light, and portable (it's just a file).
In Paperless, we've built a self-hosted web application, so it makes sense to standardise on something small & light, and as we don't have to worry about multiple connections (it's just you using the app), it's a perfect fit.
For users wanting to scale Paperless up to a multi-user environment though, we do provide the hooks to switch to PostgreSQL .
This app uses SQLite to store internal data and is superfast, especially good to use with Android JetPack framework like Room. Gradle is good for managing the dependencies and Groovy script enables some advanced configuration.
There's really no call for something heavier for this site. SQLite is simple, easy to use and quite reliable given its age. SQLite
RDBTools is a self-hosted application, and it is important that the installation process is simple. With SQLite, we create a new database file for every analysis. Once the analysis is done, the SQLite file can be thrown away easily.