However, the precompiled Windows binary is currently only available as
a 32-bit library. I'd like to request that a precompiled Win64 Windows
binary be added to the list of standard build outputs and downloads
available from the sqlite.org site. This will be consistent with the
basic Win32 binary that is currently maintained, and will support the
growing popularity of 64-bit applications under Windows.
I warmly second that request.
As a benevolent support member on some US and French forums, I often
recommend switching to SQLite as a superior vehicle to handle
application data. Most of the times, the users are not tech-savvy
enough to compile their own x64 DLL and ask for someone to do this for
them.
While it's possible to do so, it would be more useful and safe that the
official SQLite download page offers the latest release x64 version
along the x86 one. I suppose adding a target in the final release
project wouldn't be a big hassle for the maintainers and it would make
it _way_ easier to newbies to go to a reputable place and get the
official version without more steps.
BTW, I also sometimes read here that _sqlite3_exec is obsolescent and
should eventually be removed from the API. While this is fair in the
case where you build your application with SQLite (as static or
dynamic) with a language that offers efficient external calls to DLL or
(obviously) static lib. The issue is different with scripting
languages, not all of them enjoying low-overhead external calls to
DLLs. Should _sqlite3_exec vanish, the wrappers for these languages
will have to replace this single call by the "normal" series of calls
to _prepare, etc. In practice, that means that these wrappers will end
up making a much larger numbers of calls to the API, each of these
wrapped call overhead taking sometimes much more time than the sqlite
routine they invoke.
Removing _exec would only shrink the library to some negligible extent
but the drawbacks for the users concerned would be important. Please
keep this in mind before removing _sqlite3_exec.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users