Overview
SQLite is the most widely deployed database in the world. It is popular because of its compact size, cross platform stability and serverless functionality. stores its entire database as a single cross-platform file on a host machine, and implements a self-contained, server less, zero configuration database engine.
Screenshot
Features
- Backup and Recovery
- Multiple Programming Languages Supported
- Queries
- Data Manipulation
- Query Language
- Scalability
- Storage
- ANSI-C
- Command-line interface (CLI)
- Full-featured SQL
- Zero-configuration
- Single cross-platform disk file
- Tunable consistency
- Programmability for HTAP
- Administration and management
- Continuous high-speed ingest
- Support for embedding
- Administration and management
Specifications
- Deployment: Installed - Mac, Installed - Windows
SQLite Users
Available Support
- Online
Language Support
- English
Company Details
Company Name: SQLite
Headquarter: United States
Full Address:
Reviews
If the application is not an ERP sort of then Sqlite is the best choice, it’s easy to integrate and fast if the data is small. Best choice for beginners as well.
SQLite is not a multi-user platform where the users can handle concurrent writes. There for SQLite is not good for intensive applications with rapid data logging. If the system has concurrent transactions where lot of users keep accessing the same set of data simultaneously then SQLite is not a good choice for the project. SQLite data bases are restricted to maximum of 2GB in most of the cases.
The most game changing aspect of SQLite is that it is serverless and self containing making it lightweight and portable. This makes it great for mobile applications and simplifies app architecture. We use SQLite to develop full apps but also only to explore some data sets using certain commands that I can only get in SQLite. It is close to SQL Server so it allows our RnD teams and developers to quickly test out some functionality before implementing in SQL Server.
For mobile development(Android or iOS), this database works wonders considering it is so light weight and requires very less space. Database can be exported in the form of a single file which makes data sharing very easy. Data query operations are very fast. I have never faced any kind of downtime using this database which makes it highly available and reliable.
SQLite is for a very specific use case and there are no distribution properties or guarantees. Designed to be very simple so not a lot of tuning for SQLite. If you want high availability and concurrency, you may want to look at a different solution.
