Personal View #8

History of SQLite:

SQLite is a mostly ACID-compliant relational database management system contained in a relatively small (~500kB) C programming library.

Unlike client-server database management systems, the SQLite engine is not a standalone process with which the program communicates. Instead, the SQLite library is linked in and thus becomes an integral part of the program. The program uses SQLite's functionality through simple function calls, which reduces latency in database access as function calls are more efficient than inter-process communication. The entire database (definitions, tables, indices, and the data itself) is stored as a single cross-platform file on a host machine. This simple design is achieved by locking the entire database file at the beginning of a transaction.

SQLite was created by D. Richard Hipp, who sells training, direct technical support contracts and add-ons such as compression and encryption. The source code for SQLite is in the public domain.

The program was originally developed by Mauricio Piacentini from Tabuleiro Produções, a Brazilian company, as the Arca Database Browser. The original version is a free companion tool to Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions for handling of compressed and binary data.
The original code was later adjusted to be compatible with standard SQLite 2.x databases. The resulting program was renamed SQLite Database Browser, and released into the public domain by the original author. Icons were contributed by Raquel Ravanini, also from Tabuleiro.