Flat-file SQL 1.3.1

It uses regular files, that can be placed anywhere, for storing data.

Installation

Include it in your script with require_once("fSQL.php");
Create a new fSQLEnvironment class with $fsql = new fSQLEnvironment;

Here are some key features of "Flat-file SQL":

· Allows you to take advantage of SQL queries to easily manipulate and extract data without having to do it manually using the native file API.
· Has a fully object-oriented API in which the methods are similiar to the mySQL API to avoid a lot of changes. This allows a program designed for mySQL to easily be ported to a flat-file system without any drastic changes.
· Supports all the essential SQL commands and mimics mySQL syntax and features as fully as possible.
· Offers some new and rare query commands such as SEARCH and MERGE to simplify other normally long tasks.

What's New in This Release: [ read full changelog ]

Improvements:
· The "AS" keyword is now optional when specifying alias in the SELECT expressions.
· Specifying an alias for a function call in a SELECT expression is now optional. If one is not specified, the column name will be the entire function call as a string.

Bug fixes:
· Fixed areas of query parsing to be more lenient on the amount of whitespace (specifically CREATE TABLLE and SELECT).
· Fixed bug that caused calls to the supported "aggregate" or "grouping' functions (count, max, min, sum) to fail.
· Fixed parsing bug in the SELECT expression list.