dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.

Project:
https://github.com/huntlabs/database

## Database
Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.

## Example
```D

import std.stdio;
import std.experimental.logger;

import database;

void main()
{
    writeln("run database MySQL demo.");

    auto db = new Database("mysql://root:123456@localhost:3306/test?charset=utf-8");

    int result = db.execute(`INSERT INTO user(username) VALUES("test")`);
    writeln(result);

    foreach(row; db.query("SELECT * FROM user LIMIT 10"))
    {
        writeln(row["username"]);
    }

    db.close();
}

```

## Use DatabaseOption to instantiate a Database object
```D
auto options = new DatabaseOption("mysql://root:123456@localhost:3306/test");
options.setMaximumConnection(5);

auto db = new Database(options);

db.execute("SET NAMES utf8");
```

## API

-  int Database.execute(string sql)  Return number of execute result.
```D
    int result = db.execute('INSERT INTO user(username) VALUES("Brian")');
    // if execute error ,db will throw an DatabaseException
```
-  ResultSet Database.query(sql) Return ResultSet object for query(SELECT).
```D
    ResultSet rs = db.query("SELECT * FROM user LIMIT 10");
```
-  Statement Database.prepare(sql) Create a prepared Statement object.
```D
   Statement stmt = db.prepare("SELECT * FROM user where username = :username and age = :age LIMIT 10");
```
- Statement.setParameter(param, value) : bind param's value to :param for sql.
```D
   stmt.setParameter("username", "viile");
   stmt.setParameter("age", 18);
```
- ResultSet Statement.query()  Return ResultSet
```D
    ResultSet rs = stmt.query();
    foreach(row; rs)
    {
        writeln(row["username"]);
    }
```
- Row Statement.fetch()  Return Row
```D
    Row row = stmt.fetch();
    writeln(row["username"]);
```
- int Statement.execute() : return execute status for prepared Statement object.
```D
    int result = stmt.execute();
```
- Statement.lastInsertId() : Statement.execute() for insert sql, return lastInsertId.

On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote:
> dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.

not bad.

> -  Statement Database.prepare(sql) Create a prepared Statement

ooh, this is something I have been wanting to write for my database libs too...

On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote:
> dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.
>
> Project:
> https://github.com/huntlabs/database

Did you see DDBC project?
It supports postgres, mysql, and sqlite, too.
API is similar to Java JDBC.

Add on allocator support and many more comments, aka if public facing then document it. Then we'd be in business!

On Wednesday, 13 September 2017 at 04:30:24 UTC, Vadim Lopatin wrote:
> On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote:
>> dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.
>>
>> Project:
>> https://github.com/huntlabs/database
>
> Did you see DDBC project?
> It supports postgres, mysql, and sqlite, too.
> API is similar to Java JDBC.

Yes, thanks your project DDBC :)

database is similar to PHP PDO library, no deps, api easy to use.

On Tuesday, 12 September 2017 at 17:37:23 UTC, Adam D. Ruppe wrote:
> On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote:
>> dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.
>
> not bad.
>
>> -  Statement Database.prepare(sql) Create a prepared Statement
>
> ooh, this is something I have been wanting to write for my database libs too...

Welcome to participate! :)

On Wednesday, 13 September 2017 at 06:46:59 UTC, Brian wrote:
> Welcome to participate! :)

Alas, looking at your source, it is actually not what I wanted...  I want to use the database features rather than a reimplemented class.

BTW the "escapedVariants" function can help you fill in that Statement class' missing methods.

On 9/12/17 1:14 PM, Brian wrote:
> dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.
> 
> Project:
> https://github.com/huntlabs/database
> 
> ## Database
> Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite.

I just wanted to point out that in order to bind against libmysqlclient, you must use an open-source license, or pay Oracle a license fee. This means the users of your library must use an open source license or pay the fee (not you), but your license makes it unclear that this is the case. More details here: https://www.mysql.com/about/legal/licensing/foss-exception/

Or you could instead use the mysql-native library that does not depend on Oracle's library: https://github.com/mysql-d/mysql-native

-Steve