Gladius DB / News: Recent posts

Gladius DB is the most efficient flatfile database engine written in pure PHP, it is compatible with a subset of intermediate SQL92 and does not need any additional library to work. It perfectly understands SQL (also MySQL variant) and is also supported through ADOdb Lite.
----

Gladius DB v0.8.1 is a Stable release which fixes some important bugs; database tables of previous versions will be automatically converted to the new v0.8.1 format. ... read more

Gladius DB is the most efficient flatfile database engine written in pure PHP, it is compatible with a subset of intermediate SQL92 and does not need any additional library to work. It perfectly understands SQL (also MySQL variant) and is also supported through ADOdb Lite.
----

Gladius DB v0.8.0 is a Stable release which fixes some important bugs; database tables of previous versions will be automatically converted to the new v0.8.0 format. ... read more

Gladius DB is the most efficient flatfile database engine written in pure PHP, it is compatible with a subset of intermediate SQL92 and does not need any additional library to work. It perfectly understands SQL (also MySQL variant) and is also supported through ADOdb Lite.
----

Gladius DB v0.7.0 is a Stable release which fixes some important bugs and extends some core functionalities; database tables of previous versions will be automatically converted to the new v0.7.0 format which introduces a minor change.... read more

Gladius DB is the most efficient flatfile database engine written in pure PHP, it is compatible with a subset of intermediate SQL92 and does not need any additional library to work. It perfectly understands SQL and is also supported through ADOdb Lite.
---

In this release some non-critical bugs regarding subqueries and query termination check.

The database files are fully backward compatible (and supported) since v0.5, no changes have been made to the database format.... read more

Gladius DB is the most efficient flatfile database engine written in pure PHP, it is compatible with a subset of intermediate SQL92 and does not need any additional library to work. It perfectly understands SQL and is also supported through ADOdb Lite.
---

In this release some non-critical bugs have been fixed and an implementation of some SQL aggregate function is available for testing. In future we plan to offer a consistent implementation of aggregate functions and GROUP BY clause.... read more

This is mostly a consolidation release, the ADOdb lite binding drivers for its v1.42 have been updated and example code for the "amy" SQL database has been added.
Don't forget to download the manual (available from previous releases), as it contains tutorial code and other examples.

The database files are fully backward compatible (and supported) since v0.5

Gladius DB was since the beginning designed with an adoDB API; now with the release of adoDB lite v1.40 the Gladius driver is part of the official release. The provviden driver (v0.3) works also with versions 0.4 and 0.5.

Many thanks to M.Dickenson for the great adoDB lite which is easing many programmers' tasks in the jungle of database systems.

http://adodblite.sourceforge.net/

This release contains several bugfixes and an important speedup. The code as been profiled and some optimization has been applied; there is a new statement available, RENAME TABLE.

Note: not backward compatible

This new release of Gladius DB, still in beta stage, fixes some bugs and possibly introduces others at the price of more features and optimizations.

Note to v0.2 users: the TEXT field implementation has changed and Gladius DB is not yet backward compatible, you will have to discard any database prior to v0.4 and use the new format.

I have begun profiling the code and I am individuating slow functions in order to optimize them. It is possible that radical changes will come with the next release as I plan to gain back the speed Gladius had in the beginning; this slowdown is due to more complex field implementations that allow differences between stored type and actual type, but the feature was needed to add scalability.... read more

This release fixes a few bugs and adds more speed to resultsets querying

Since this release Gladius DB now offers the TRUNCATE and SHOW statements and has been stabilized under many aspects; the adoDB lite works better than before, some bugs have been fixed and some other interfaces have been made more standard-compliant.

The updated manual is already available.

This is a stabilization release which fixes some bugs and some bad implementations; next releases will offer the SHOW and TRUNCATE statements, caching features, a better adoDB lite driver (with data dictionary features) and a more reliable software (new testers have joined).

The Gladius Reference Manual has been published and is available for download with release 0.1

http://sourceforge.net/project/showfiles.php?group_id=173938&package_id=199334&release_id=450373

Available formats are CHM (single file) and HTML (multiple files with javascript navigator).

Note: the manual is 70% complete, not yet finished

The latest Gladius package contains several bug fixes, improvements and upgrades; the date/time support has been enhanced, base arithmetic operations have been implemented and negative numbers are now correctly interpreted.

The latest update of Gladius fixes some bugs and adds the BETWEEN and IN features, without any nesting limit.

When all planned features will be implemented more work will be spent on tight SQL92 compliance and optimization. Last but not least, an embedded caching system will be experimentally implemented.

The main issue, relative to ORDER BY clauses, has been fixed in version 0.1.r50. It was due to PHP's array_multisort() usage that has now been replaced by a custom algorithm for sorting.

Gladius v0.1.r46 works pretty well and is as fast as MySQL! (with small quantities of data)

With this release some bugs have been fixed and other optimizations have been applied.

Download it from the files section

http://prdownloads.sourceforge.net/gladius/gladius-v0.1.r45-preview.zip?download

UPDATE and ORDER BY issues have been fixed; the UNIQUE constraint now works and the internal cache is no more corrupted when deleting records. Other improvements can be read browsing the always up-to-date Subversion tree.

Please download and send bugs/comments

http://prdownloads.sourceforge.net/gladius/gladius-v0.1.39-preview.zip?download

The v0.1 r39 preview release is now available for download; this is a direct snapshot of the SVN tree, please note that it is NOT working properly in some parts and probably contains bugs.

I have decided to release this work-in-progress snapshot to get some help on testing and to let you "taste" what the final product will be. Notice the appalling speed and the support of most common SQL syntax.