SQLite

Score9.6 out of 10

45 Reviews and Ratings

What is SQLite?

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is one of the most widely deployed databases in the world.

Categories & Use Cases

Markus Hopfenspirger View profile

Freelancer - Senior Software Architekt in Manufacturing at MaHop.Net the Software Copmany (1-10 employees employees)

Use Cases and Deployment Scope

I use it as a database for my mobile Apps developed with C# Xamarin / Maui and for a couple of smaller WebApps developed with C# and ASP.Net Core.

Pros

Performance is very good
Data Security in case of Crashes during a transaction
Ease of use

Cons

Native encryption support
Better C# integration

Most Important Features

Simple to use
Good Performance
Reliable

Return on Investment

Faster App Development

Alternatives Considered

Microsoft SQL Server, Oracle Database, MongoDB and MySQL

Other Software Used

Microsoft Visual Studio, Microsoft Visual Studio Code

Sumon K Chowdhury View profile

Asst. Software Specialist in Information Technology at i-Tech Software Ltd. (11-50 employees employees)

Use Cases and Deployment Scope

SQLite is an excellent tool because it's easy to use with many languages, especially C#. Because SQLite is quicker and easier to integrate, we use it for C++ applications. And yes, we also used it with web and mobile applications when we needed instant access to a small database. It's the most widely used database with many high-profile applications. We can use it to create long-term storage for our applications without installing anything. It is a transactional SQL database engine self-contained, serverless, and requires zero configuration. This software is fast, reliable, suitable for small and big projects, user-friendly, and easy to learn.

Pros

Easy-to-use.
An easy-to-use query.
Simple to understand syntax.
Simple in both operation and integration.
In Android applications, it is simple to use.
Frequently updated cross-platform database.

Cons

The transaction moves slowly.
Too many search windows are confusing.
Database size is limited to about 2GB, which is not good.

Most Important Features

Lightweight database.
Optimizing syntax is easy.
Faster than other databases.
Data retrieval occurs quickly.
Installation and setup are easy.

Return on Investment

Cross-platforms like iOS, Android, MAC, and Windows are all supported.
Extremely user-friendly, both in terms of using it and writing queries to run on it.
JSON and CSV files are supported. SQLite can use in-memory and external files.
SQLite market has a plethora of third-party ORM and data layers that make life easier for developers and save time.

Alternatives Considered

Microsoft SQL Server

Other Software Used

InfluxDB, Microsoft Access, Cisco Jabber

Bradley Wilson

Database Administrator in Information Technology at Colton Joint Unified School District (1001-5000 employees employees)

Use Cases and Deployment Scope

SQLite has been instrumental in our ETL pipeline. We utilize it heavily to ingest JSON and XML from multiple sources like Rest API, SFTP, and WebDAV repositories. It is performant for our needs and allows our development staff to work in a familiar language for them, reducing our technical debt and improving our response time. We manipulate our data on the client and package it for export or import to our primary RDBMS solution. The extra data transformation tools SQLite has available made it an easy choice to make use of.

Pros

Direct data transformation from JSON/CSV to table
Easy to format data exported to desired layout and file type
Direct ingestion from Rest API
Familiar language syntax for SQL Server developers

Cons

Lack of procedures makes for convoluted data manipulation via nested triggers
Linked Server with MySQL/SQL Server would be very much appreciated
Basic Table manipulation, not drop and recreate

Most Important Features

Direct JSON/CSV integration
Portability. We can develop on multiple platforms, then ship and get the same consistent behavior
Performant. Some of our integrations are in processed in real time from our internal application to an external source. If SQLite were not performant, we would explore an alternative solution.

Return on Investment

We have had to invest more time in our staff to learn and make use of SQLite properly
We have incurred more technical debt as we have introduced additional technology and complexity to our systems.
We are able to respond more rapidly to our end users needs.

Alternatives Considered

MySQL, PostgreSQL and Microsoft SQL Server

Other Software Used

Microsoft SQL Server, Google Cloud SQL, Azure SQL Database

Peter Chapman

Senior System Architect in Information Technology at Conglomo Limited (1-10 employees employees)

Use Cases and Deployment Scope

SQLite is my number one choice when I am looking for an embedded database for any cross platform solution. With SQLite, we have been able to create one database model and deploy it across all platforms, including mobile, desktop, and embedded systems. I have not found a better supported multi-platform solution than SQLite. For example, in a recent mobile app upgrade, we were able to roll out full text search across iOS, macOS, Windows, and Android, all from a prepopulated database generated once and deployed multiple times.

Pros

Compatibility across many platforms
Speed and low resource use
Full Text Search out of the box
Excellent user community and adoption across the industry

Cons

Scaling beyond embedded instances will require moving to another platform
Vendor supplied tools are not as comprehensive as other RDBMS solutions
The documentation lacks the professional polish of its competitors

Most Important Features

Excellent compatiblity
Wide range of supported platforms
Excellent feature set
Impressive speed and fault tolerance

Return on Investment

No licensing fees has a net increase on ROI
The active community has kept support costs low, further increasing ROI
The wide range of supported platforms and high level of compatibility has increased ROI by reducing time spent porting the database model to any platform specific solutions.

Other Software Used

Microsoft SQL Server, MariaDB Platform, MySQL

Mantosh Kumar

Consultant in Professional Services at Capgemini (10,001+ employees employees)

Pros

It supports many cross-platform like iOS, Android, MAC, Windows projects
It is open source, and all code are public, developers can easily modify.
Easy to integrate in existing or new projects

Cons

In many case SQLite wont support Relational database feature.
If a application which scale-out very fast, for that type of project we need to use carefully

Most Important Features

It is free and open source
Easy in implement so it save time
Document are available for its Query
It have large community’s

Return on Investment

Same SQLite structure we are using for both iOS and Android. So it save lot's of time to design Database Schema.
It support for JSON data
We can do manipulation into external file as well. (eg CSV files)

Alternatives Considered

Realm and VistaDB

Other Software Used

Realm, VistaDB, FirebirdSQL