SQLite Bindings

[Daniel Gibson]

Am 13.03.2011 18:29, schrieb dsimcha:
> One of the features I miss most in Phobos is support for SQLite. Several
> people have written bindings and wrappers and haven't gotten much
> attention. (For example: https://github.com/bayun/SQLite3-D ).
>
> IMHO, we should do the following:
>
> 1. Put SQLite bindings and the C code (which is public domain) in etc.c,
> just like zlib now. Put it in the docs, etc. to make sure people know
> it's there. This will lower the barrier to entry for people who want to
> make wrappers. These can probably be included without any review, since
> they're a pile of well-tested C code and a fairly mechanical translation
> of a header file.
>
> 2. Encourage people to make wrappers **after** the C code and bindings
> are already "just there", ready to be used. With the barrier to entry
> lowered, we might actually get someone who's serious enough about it to
> take it through the whole review process, etc., rather than just dumping
> a quick n' dirty post to the forum and then forgetting about it.

I think it's a good idea.

Regarding the wrappers: They should not be SQLite specific but generic 
enough to work with any relational database. Something like JDBC. This 
doesn't mean that all databases need to be supported from the beginning, 
but the interfaces should be generic enough to allow writing drivers for 
other databases (and probably at least support for MySQL or PostgreSQL 
in addition to SQLite would be nice).

Anyway: Having bindings to SQLites C interface in etc.c is certainly a 
good start.

Cheers,
- Daniel