Flick DB

Flick DB, also known as FDB, is a PHP-based flat file database that uses XML files for storage and management of data. I created it to use as an alternative for hosts that don't offer MySQL. FDB is very flexible and the only requirement for use is PHP and the SimpleXML extension, which comes installed by default in recent versions.

Unlike some flat file databases, with Flick DB you can manage your databases easily. Instead of keeping everything in one large flat file, it creates an XML flat file for each table. On top of that the tables are further organized into directories for each database. Of course, you have the select, insert, update, delete, and truncate commands, as well as the ability to create, drop and clear tables and databases.

Flick DB also has its own built-in control panel where you can perform various tasks, such as managing the databases in a broader view, backing up files as well as configuring global settings. This makes managing FDB much easier since it saves you the task of having to go through FTP or your web hosting control panel to make changes.

Known Issues

The control panel's user interface may be a bit clunky because its development was rushed quite a bit. The database management feature is not complete yet.

Sorting algorithm does not work as intended. If you try to specify an order clause when performing a select operation, it will not work correctly.

If FDB is not writing to the XML flat files, make sure that the directory fdb/db has write permissions. If not, chmod'ing it to 777 should resolve the issue.

Downloads

Flick DB