LDBI is a PHP library to handle local databases and
can serve as low level interface to a PHP SQL library.
It supports indices, sequences and wildcard searches.
Right now it can handle just numbers (intergers, floats
and so on) and strings, it has no been tested against
It includes a small library to parse and execute SQL statements,
Comments, suggestion, bug reports, contributions and any kind of communications are appreciated, please send them to <scain at firenze.net>
0.0.1: First release
0.0.2: Has been added a new method to the class LDBI: load_tables opens all the tables of a database. An SQL parser has been added: SQLi, read the documentation included in the tarball.
0.1.0: Support added for UPDATE, INSERT, CREATE INDEX, CREATE DATABASE. A new method has been added: flush(), it updates the indices.
0.1.1: Support added for CREATE SEQUENCE and sequence handling functions (nextval, currval). For the moment it's limited to UPDATE and INSERT statements (not where clauses).
Added a documentation file for the SQL statements supported by SQLi.
0.1.2: Support added for DROP TABLE, DROP SEQUENCE, DROP INDEX, DROP DATABASE, DELETE, TRUNCATE. A lot of bugfixes.
0.1.3:: Support added for SHOW TABLES, SHOW SEQUENCES, SHOW INDICES, SHOW DATABASES, USE. A lot of bugfixes. And a new example program: a tiny, usefull SQLi interactive shell.
0.2.0: support for <, >, <=, >= and != have been added. Query parsing is now generic and scalable. A simple/buggy caching method have been implemented for SELECT queries. Functions that operate on sequences (nextval(), currval()) now could be used in where clauses. Lot of important bugfixes. Documentation updates
0.2.1: added a shell script to install LDBI and SQLi. Implemented a new locking method. Locking of the description files has been implemented. Added a statement to clear the results cache. Some bug fix.
0.2.2: now wildcard searches are possible even on not-indexed columns.
0.2.3: ported to the dba API
PHP LDBI is released under the terms of the GNU General Public License v2, it's freesoftware, that means you can modify the code, redistribute it and even send me modifications to be included in the main tree. When you redistribute the code don't forget to make it available under GPL v2 and to include my name as copyright owner of the software. Redistribution in binary forms only is not permitted. These terms and more are included in the GPL v2, you can get a copy from the Free Software Foundation.
Author: Patrizio Bruno <scain at firenze.net>