SQLLite driver

[Nicolas Sicard via Digitalmars-d-learn]

On Sunday, 14 December 2014 at 13:47:21 UTC, Suliman wrote:
> On Sunday, 14 December 2014 at 13:33:27 UTC, Suliman wrote:
>>> There is also a branch named `develop` which at least 
>>> compiles, maybe it is usable.
>>
>> how to add to dub this branch?
>
> Compiling using dmd...
> Linking...
> OPTLINK (R) for Win32  Release 8.00.15
> Copyright (C) Digital Mars 1989-2013  All rights reserved.
> http://www.digitalmars.com/ctg/optlink.html
> sqlite3.lib
>  Warning 2: File Not Found sqlite3.lib
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_close
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_enable_shared_cache
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_open
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_changes
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_total_changes
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_errcode
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_errmsg
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_open_v2
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_finalize
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_bind_parameter_count
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_clear_bindings
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_reset
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_step
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_prepare_v2
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_count
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_type
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_name
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_text
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_double
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_int64
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_blob
> C:\Users\Dima\AppData\Roaming\dub\packages\d2sqlite3-0.5.2\d2sqlite3.lib(d2sqlit
> e3)
>  Error 42: Symbol Undefined _sqlite3_column_bytes
> --- errorlevel 22
> FAIL 
> .dub\build\application-debug-windows-x86-dmd_2066-668EB54A2EBB0CE5C55E2AC62
> 166BCB8\ seismodownloader executable
> Error executing command run: dmd failed with exit code 22.
>
>
>>Warning 2: File Not Found sqlite3.lib
>
> Does it's mean that I should to find this lib and put it in 
> package folder?

Yes, you need to link the sqlite3 library, but I'm sorry I can't
help you more, because I've never done this with dub on Windows...

The develop branch is more up-to-date. It should compile with
2.066.1. And the API is supposed to be cleaner. See the examples
to find the changes.

--
Nicolas