Hi Simon, Thank you for the excellent explanation!
My use case falls to the third case, i.e. writing an application which talks to a sqlite db. You suggested that I should include the .c and .h files from the amalgamation in my app. Specifically, how should I do that? My application is Python-based, and I'm using py-sqlite module to connect to sqlite. Where should I put the .c and .h files? Thanks a lot. Regards, Merton On Mon, Jun 17, 2013 at 12:19 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 17 Jun 2013, at 12:01am, Merton Lister <mrtnl...@gmail.com> wrote: > > > What is the best way for upgrading sqlite3 on an Ubuntu server (12.04 or > > 10.04)? > > SQLite3 does not exist as a server application. It’s not a pre-compiled > library or a daemon which runs in the background. Instead it comes as > source code which programmers can build into their own applications. It’s > quite possible you have five programs on your computer, each of which is > using a different version of SQLite. (It’s tiny. Having five copies take > up disk space is easily worth not having to worry about interrelated > version dependencies.) > > Since you mentioned Ubuntu Server rather than just the client what you > might be talking about is that a SQLite library is part of PHP which is > part of Apache. To update the version of SQLite used for that, update PHP > or Apache. > > Alternatively you might want to write an application which talks to SQLite > databases. If so, the cannonical answer is to download the latest > amalgamation of SQLite from > > <http://www.sqlite.org/download.html> > > This is one .c and one .h file which you include in your app. > > A little warning: if you have some application which uses SQLite, don’t > update the version of SQLite it’s using other than by updating the > application. Applications sometimes have work-arounds for bugs in earlier > versions of SQLite and if you update SQLite the application can stop > working because a bug it’s depending on is no longer present. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
