DALMP

Database Abstraction Layer for MySQL using PHP

0% fat and extremely easy to use. Only connect to database when needed.

Clone the repository:

$ git clone git://github.com/nbari/DALMP.git dalmp

See also

Install

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

• PHP >= 5.4
• A MySQL server to connect via host or unix sockets.

To use the cache features you need either the redis, memcache or APC extensions compiled, otherwise disk cache will be used.

• 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).

DALMP does not use PDO, so do not worry if your PHP does not have the pdo extension.

On FreeBSD you can install DALMP from ports: /usr/ports/databases/dalmp

Table of Contents

• DALMP
  • What & Why DALMP
• Download
• Install
  • Composer
• Quick Start
  • DSN format
  • DSN Cache format
  • Common methods
  • DALMP Classes
  • Examples
  • SSL
  • Example using a socket
  • Example using cache (memcache)
  • Example using DSN cache (redis)
• DALMP\Database
  • AutoExecute
  • Cache
  • CacheFlush
  • Close
  • CompleteTrans
  • __construct
  • csv
  • debug
  • ErrorMsg
  • ErrorNum
  • Execute
  • FetchMode
  • forceTruncate
  • getAll / PgetAll
  • getASSOC / PgetASSOC
  • getCol / PgetCol
  • getOne / PGetOne
  • getRow / PgetRow
  • getClientVersion
  • getColumnNames
  • getNumOfFields
  • getNumOfRows
  • getNumOfRowsAffected
  • getServerVersion
  • Insert_Id
  • isConnected
  • map
  • multipleInsert
  • PClose
  • PExecute
  • Pquery
  • Prepare
  • qstr
  • Query
  • renumber
  • RollBackTrans
  • StartTrans
  • useCache
  • UUID
  • X
• DALMP\Cache
  • CacheInterface
  • APC
  • Disk
  • Memcache
  • Redis
• DALMP\Queue
  • QueueInterface
  • SQLite
• DALMP\Sessions
  • __construct
  • Files
  • Memcache
  • MySQL
  • Redis
  • SQLite
  • regenerate_id
  • getSessionsRefs
  • getSessionRef
  • delSessionRef
  • Example
• Prepared statements
  • Examples
• Dependency injection
  • abstractDI
  • DI
  • Example
• Tests
• Examples
• Issues
• Navicat
  • Thanks

Thanks Navicat for supporting Open Source projects.

A great amount of time has been spent creating, crafting and maintaining this software, please consider donating.

Donating helps ensure continued support, development and availability.

comments powered by Disqus