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
