2017 © Pedro Peláez
 

library sql-class

A simple database abstraction layer, with an on disk caching facility.

image

duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  • Monday, January 22, 2018
  • by duncan3dc
  • Repository
  • 1 Watchers
  • 4 Stars
  • 70,871 Installations
  • PHP
  • 1 Dependents
  • 0 Suggesters
  • 2 Forks
  • 0 Open issues
  • 67 Versions
  • 1 % Grown

The README.md

sql-class

A simple database abstraction layer, with an on disk caching facility., (*1)

Full documentation is available at http://duncan3dc.github.io/sql-class/
PHPDoc API documentation is also available at http://duncan3dc.github.io/sql-class/api/, (*2)

Build Status Latest Version, (*3)

Examples

The classes use a namespace of duncan3dc\SqlClass, (*4)

use duncan3dc\SqlClass\Sql;

$sql = new Sql([
    "mode"      =>  "mysql",
    "hostname"  =>  "localhost",
    "username"  =>  "root",
    "password"  =>  "password",
]);

$row = $sql->select("table_1",[
    "field1"    =>  "one",
    "field2"    =>  "two",
]);

$sql->update("table_1",[
    "field3"    =>  "three",
],[
    "field1"    =>  $row["field1"],
    "field2"    =>  $row["field2"],
])

The Versions

22/01 2018

dev-master

9999999-dev https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

22/01 2018

1.8.2

1.8.2.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

14/09 2017

1.8.1

1.8.1.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

27/02 2017

1.8.0

1.8.0.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

11/02 2017

1.7.3

1.7.3.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

20/12 2016

1.7.2

1.7.2.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

18/10 2016

1.7.1

1.7.1.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

19/08 2016

1.7.0

1.7.0.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

17/07 2016

1.6.18

1.6.18.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

27/01 2016

1.6.17

1.6.17.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

21/01 2016

1.6.16

1.6.16.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

21/12 2015

2.0.x-dev

2.0.9999999.9999999-dev https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

28/10 2015

1.6.14

1.6.14.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

26/10 2015

1.6.13

1.6.13.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

14/10 2015

1.6.12

1.6.12.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

30/06 2015

dev-table-class

dev-table-class https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

The Development Requires

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

06/06 2015

1.6.11

1.6.11.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

19/05 2015

1.6.10

1.6.10.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

21/03 2015

1.6.9

1.6.9.0 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

21/03 2015

dev-2.0-query-builder

dev-2.0-query-builder https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

21/03 2015

dev-2.0-event-emitter

dev-2.0-event-emitter https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

10/02 2015

dev-2.0-db2

dev-2.0-db2 https://github.com/duncan3dc/sql-class

A simple database abstraction layer, with an on disk caching facility.

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

12/12 2014

1.6.8

1.6.8.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

09/12 2014

1.6.7

1.6.7.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

08/12 2014

1.6.6

1.6.6.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

06/12 2014

1.6.5

1.6.5.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

05/12 2014

1.6.4

1.6.4.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

01/12 2014

1.6.3

1.6.3.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

14/11 2014

1.6.2

1.6.2.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

01/11 2014

1.6.1

1.6.1.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

28/10 2014

1.6.0

1.6.0.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

25/10 2014

1.5.4

1.5.4.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

13/10 2014

1.5.3

1.5.3.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

04/09 2014

1.5.2

1.5.2.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

03/09 2014

1.5.1

1.5.1.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

17/08 2014

1.5.0

1.5.0.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

13/08 2014

1.4.0

1.4.0.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

07/08 2014

1.3.6

1.3.6.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

05/08 2014

1.3.5

1.3.5.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

01/08 2014

1.3.4

1.3.4.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

31/07 2014

1.3.3

1.3.3.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

30/07 2014

1.3.2

1.3.2.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

30/07 2014

1.3.1

1.3.1.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

28/07 2014

1.3.0

1.3.0.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

07/07 2014

1.2.3

1.2.3.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

05/07 2014

1.2.2

1.2.2.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

04/07 2014

1.2.1

1.2.1.0 https://github.com/duncan3dc/sql-class

A group of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

04/07 2014

1.2.0

1.2.0.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

02/07 2014

1.1.9

1.1.9.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

02/07 2014

1.1.8

1.1.8.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

29/06 2014

1.1.7

1.1.7.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

29/06 2014

1.1.6

1.1.6.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

29/06 2014

1.1.5

1.1.5.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

26/06 2014

1.1.4

1.1.4.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

22/06 2014

1.1.3

1.1.3.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

22/06 2014

1.1.2

1.1.2.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

20/06 2014

1.1.1

1.1.1.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

20/06 2014

1.1.0

1.1.0.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

04/06 2014

1.0.8

1.0.8.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

31/05 2014

1.0.7

1.0.7.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

30/05 2014

1.0.5

1.0.5.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

30/05 2014

1.0.6

1.0.6.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

30/05 2014

1.0.4

1.0.4.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

12/05 2014

1.0.3

1.0.3.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

11/05 2014

1.0.2

1.0.2.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

09/05 2014

1.0.1

1.0.1.0 https://github.com/duncan3dc/sql-class

A pair of classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download

Apache-2.0

The Requires

  • php >=5.3.0

 

by Craig Duncan

database sql cache postgres mssql mysql mysqli abstraction sqlite odbc redshift

08/05 2014

1.0.0

1.0.0.0

A pair of PHP classes that provide a simple database abstraction layer, and an on disk caching facility

  Sources   Download