SQLite 3.6.23.1 wrapper + connector

[Johannes Pfau]

On 19.07.2010 00:44, awishformore wrote:
> Hello there.
> 
> I've converted the .h file of the latest SQLite version to .d and I
> thought I'd let the world know (as suggested on IRC ;). Maybe it will
> save someone some work.
> 
> I've also written a nice connector class that wraps all the C functions
> for convenient use in your application. It's very basic, but I will
> probably add more features (like automatic preparation of statements and
> automatic caching of several prepared statements) later.
> 
> For the time being both files are included in the download:
> http://nexunity.com/sqlite4d.rar
> 
> I'm pretty new to this kind of stuff, so what I did to get it to work
> was compiling the latest SQLite dll from source with dmc and then link
> the .obj file into my app ( http://nexunity.com/sqlite3.obj ).
> 
> I'm sure there is a better way like compiling it as static lib (dmc
> complained about no entry point) or having some kind of other file to
> link into your app in order for it to compile and then use the dll. I
> however couldn't figure it out and it works for me. Don't hesitate to
> teach me nonetheless.
> 
> Any kind of feedback is always appreciated.
> 
> Greetings, Max.
Nice work!

I'm by no means an expert in d, but I wonder whether the following in
the connector could cause troubles:
--------------------------------------
int open(string db_name)
{
    return sqlite3_open_v2(cast(char*)db_name,
--------------------------------------

I always thought just casting to the pointer type isn't really safe. I
guess you should use std.strings toStringz.

(Off topic: std.strings toStringz uses the GC to store the c string. Now
if I passed the returned pointer to a C function, but didn't store a
reference in the D program, couldn't that c string get collected while
the c library would expect it to be still there?)
-- 
Johannes Pfau