[sqlite] Recommended latest SQLITE version for upgrade

Hi SQLite Users, >From your experiences, appreciate any recommendation on what could be the right latest stable version of SQLITE to upgrade to, from one of the oldest (about 5 years) versions. Many thanks in advance. Regards, Karthik Theerthagiri Exchange Connectivity SG +65 6

[sqlite] question about case when

m test1 group by category which of the queries is better? are the two queries just the same behind the scenes? Thanks, Karthik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie questions regarding in-memory database.

Igor Tandetnik wrote: > "Karthik" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] > >> Newbie question regarding in-memory databases. I read in the wiki >> pages that it is not safe to use same db connection across multiple >> threads.

[sqlite] Newbie questions regarding in-memory database.

it erases the same. If I were to use one connection per thread will i end up creating distinct memory db's for each thread? is it possible to use a single in-memory db that can be accessed by different threads in a multithreaded environment? Any help doc on this is appreciated. R