SQLite
375 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
Platforms
- Mac
- Windows
- Linux
- Android
- iPhone
- Self-Hosted
Features
SQLite News & Activities
Highlights All activities
Recent News
- Fla published news article about ProcessWire
- Paul published news article about SQLite
- Fla published news article about HeidiSQL
Recent activities
- OLUEVANOCAD liked SQLite
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...
- Anton Kylikov liked SQLite
- Derek Moore liked SQLite
- Peter Shinners liked SQLite
- sandeep85das liked SQLite
- Robin_P liked SQLite
- Sam Siroos liked SQLite
Featured in Lists
My Setup - All Apps and Software
Master List of all Apps and Software I use for both work and personal life.
Core, Development & Services
A list with 807 apps by AmileyaRyver without a description.
Apps for Productive Workstation
A list with 61 apps by deersplinter without a description.
What is SQLite?
SQLite information
Developed by
SQLite Consortium Licensing
Open Source and Free product.Rating
Average rating of 4.9Alternatives
74 alternatives listedNews
5 news article related to SQLiteBadge
Get an embeddable badge for SQLiteSupported Languages
Comments and Reviews
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]
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.
It has many drivers available in many programming languages.
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]
Easy to use, easy to backup, local database, fast, simple to manage, constantly improving, rock-solid, extensible, hackable, ...
It's nice with a simple and clean DB you could use for testing purposes and so on.