monolyth/dabble

PHP5 database abstraction layer

Sunday, July 17, 2016
by monomelodies
Repository
1 Watchers
0 Stars
27 Installations

PHP
0 Dependents
0 Suggesters
0 Forks
0 Open issues
35 Versions
4 % Grown

The README.md

Dabble

PHP5 database abstraction layer. Writing SQL by hand is fine craft, but often it's more convenient to juggle arrays, e.g. to dynamically add conditions. Using Dabble this is made easy, while still allowing you to write literal SQL where you need., _(*1)

Dabble is an extension of PHP's native PDO class, so should work with any existing code seamlessly., _(*2)

Installation

Using Composer (recommended)

composer install --save monolyth/dabble

Manual

Download or clone the library. Register the /path/to/dabble/src for the namespace prefix Monolyth\Dabble in your autoloader., _(*3)

Setting up a connection

Instantiate a Dabble database object using your credentials:, _(*4)

<?php

use Monolyth\Dabble\Adapter\Mysql;

$db = new Mysql($dsn, $user, $pass, $options);

The database type (e.g. mysql: in the above example) is added to the $dsn string by Dabble., _(*5)

The actual connection is opened in a just-in-time manner; hence, feel free to define as many Dabble adapters as you like (e.g. large sites connecting to various databases depending on the route). Connections aren't opened until the adapter is actually used. This allows you to define all your adapters in a central place., _(*6)

Querying

Dabble supports four 'main' types of queries: select, insert, update and delete. These have corresponding method names on the Dabble\Adapter object. They all follow a similar syntax where argument one is the table name, and further arguments are arrays of key/value pairs., _(*7)

There are also helper classes that these are actually a front for., _(*8)

Of course, regular PDO methods are also available for fine-grained tuning., _(*9)

FAQ

Can I use Dabble in combination with [insert ORM library]?

Sure - as long as your library uses PDO. Dabble is simply an extension to PDO, so you should be good to go., _(*10)
What's the name "Dabble" at?

It's a sort-of portmanteau of "database abstraction layer". And it sounded cute :), _(*11)
How well-tested is the codebase?

Some of code dates back 10 years. Dabble is based on the database abstraction layer shipped in the Monolyth framework up to version 5. This in turn is based on code lifted from CU2 which Marijn's company owned from 2009 to 2014., _(*12)

So yes, it's pretty well tested in the real world :), _(*13)

The Versions

17/07 2016

dev-master

9999999-dev

PHP5 database abstraction layer

library dabble

PHP5 database abstraction layer

monolyth/dabble

The README.md

Dabble

Installation

Using Composer (recommended)

Manual

Setting up a connection

Querying

FAQ

Can I use Dabble in combination with [insert ORM library]?

What's the name "Dabble" at?

How well-tested is the codebase?

The Versions

dev-master

The Requires

The Development Requires

by Marijn Ophorst

1.6.2

The Requires

The Development Requires

by Marijn Ophorst

1.6.1

The Requires

The Development Requires

by Marijn Ophorst

1.6.0

The Requires

The Development Requires

by Marijn Ophorst

1.5.5

The Requires

The Development Requires

by Marijn Ophorst

dev-develop

The Requires

The Development Requires

by Marijn Ophorst

1.5.4

The Requires

The Development Requires

by Marijn Ophorst

1.5.3

The Requires

The Development Requires

by Marijn Ophorst

1.5.2

The Requires

The Development Requires

by Marijn Ophorst

1.5.1

The Requires

The Development Requires

by Marijn Ophorst

1.5.0

The Requires

The Development Requires

by Marijn Ophorst

1.4.0

The Requires

The Development Requires

by Marijn Ophorst

1.3.0

The Requires

The Development Requires

by Marijn Ophorst

1.2.6

The Requires

The Development Requires

by Marijn Ophorst

1.2.5

The Requires

The Development Requires

by Marijn Ophorst

1.2.4

The Requires

The Development Requires

by Marijn Ophorst

1.2.3