ddbc 0.2.12

DB Connector for D language, similar to JDBC


To use this package, run the following command in your project's root directory:

Manual usage
Put the following dependency into your project's dependences section:

DDBC

DDBC is DB Connector for D language (similar to JDBC)

Currently supports MySQL, PostgreSQL and SQLite.

Project homepage: https://github.com/buggins/ddbc Documentation: https://github.com/buggins/ddbc/wiki

See also: https://github.com/buggins/hibernated - ORM for D language which uses DDBC.

NOTE: project has been moved from SourceForge to GitHub

Example:

// create connection pool
// This part depends on RDBMS
// MySQL driver - you can use PostgreSQL or SQLite instead as well
MySQLDriver driver = new MySQLDriver();
string url = MySQLDriver.generateUrl("localhost", 3306, "test_db");
string[string] params = MySQLDriver.setUserAndPassword("testuser", "testpassword");
// This part is common for all
DataSource ds = new ConnectionPoolDataSourceImpl(driver, url, params);

// creating Connection
auto conn = ds.getConnection();
scope(exit) conn.close();

// creating Statement
auto stmt = conn.createStatement();
scope(exit) stmt.close();

// execute simple queries to create and fill table
stmt.executeUpdate("CREATE TABLE IF NOT EXISTS ddbct1 (id bigint not null primary key AUTO_INCREMENT, name varchar(250), comment mediumtext, ts datetime)");
stmt.executeUpdate("INSERT INTO ddbct1 SET id=1, name='name1', comment='comment for line 1', ts='20130202123025'");
stmt.executeUpdate("INSERT INTO ddbct1 SET id=2, name='name2', comment='comment for line 2 - can be very long'");

// reading DB
auto rs = stmt.executeQuery("SELECT id, name name_alias, comment, ts FROM ddbct1 ORDER BY id");
while (rs.next())
    writeln(to!string(rs.getLong(1)) ~ "\t" ~ rs.getString(2) ~ "\t" ~ strNull(rs.getString(3)));
Authors:
  • Vadim Lopatin
Dependencies:
mysql-native
Versions:
0.5.4 2022-Mar-02
0.5.3 2021-May-05
0.5.2 2021-Feb-12
0.5.1 2019-Dec-15
0.5.0 2019-Sep-29
Show all 49 versions
Download Stats:
  • 0 downloads today

  • 5 downloads this week

  • 48 downloads this month

  • 10699 downloads total

Score:
3.1
Short URL:
ddbc.dub.pm