Why developers like SQLite

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

579 companies reportedly use SQLite in their tech stacks, including Alibaba Travels, Accenture, and ViaVarejo.

Alibaba Travels

Accenture

ViaVarejo

Typeform

Pratilipi

Intuit

Oxylabs

doubleSlash

Runtastic

Developers

8419 developers on StackShare have stated that they use SQLite.

jimmycuadra.com

Favorites

Evandro Magalhães

SaaS

ktra

Lubert

ytnobody

Personal

Hitalo Silva

SQLite Integrations

Slick, Amazon DynamoDB, Amazon Redshift, Sequelize, and Strapi are some of the popular tools that integrate with SQLite. Here's a list of all 75 tools that integrate with SQLite.

Slick

Amazon DynamoDB

Amazon Redshift

Sequelize

Strapi

Prisma

Liquibase

DataGrip

MSSQL

Pros of SQLite

160

134

121

Preinstalled on iOS and Android

Portable A database on my USB 'love it'

Free

Tcl integration

Telefon

Public Decisions about SQLite

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

Dimelo Waterson

at (hobbyist) · Nov 5, 2020 | 7 upvotes · 39.1K views

Shared insights

PostgreSQL

MySQL

SQLite

I need to add a DBMS to my stack, but I don't know which. I'm tempted to learn SQLite since it would be useful to me with its focus on local access without concurrency. However, doing so feels like I would be defeating the purpose of trying to expand my skill set since it seems like most enterprise applications have the opposite requirements.

To be able to apply what I learn to more projects, what should I try to learn? MySQL? PostgreSQL? Something else? Is there a comfortable middle ground between high applicability and ease of use?

S M

Nov 16, 2020 | 2 upvotes · 628 views

Shared insights

Should I use PostgreSQL or MySQL for a SQL database? I already use MongoDB and SQLite but SQLite doesn't meet my criteria. I know PostgreSQL and MySQL are very popular databases. Note: I am not looking for a job, this is just for a personal project!

See all decisions

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

Related Comparisons