What is InsaneDB

InsaneDB is an database toolkit for PHP forked from CodeIgniter 3 database layer. Its goal is to remove limitations existing in the upstream version and add additional functionalities while keeping sync with CodeIgniter. It can be used standalone or as a replacement for the CodeIgniter database layer.

Release Information

First official version released.

Documentation is about to be updated.

Changelog and New Features

You can find a list of all changes in the upstream version in the user guide change log.

InsaneDB

Initial Release Date: 14.10.2018

New features

• Added Read/Write connections mode.
• Read delay option in Read/Write connections mode.
• Automatic reconnect on dropped connection for the MySQL and PostgreSQL drivers.

Improvements

• PDO adapter drivers replacing all vendor specific drivers(where applicable).
• Added option for manual setting the size of the batch query functions.
• General simplifications of the configuration file.
• Removed ['compress'] and ['encrypt'] options, they can be passed by the new ['options'] variable.
• Improved reconnect(), now working for all the drivers.
• Improved num_rows(), should be faster for big result sets.
• Added option which keys to be included in update_batch(), insert_batch() and insert_ignore_batch().

Bug fixes

• Fixed a bug (#) - method close() didn't close a connection with valid result object.

Server Requirements

PHP version 7.1 or newer is required.

It is recommend to migrate to newer version of PHP sooner than later.

License

Please see the license agreement.