Standard SQLite compatibility

[lazna]

Using "official"sqlite binary for windows for few years, but ICU support missing. Today found wxsqlite and this have question: Could wxsqlite windows binariy be used instead of "official" one, without any limits with advance of ICU extensions?

thanks, L.

[utelle]

The SQLite shell Windows binaries are based on the same source code as the "official" SQLite shell tool. However, there are a few differences.

The "official" SQLite shell is compiled with a few additional options (namely SQLITE_ENABLE_DBSTAT_VTAB, SQLITE_ENABLE_STMT_VTAB, and SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION) which are currently not enabled for the wxSQLite3 shell.

On the other hand, for the wxSQLite3 shell several other options (like ICU, encryption, etc) are enabled, which are not enabled for the "official" SQLite shell. For using the ICU enabled version you need to download the ICU binaries from the ICU project as described in the readme file coming with the wxSQLite3 binaries.

If the additional options of the "official" SQLite shell are important for you, just let me know. It should not be a big deal to generate executables with these options enabled.

So, the answer to your question is "in principle, yes".

[lazna]

Thanks for your answer, think we could use wxsqlite without mented functions. But If you guys compile "official" version of sqlite with ICU, it would be great. I am search through internet for a while for it and think I am not alone.

with best, L.

[utelle]

I will consider to add the options used for the "official" SQLite shell to the build of the wxSQLite3 shell. However, I don't intend to provide a separate "pure official" build with ICU support. The SQLite shell binaries coming with wxSQLite3 offer more or less a superset of the features of the "official" SQLite shell. You can use the extra functionality, but you don't have to.

Please test the shell binaries coming with the latest wxSQLite3 release, if they work for you. Report any issues you experience, and I will try to sort them out.

[utelle]

Commit 6142b5c adds the necessary preprocessor defines to enhance the compatibility with the "official" SQLite3 shell.