Currently, SQLite is one of the most used SQL flat-file database engines in the world.
SQLite is recommended for usage as a website database, stand-in enterprise RDBMS, application file format or a database for gadgets.
This page links to the source code of SQLite. For OS-specific binaries please see the Softpedia Global Page.
Here are some key features of "SQLite":
- Simple, easy to use API
- TCL bindings included
- Standalone command-line interface (CLI) client
- Atomic, consistent, isolated, and durable (ACID) transactions
- Implements most of SQL92
- A database is stored in a single file
- Database files can be freely shared between machines
- Supports databases up to 2 tebibytes (241 bytes) in size
- Strings and BLOBs up to 2 gibibytes (231 bytes) in size
- Small code footprint
- Faster than popular client/server database engines
- 98% test coverage.
- Available as a single ANSI-C source-code file
- Added the FTS4 notindexed option, allowing non-indexed columns in an FTS4 table.
- Added the SQLITE_STMTSTATUS_VM_STEP option to sqlite3_stmt_status().
- Added the cache_spill pragma.
- Added the query_only pragma.
- Added the defer_foreign_keys pragma and the sqlite3_db_status(db, SQLITE_DBSTATUS_DEFERRED_FKS,...) C-language interface.
- Added the "percentile()" function as a loadable extension in the ext/misc subdirectory of the source tree.
- Added the SQLITE_ALLOW_URI_AUTHORITY compile-time option.
- Add the sqlite3_cancel_auto_extension(X) interface.
- A running SELECT statement that lacks a FROM clause (or any other statement that never reads or writes from any database file) will not prevent a read transaction from closing.
- Add the SQLITE_DEFAULT_AUTOMATIC_INDEX compile-time option. Setting this option to 0 disables automatic indices by default.
- Issue an SQLITE_WARNING_AUTOINDEX warning on the SQLITE_CONFIG_LOG whenever the query planner uses an automatic index.
- Added the SQLITE_FTS3_MAX_EXPR...