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

Reply via email to