DALMP
Database Abstraction Layer for MySQL using PHP, (*1)
0% fat and extremely easy to use. Only connect to database when needed., (*2)
Examples and documentation at: http://docs.dalmp.com, (*3)
Clone the repository:, (*4)
$ git clone https://github.com/nbari/DALMP.git dalmp
To Install visit http://docs.dalmp.com/en/latest/Install.html, (*5)
Thanks
Many thanks Navicat for supporting Open Source projects., (*6)
, (*7)
Details
-
Dependecy Injector (DI) support, load once, trigger when required.
-
APC, Disk, Memcache, Redis.io cache support.
- Group caching cache by groups and flush by groups or individual keys.
-
Prepared statements ready, support dynamic building queries, auto detect types (i,d,s,b).
- Secure connections with SSL.
-
SQLite3 Encryption.
- Save sessions in database (mysql/sqlite) or a cache like redis/memcache/apc.
- Easy to use/install/adapt.
- Nested Transactions (SAVEPOINT / ROLLBACK TO SAVEPOINT).
- Support connections via unix_sockets.
- SQL queues.
- Export to CSV.
- Trace/measure everything enabling the debugger.
- Works out of the box with Cloud databases like Amazon RDS or Google cloud.
- Lazy database connection. Connect only when needed.
-
PSR-0 compliance.
Requirements
To use the cache features you need either the redis, memcache or APC extensions
compiled, otherwise disk cache will be used., (*8)
- Redis extension - http://github.com/nicolasff/phpredis
- Memcache PECL extencsion - http://pecl.php.net/package/memcache
- APC PECL extension - http://pecl.php.net/package/APC
If you want to store session encrypted then you need SQLite3 Encryption http://sqlcipher.net., (*9)
DALMP does not use PDO, so do not worry if your PHP does not have the pdo
extension., (*10)
On FreeBSD you can install DALMP from ports: /usr/ports/databases/dalmp, (*11)