On 10/26/16, Smith, Randall <rsm...@qti.qualcomm.com> wrote: > This question may be off-topic for this list, since it deals with using > SQLite in a specific setting rather than SQLite itself. Apologies if so. > Thanks very much if anyone can provide any insight. > > I am one of the hapless souls who need access to SQLite's CTE capabilities > (introduced in v3.8.3) while using Ubuntu 14.04 (which includes SQLite 3.8.2 > by default). Our IT people are not thrilled about the idea of upgrading the > core libraries for fear of messing something else up in Linux-land. > > I'm wondering if it's possible to build and use a "private" SQLite library > based on some other version, and limit its use to a specific application. > My particular situation is python scripts -> sqlite3 adaptor -> underlying > SQLite lib. So I guess I'm asking if it's possible to bind a particular > Python interpreter and the libraries it uses to a particular SQLite lib that > is not used by the rest of the system.
(1) You should be able to drop in SQLite 3.15.0 (or any other release after 3.8.2) in place of SQLite 3.8.2 and everything will continue working just fine. The only changes will be that the applications will run a little faster. We carefully test backwards compatibility. (1a) Sometimes an application will do a SELECT without an ORDER BY when the application really does need the data in a specific order. This error is not noticed because SQLite happens to return the rows in the desired order, just by chance. Upgrading to a newer version of SQLite might change the output order. This is about the only compatibility issues you can expect when upgrading SQLite. Notice that this is a bug in the application, not a bug in SQLite. (2) SQLite works fine with static linking. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users