Categorized | News

SQLite: embeddable SQL engine for PHP-Gtk Apps

Posted on 10 March 2003 by Demian Turner

If you read PHPkitchen’s last article about desktop GUI apps in PHP (and checked the comments for tips on  creating PHP .exe installers) then you’ll be interested in the SQLite project over on Sourceforge.

SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. The 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.

SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.

And check out the features!

  • Implements most of SQL92
  • A complete database (with multiple tables and indices) is stored in a single disk file
  • Two times faster than PostgreSQL and MySQL for many common operations
  • Supports databases up to 2 terabytes
  • Small memory footprint
Bookmark and Share

Leave a Reply



Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists



PHPkitchen recommends you also check out the following sites :

Accounting for Small Businesses

FreeAgent sign-up