SQLite logo
A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine
2.9K
504
62

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
426 companies use SQLite in their tech stacks, including Typeform, Intuit, and Accenture.

Developers
2453 developers use SQLite.

SQLite Integrations

peewee, LINQPad, fake2db, Sequelize, and Knex.js are some of the popular tools that integrate with SQLite. Here's a list of all 21 tools that integrate with SQLite.

Why developers like SQLite?

Here’s 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.

Daniel Quinn
Daniel Quinn
Senior Developer at Founders4Schools · | 2 upvotes · 3K views
atThe Paperless ProjectThe Paperless Project
PostgreSQL
SQLite

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 · 3.3K views
Groovy
Gradle
SQLite

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 · 1.1K views
atDeliciousDBDeliciousDB
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 · 1.1K views
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 · 1.1K views
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
Kishan Reddy
Kishan Reddy
Python Fanatic | Django Dev · | 1 upvotes · 1.1K views
SQLite

I use SQLite because it has almost zero setup and works wonderfully for small POCs and MVPs

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 Stats

- No public GitHub repository available -