Flat-file SQL Publisher's description
from Kaja Fumei
This script provides a way to use SQL queries without having a database engine, like MySQL, installed.
It uses regular files, that can be placed anywhere, for storing data.
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: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.
В· 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.
Program Release Status: Major Update
Program Install Support: Install Only