Thread overview
database 0.0.8 released
Sep 12
Brian
Sep 13
Brian
Sep 13
Brian
September 12
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.

September 12
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...
September 13
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.

September 13
Add on allocator support and many more comments, aka if public facing then document it. Then we'd be in business!
September 13
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.
September 13
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! :)
September 13
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.
September 13
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