SQLite
SQLite is a C–language library that implements a small, fast, self–contained, high–reliability, full–featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.
SQLite is an in–process library that implements a self–contained, serverless, zero–configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high–profile projects.
The SQLite file format is stable, cross–platform, and backwards compatible and the developers pledge to keep it that way through at least the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems [1] [2] [3] and as a long–term archival format for data [4]. There are over 1 trillion (1e12) SQLite databases in active use [5].
Developer(s) : D. Richard Hipp
Initial release : 17 August 2000
Stable release : 3.33.0 (August 14, 2020)
Repository : www.sqlite.org/src/
Written in : C
Operating System : Cross–platform
Size : 699 KiB
Type : RDBMS (embedded)
License : Public domain
Website : sqlite.org
Features Of SQLite :
- Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
- Zero–configuration – no setup or administration needed.
- Full–featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions. (Omitted features)
- A complete database is stored in a single cross–platform disk file. Great for use as an application file format.
- Supports terabyte–sized databases and gigabyte–sized strings and blobs. (See limits.html.)
- Small code footprint: less than 600KiB fully configured or much less with optional features omitted.
- Simple, easy to use API.
- Fast: In some cases, SQLite is faster than direct filesystem I/O
- Written in ANSI–C. TCL bindings included. Bindings for dozens of other languages available separately.
- Well–commented source code with 100% branch test coverage.
- Available as a single ANSI–C source-code file that is easy to compile and hence is easy to add into a larger project.
- Self–contained : no external dependencies.
- Cross–platform: Android, *BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) are supported out of the box. Easy to port to other systems.
- Sources are in the public domain. Use for any purpose.
- Comes with a standalone command–line interface (CLI) client that can be used to administer SQLite databases.
SQLite source code is in the public–domain and is free to everyone to use for any purpose.
Download Link :
Click Here
How to Download and Install Guide : Click Here
SQLite Tutorial : Click Here
For Video Tutorial : Click Here
Source : sqlite.org