The great little database that could
May 03, 2021
The great little database that could
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQLite
We use SQLite for file based data integration and ETL's. Only the IT Department uses SQLite due to its technical nature.
- In memory database is extremely fast
- Supports nearly all database capabilities
- Lightweight footprint for using on many types of devices (mobile, PC, consumer devices)
- Not multi-user due to its file locking design, but this supports its efficiency and speed strengths
- Doesn't offer all join options typically available in standard databases
- High repetitive single table writes can be problematic
- Lightweight and easy to embed in projects
- Widely used and supported
- Speedy, especially on local datasets, great for ETL involving flat files
- Great tool to provide structure to data manipulation without needing an actual database
- Open-source so it's essentially free to use
- Short learning curve, supported on many OS's
Microsoft SQLExpress: More heavyweight, not as lean in terms of disk space or processing requirements. Involves Microsoft's tentacles to be involved.
Do you think SQLite delivers good value for the price?
Yes
Are you happy with SQLite's feature set?
Yes
Did SQLite live up to sales and marketing promises?
Yes
Did implementation of SQLite go as expected?
Yes
Would you buy SQLite again?
Yes