What is phpLiteAdmin?

phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite2 and SQLite3. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single source file, phpliteadmin.php, that is dropped into a directory on a server and then visited in a browser. There is no installation required. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin.

Update 1/4/12

v1.9.1 is now available for download!

Features

• Lightweight - consists of a single 150KB source file for portability
• Supports SQLite3 with backwards-compatibility for SQLite2
• Create and delete databases
• Add, delete, rename, empty, and drop tables
• Browse, add, edit, and delete records
• Add, delete, and edit table columns
• Manage table indexes
• Manage table triggers
• Import and export tables, structure, indexes, and data
• View data as bar, pie, and line charts
• Graphical search tool to find records based on specified field values
• Create and run your own custom SQL queries in the free-form query editor/builder
• Easily apply core SQLite functions to column values using the GUI
• Write your own PHP functions to be available to apply to column values
• Secure password-protected interface with login screen and cookies
• Specify and manage an unlimited number of databases
• Specify a directory and optionally its subdirectories to scan for databases
• Allows multiple installations on the same server, each with a different password
• Design your own theme using CSS or install a pre-made theme from the community
• All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases

Installation

Installation is as simple as uploading the single source file, phpliteadmin.php, to a server and then visiting it with a web browser. The default password is 'admin' and can be changed to something more secure by opening and editing the file. Your databases are specified in an array at the top of the file, or you can specify a directory to scan for databases. A more detailed explanation can be found on the Installation page.

Out of the box and without even editing phpliteadmin.php, you can quickly manage an existing database by uploading phpliteadmin.php to the directory that the database resides in. Then, simply visit the uploaded phpliteadmin.php in a browser. The password will be the default, 'admin'.

Requirements

A server running PHP with at least one library extension that deals with SQLite is required (either PDO, SQLite3, or SQLiteDatabase). PHP version 5.3.0 and greater comes with the SQLite3 extension installed and enabled by default so no custom action is necessary. Otherwise, the extension can be installed manually.

Demo

A demo of phpLiteAdmin has been set up here (password is 'admin')