Re: H1 2015 - db access support in Phobos

[Daniel Kozak via Digitalmars-d]

On Monday, 2 February 2015 at 04:00:31 UTC, Vadim Lopatin wrote:
I would like to propose Java way for implementation of DB 
access (JDBC - Java DataBase Connectors).

Standard library must contain only
* set of interfaces for uniform DB access
    * Connection - can create Statement or PreparedStatement, 
control transactions
    * Statement - can run update or query
    * PreparedStatement - same as Statement, but with parameters
    * ResultSet - DB query result row access
    * DataSource - can create connections, w/o parameters
    * Driver - interface which implements connection factory 
for particular DB types
    * Some useful classes like ConnectionPool
* factory method to create connection by URL and parameter set
* some method to register DB driver for factory - e.g. when 
called from driver's module __gshared static this()

Drivers may be placed in separate packages in standard library 
or in some DUB packages.

Look at https://github.com/buggins/ddbc
Currently it contains drivers for sqlite, MySQL and PostgreSQL.


If Andrey/Walter wish, I can prepare pool request based on code 
from ddbc.

Best regards,
     Vadim

Yep this is way to go, I have start implementing JPA for 
Dlang(ddpa - dlang data persistence api):

@Entity
@(Table.name("nazev_tabulky").schema("nazev_schema"))
class C
{
    @Id @(GeneratedValue.strategy(GenerationType.IDENTITY))
    long id;

    auto getId()
    {
        return this.id;
    }

    void setId(long id)
    {
        this.id = id;
    }
}

void main() {
    EntityManagerFactory emf = 
Persistence.createEntityManagerFactory("test");
    EntityManager em = emf.createEntityManager();
    C obj = em.find!C(1);
}