SQLite logo

SQLite

A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine
3.5K
2.7K
+ 1
505

What is SQLite?

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
SQLite is a tool in the Databases category of a tech stack.

Who uses SQLite?

Companies
462 companies reportedly use SQLite in their tech stacks, including Typeform, Intuit, and Accenture.

Developers
2938 developers on StackShare have stated that they use SQLite.

SQLite Integrations

Amazon DynamoDB, Amazon Redshift, Liquibase, peewee, and Slick are some of the popular tools that integrate with SQLite. Here's a list of all 65 tools that integrate with SQLite.

Why developers like SQLite?

Here鈥檚 a list of reasons why companies and developers use SQLite
SQLite Reviews

Here are some stack decisions, common use cases and reviews by companies and developers who chose SQLite in their tech stack.

Pran B.
Pran B.
Fullstack Developer at Growbox | 6 upvotes 27.4K views
Flutter
Flutter
Cloud Firestore
Cloud Firestore
SQLite
SQLite

Goal/Problem: A small mobile app (using Flutter ) for saving data offline ( some data offline) and rest data need to be synced with Cloud Firestore Tools: Cloud Firestore , SQLite Decision/Considering/Need suggestions: There is no state management in the app yet. There is a requirement to store some data offline and it should be available easily (when the phone is offline) and some data needs to stored in the cloud. I am considering using sqlflite for phone storage and firestore to sync and manage the online database. I am using flutter to build the app, I couldn't find a reliable way to use firestore cache for reading the data when phonphone is offline. So I came up with the above solution. Please suggest is this good?

See more
Daniel Quinn
Daniel Quinn
Senior Developer at Workfinder | 2 upvotes 35.6K views
atThe Paperless ProjectThe Paperless Project
SQLite
SQLite
PostgreSQL
PostgreSQL

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 .

See more
Midhun Harikumar
Midhun Harikumar
Senior Associate at Cognizant Technology Solutions | 1 upvotes 14.2K views
SQLite
SQLite
Gradle
Gradle
Groovy
Groovy

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.

See more
Eric Kryski
Eric Kryski
Creator at DeliciousDB | 1 upvotes 4.4K views
atDeliciousDBDeliciousDB
SQLite
SQLite

We support SQLite databases so that developers can interact with their data. SQLite

See more
A. M. Douglas
A. M. Douglas
Full-stack web developer at XMLi5 Ltd | 1 upvotes 4.4K views
SQLite
SQLite

There's really no call for something heavier for this site. SQLite is simple, easy to use and quite reliable given its age. SQLite

See more
Sripathi Krishnan
Sripathi Krishnan
Founder at RDBTools | 1 upvotes 4.4K views
SQLite
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.

SQLite

See more

SQLite Alternatives & Comparisons

What are some alternatives to SQLite?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
LiteDB
Embedded NoSQL database for .NET. An open source MongoDB-like database with zero configuration - mobile ready
Firebase
Firebase is a cloud service designed to power real-time, collaborative applications. Simply add the Firebase library to your application to gain access to a shared data structure; any changes you make to that data are automatically synchronized with the Firebase cloud and with other clients within milliseconds.
See all alternatives

SQLite's Followers
2708 developers follow SQLite to keep up with related blogs and decisions.
Zaraki Kenpachi
Lalit Nayyar
nselmi7282
burak  karabekir
Richard Nitsche
M Can Y谋lmaz
Tien Dat Tran
Eder Mariano
Andreas Gawelczyk
Vladimir Djuricic