1DALMP
2=====
3
4**Database Abstraction Layer for MySQL using PHP**
5
60% fat and extremely easy to use. Only connect to database when needed.
7
8Clone the repository:
9
10.. code-block:: sh
11
12   $ git clone git://github.com/nbari/DALMP.git dalmp
13
14.. seealso::
15
16   `Install </en/latest/Install.html>`_
17
18
19Details
20.......
21
22* `Dependecy Injector </en/latest/DI.html>`_ (DI) support, load once, trigger when required.
23* `APC </en/latest/cache/APC.html>`_, `Disk </en/latest/cache/disk.html>`_, `Memcache </en/latest/cache/memcache.html>`_, `Redis.io </en/latest/cache/redis.html>`_ cache support.
24* Group `caching cache </en/latest/cache.html>`_ by groups and flush by groups or individual keys.
25* `Prepared statements </en/latest/prepared_statements.html>`_ ready, support dynamic building queries, auto detect types (i,d,s,b).
26* Secure connections with `SSL </en/latest/Quickstart.html#ssl>`_.
27* `SQLite3 Encryption <http://sqlcipher.net>`_.
28* Save sessions in database (mysql/sqlite) or a cache like redis/memcache/apc.
29* Easy to use/install/adapt.
30* Nested `Transactions </en/latest/database/StartTrans.html>`_ (SAVEPOINT / ROLLBACK TO SAVEPOINT).
31* Support connections via `unix_sockets </en/latest/Quickstart.html#example-using-a-socket>`_.
32* SQL `queues </en/latest/queue.html>`_.
33* Export to `CSV </en/latest/database/csv.html>`_.
34* Trace/measure everything enabling the `debugger </en/latest/database/debug.html>`_.
35* Works out of the box with Cloud databases like `Amazon RDS <http://aws.amazon.com/rds/>`_ or `Google cloud <https://developers.google.com/cloud-sql/>`_.
36* Lazy database connection. Connect only when needed.
37* `PSR-0 <http://www.php-fig.org/psr/psr-0/>`_ compliance.
38
39
40Requirements
41............
42
43* `PHP <http://www.php.net>`_ >= 5.4
44
45* A `MySQL <http://www.mysql.org>`_ server to connect via host or `unix sockets. <http://en.wikipedia.org/wiki/Unix_domain_socket>`_
46
47To use the cache features you need either the redis, memcache or APC extensions
48compiled, otherwise disk cache will be used.
49
50* Redis extension - http://github.com/nicolasff/phpredis
51* Memcache PECL extencsion - http://pecl.php.net/package/memcache
52* APC PECL extension - http://pecl.php.net/package/APC
53
54If you want to store session encrypted then you need SQLite3 Encryption
55(http://sqlcipher.net).
56
57**DALMP** does not use `PDO <http://www.php.net/pdo>`_, so do not worry if your PHP does not have the pdo
58extension.
59
60On `FreeBSD <http://www.freebsd.org>`_ you can install **DALMP** from ports: /usr/ports/databases/dalmp
61
62
63Table of Contents
64=================
65
66.. toctree::
67   :maxdepth: 2
68
69   about
70   Download
71   Install
72   Quickstart
73   database
74   cache
75   queue
76   sessions
77   prepared_statements
78   DI
79   tests
80   examples
81   issues
82   navicat
83