SQLite three . 8 .

Developer: License / Value : Size / OS: Binary Format : Very last Current : Category More systems Freeware / $ 351 KB / Mac OS X - August twenty eighth, 2013, 12 : fifty eight UTC [ see background ] Residence / Developer Resources

SQLite is a library that implements an embedded, zero configuration SQL database engine and does not have a independent server procedure.

SQLite is capable to go through and publish to ordinary disk documents right and delivers a total SQL database answer. SQLite in able to place in a one disk file many tables, indices, triggers and views.

In this article are some crucial functions of "SQLite":

· Transactions are atomic, consistent, isolated, and long lasting (ACID) even soon after method crashes and energy failures.
· Zero-configuration - no setup or administration necessary.
· Implements most of SQL92. ( Characteristics not supported)
· A total databases is saved in a solitary cross- platform disk file.
· Supports terabyte-sized databases and gigabyte-sized strings and blobs. (See limits.html.)
· Little code footprint: less than 350KiB fully configured or a lot less than 200KiB with optional features omitted.
· Quicker than well-known client /server databases engines for most widespread operations.
· Basic, simple to use API.
· Prepared in ANSI-C. TCL bindings incorporated. Bindings for dozens of other languages readily available independently.
· Effectively -commented supply code with a hundred % branch examination coverage.
· Offered as a one ANSI-C resource -code file that you can easily fall into an additional task.
· Self-contained: no external dependencies.
· Resources are in the general public area. Use for any function.
· Comes with a standalone command-line interface (CLI) customer that can be employed to administer SQLite databases.

What is New in This Launch : [ go through entire changelog ]

· Incorporate support for partial indexes
· Reduce - in excess of to the upcoming era question planner for more quickly and much better question programs.
· The Describe Question Prepare output no for a longer time displays an estimate of the range of rows produced by every loop in a sign up for.
· Extra the FTS4 notindexed option, making it possible for non-indexed columns in an FTS4 desk.
· Extra the SQLITE_STMTSTATUS_VM_ Move selection to sqlite3_stmt_ status ().
· Extra the cache_spill pragma.
· Included the query _only pragma.
· Additional the defer_ international _keys pragma and the sqlite3_db_ standing (db, SQLITE_DBSTATUS_DEFERRED_FKS,...) C-language interface.
· Added the "percentile()" purpose as a loadable extension in the ext/misc subdirectory of the source tree.
· Extra the SQLITE_ Enable _URI_AUTHORITY compile-time solution.
· Incorporate the sqlite3_ terminate _ automobile _extension(X) interface.
· A jogging Decide on statement that lacks a FROM clause (or any other statement that by no means reads or writes from any database file) will not protect against a examine transaction from closing.
· Add the SQLITE_DEFAULT_ Automated _IN...

Via: SQLite 3.8.0