Standard SQLite compatibility about wxsqlite3 HOT 4 CLOSED

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".

from wxsqlite3.

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.

from wxsqlite3.

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.

from wxsqlite3.

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

from wxsqlite3.