SQLite icon
SQLite icon

SQLite

 383 likes

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

Cost / License

  • Free
  • Open Source

Application type

Since

  • Since 2009

Platforms

  • Windows
  • Mac
  • Linux
  • Self-Hosted
  • Android
  • iPhone
383likes
Save

Features

Properties

Features

Highlights All activities

SQLite News & Activities

Recent News

Recent activities

  • electrosenpai liked SQLite
  • NotedSuite-Apps liked SQLite
  • Mseven liked SQLite
  • ngoomie liked SQLite
  • Hamze Zare reviewed SQLite  

    We run two small Telegram bots on SQLite instead of a database server: one logs link and file requests, the other keeps a searchable archive of group messages using the FTS5 full-text extension. For a single-container service it is hard to beat. Backup is copying one file from a Docker volume, there is nothing to tune, and FTS5 handles keyword search well enough that we did not need a separate search engine. The catch is concurrency: with several writers you need WAL mode and short transactions...

  • Hamze Zare liked SQLite
  • humble-advisor liked SQLite
  • Omar Madhi liked SQLite
  • alternativeto-7kdgr liked SQLite
  • OLUEVANOCAD liked SQLite

Comments and Reviews

   
Most Recent Comment
Hamze Zare
0
Founder at fanpino

We run two small Telegram bots on SQLite instead of a database server: one logs link and file requests, the other keeps a searchable archive of group messages using the FTS5 full-text extension. For a single-container service it is hard to beat. Backup is copying one file from a Docker volume, there is nothing to tune, and FTS5 handles keyword search well enough that we did not need a separate search engine. The catch is concurrency: with several writers you need WAL mode and short transactions or you start seeing "database is locked" errors, so it is not the pick once a service needs more than one process writing at the same time.

Anton Kylikov
0
Founder at SpinHire

We run a job board on it - single file, no server process, and it has never lost data on us. The trap nobody warns you about is that the bundled build only case-folds ASCII: LIKE and upper() treat Cyrillic as case-sensitive, so searching a name in lowercase quietly misses the same name capitalised. You get wrong results, not an error, which is the worst kind of bug to find in production. The fixes are compiling with ICU or maintaining a normalised shadow column yourself. Worth knowing before you ship search in anything but English.

Samenaga
2

It has many drivers available in many programming languages.

3

One of its kind, very easy to work with, fast learning curve, very light footprint. Nice when working scripts, prototypes and desktop apps. Could be also a quick drop in as replacement instead of creating new custom binary file format.

[Edited by Sneetsher, October 25]

sailcraft
2

Easy to use, easy to backup, local database, fast, simple to manage, constantly improving, rock-solid, extensible, hackable, ...

Ola Johansson
2
CTO / Co-Founder at AlternativeTo

It's nice with a simple and clean DB you could use for testing purposes and so on.

Brajesh Kumar
4

One of my favorite database for small applications. I have used this for many application with VB.NET and Python.

[Edited by coolbkv, April 06]

Featured in Lists

My Setup - All Apps and Software

Master List of all Apps and Software I use for both work and personal life.
By Jimmy Briggs416 appsUpdated

Core, Development & Services

A list with 807 apps by AmileyaRyver without a description.
By AmileyaRyver807 appsUpdated

Apps for Productive Workstation

A list with 61 apps by deersplinter without a description.
By deersplinter61 appsUpdated

Official Links

Install from the command line

  • winget install -e --id SQLite.SQLite
  • brew install sqlite

Be careful what you paste into a terminal. Check what a command installs before running it.

What is SQLite?

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

SQLite information

AlternativeTo Category

Development

Popular alternatives

View all

Top SQLite apps (extensions / mods etc)

View all

Our users have written 7 comments and reviews about SQLite, and it has gotten 383 likes.

SQLite was added to AlternativeTo by jenocin on and this page was last updated .