Add it to your Download Basket!
Add it to your Watch List!
What's new in SQLite 22.214.171.124:
- Fix a bug in the sorting logic, present since version 3.8.4, that can cause output to appear in the wrong order on queries that contains an ORDER BY clause, a LIMIT clause, and that have approximately 60 or more columns in the result set. Ticket f97c4637102a3ae72b79.
- SQLITE_SOURCE_ID: "2015-01-20 16:51:25 f73337e3e289915a76ca96e7a05a1a8d4e890d55"
- SHA1 for sqlite3.c: 33987fb50dcc09f1429a653d6b47672f5a96f19e
- LICENSE TYPE:
- Public Domain
- OUR RATING:
- DEVELOPED BY:
- D. Richard Hipp
- USER RATING:
- ROOT \ Database \ Database Engines
Features at a glance
Key features include support for isolated, atomic,durable and consistent transactions, SQL92 implementation, database files can be freely shared between computers, supports databases up to 2 terabytes, support for gigabyte-sized blobs and strings, small code footprint, as well as an easy-to-use and very simple API (Application Programming Interface).
Additionally, SQLite does not require initial configuration or further administration, allows developers to store a complete database in a single, cross-platform disk file, which is perfect for using application file formats, has no external dependencies, comes with built-in TCL (Tool Command Language) bindings, and comprehensive documentation.
Bindings for numerous other programming languages are available separately. Its source code is well-commented and it comes with a standalone CLI (Command-line Interface) client that has been designed from the offset to be used for the administration of SQLite databases.
What can I use it for?
The SQLite database engine can be used for any purpose, personal or commercial. Suggested uses for SQLite include database for gadgets, website database, stand-in for an enterprise RDBMS (Relational Database Management System), as well as application file format.
Under the hood and supported OSes
The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library. It is written entirely in the ANSI-C programming language.
Supported desktop operating systems include GNU/Linux, Mac OS X and Microsoft Windows. Supported mobile operating systems include Android and iOS. It has been successfully tested with both 32-bit and 64-bit hardware platforms, and it’s easily portable to other OSes.
SQLite was reviewed by Marius Nestor, last updated on January 21st, 2015