thiagodp

manderson10

database-js

  "description": "Common Database Interface",

    "url": "git+https://github.com/mlaanderson/database-js.git"

  "author": "Michael Anderson <michael@anderson-clan.org>",

    "Michael Anderson <michael@anderson-clan.org> (https://github.com/mlaanderson/)",

    "Thiago Delgado Pinto (https://github.com/thiagodp)"

    "url": "https://github.com/mlaanderson/database-js/issues"

  "homepage": "https://github.com/mlaanderson/database-js#readme"

[![Build Status](https://travis-ci.org/mlaanderson/database-js.svg?branch=master)](https://travis-ci.org/mlaanderson/database-js)

* [API](//github.com/mlaanderson/database-js/wiki/API)

* [Examples](//github.com/mlaanderson/database-js/wiki/Examples)

* [Drivers](//github.com/mlaanderson/database-js/wiki/Drivers)

* [In the Browser](//github.com/mlaanderson/database-js/wiki/Browsers)

Database-js was started to implement a common, promise-based interface for SQL database access. The concept is to copy the Java pattern of using connection strings to identify the driver. Then provide wrappers around the implemented functionality to commonize the syntax and results.

Thus if SQLite, MySQL and PostgreSQL all have a database named test with a table named states we can access the data the same way.

Database-js has built-in prepared statements, even if the underlying driver does not support them. It is built on Promises, so it works well with ES7 async code.

- [MySQL](//github.com/mlaanderson/database-js-mysql)

- [PostgreSQL](//github.com/mlaanderson/database-js-postgresql)

- [PostgreSQL](//github.com/mlaanderson/database-js-postgres)

- [SQLite](//github.com/mlaanderson/database-js-sqlite)

- [ActiveX Data Objects](//github.com/mlaanderson/database-js-adodb)

- [Firebase](//github.com/mlaanderson/database-js-firebase)

- [INI files](//github.com/mlaanderson/database-js-ini)

- [Excel files](//github.com/mlaanderson/database-js-xlsx)

- [CSV files](//github.com/mlaanderson/database-js-csv)

- [JSON files](//github.com/thiagodp/database-js-json)

[See here](https://github.com/mlaanderson/database-js/wiki/Drivers#implementing-a-new-driver) how to add a new driver.

var Connection = require('database-js').Connection;

var conn = new Connection("sqlite:///path/to/test.sqlite");

var statement = conn.prepareStatement("SELECT * FROM states WHERE state = ?");

statement.query("South Dakota").then((results) => {

var conn = new Connection("mysql://user:password@localhost/test");

var conn = new Connection("postgres://user:password@localhost/test");

Notice that in all three examples, the only difference is the connection URL.

Because database-js is built on Promises, it works very well with ES7 async functions. Compare the following ES7 code to the SQLite code from above. They accomplish the same thing.

		{
		"name": "database-js",
		"version": "3.0.2",
		"version": "3.0.3",
		"description": "Common Database Interface",
		@@ -14,11 +14,31 @@ "main": "index.js",
		"keywords": [
		"database",
		"database-js",
		"database-js-mysql",
		"database-js-postgres",
		"database-js-sqlite",
		"database-js-adodb",
		"database-js-firebase",
		"database-js-ini",
		"database-js-xlsx",
		"database-js-csv",
		"database-js-json",
		"javascript",
		"database",
		"db",
		"sql",
		"query",
		"driver",
		"mysql",
		"postgre",
		"postgres",
		"postgresql",
		"sqlite",
		"ado",
		"adodb",
		"firebase",
		"ini",
		"mysql",
		"postgres",
		"sqlite"
		"xls",
		"xlsx",
		"csv",
		"json"
		],
		@@ -25,0 +45,0 @@ "author": "Michael Anderson <michael@anderson-clan.org>",

Fixed alerts

Improved metrics

Worsened metrics

		@@ -23,3 +23,3 @@ # Database-js
		- [MySQL](//github.com/mlaanderson/database-js-mysql)
		- [PostgreSQL](//github.com/mlaanderson/database-js-postgresql)
		- [PostgreSQL](//github.com/mlaanderson/database-js-postgres)
		- [SQLite](//github.com/mlaanderson/database-js-sqlite)
		@@ -26,0 +26,0 @@ - [ActiveX Data Objects](//github.com/mlaanderson/database-js-adodb)