PHP Text File Database

With the PHP Text File Interface (Txt-Db-API) you can access normal text files like an SQL Database. You don't need any special database software on the Web server, yet you can still use SQL calls. You can use the API to create, query, change, or delete SQL tables, and you don't have to bother with the text files themselves; almost everthing can be done with the supported API calls. The Txt-Db-API is object-oriented and very simple to use.

Release Notes: A large redesign was done to add functions support to the Txt-Db API. Easier SQL query syntax lets you use columns in WHERE, ORDER BY, and GROUP BY which aren't listed after SELECT. The columns just have to be in one of the tables which are in the FROM part. Support is included for the following functions (SELECT, INSERT, UPDATE, DELETE only): UNIX_TIMESTAMP, MD5, NOW, ABS, LCASE (or LOWER), and UCASE (or UPPER). Support was also added for the following grouping functions (SELECT only): MIN, MAX, COUNT, SUM, and AVG.

Release Notes: The latest alpha seems to work fine, so the API has beta status
now. Please note that this should be the most stable version of the
API at the moment. The old versions without "-Beta" (like "0.1.1")
aren't more stable. Windows newlines are supported now. Please note
that the txt-db-api still only writes Unix newlines, but tables which
contain Windows newlines are also read correctly now.