Re: [sqlite] optimizing a multiple select statement

2008-11-22 Thread Igor Tandetnik
"Christophe Leske" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sorry if this is trivial, but is there no way to do something like: > > insert into idlookup > ( > ( > select * from cl1 > UNION select * from cl2 > UNION select * from cl3 > UNION select * from cl4 > UNION select *

Re: [sqlite] Break compatibility with linux 2.4 in SQLite 3.6.7?

2008-11-22 Thread Brad House
As a follow-up, RHEL 3 did include the NPTL backport as per: http://www.redhat.com/docs/manuals/enterprise/RHEL-3-Manual/release-notes/as-x86/ RHEL 2 did not, it was first introduced in RHEL 3. RHEL AS 2.1 is still supported by Red Hat until May 31, 2009:

Re: [sqlite] Non specific, somewhat random Sqlite3 write failures

2008-11-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 rsts wrote: > On my development computer, which is a moderately powered machine with > plenty of disk and ram, I never have had a failure writing out and bringing > back over 10,000 records at a time. You can use virtualization software to make an

[sqlite] Non specific, somewhat random Sqlite3 write failures

2008-11-22 Thread rsts
Hi, I'm not a sqlite3 expert by any means, but I have been using it to manage databases in several of my applications without problem. Currently, I'm working with a sqlite3 database from which I want to extract a subset of records and write them to a new database of the same characteristics.

Re: [sqlite] Adobe AIR Version Issue(?)

2008-11-22 Thread phillipm
Thanks for the responses guys. I'll get my hammer out :o) Cheers Phil Ben Marchbanks-2 wrote: > > If you haven't already downloaded it checkout Christian Coenreats SQLite > Admin written in AIR. > > http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ > > Its a big help for me as

[sqlite] optimizing a multiple select statement

2008-11-22 Thread Christophe Leske
Hello, i am doing this request and was wondering if I can coerce it, as all tables of the subset (the cl* tables) all have the same fields. As you can see, i need to sort them by lomi,loma,lami,lama and ID. insert into idlookup select * from cl1 where (lomi>13.96 and loma<13.96 and lami>53.23

Re: [sqlite] Break compatibility with linux 2.4 in SQLite 3.6.7?

2008-11-22 Thread Brad House
I'm pretty sure both RHEL 2 & 3 both use 2.4 kernels and are still actively supported by RedHat if that sways your decision. I know I have clients that are on RHEL3 still so I'd prefer this change not to be made if there will be negative impact. We do share connections across threads, but not

[sqlite] Break compatibility with linux 2.4 in SQLite 3.6.7?

2008-11-22 Thread D. Richard Hipp
Many systems built on the linux 2.4 kernels contain a bug in their thread implementation: A posix advisory lock created by thread A could not be overridden or modified by thread B. In essence, linux was treating different threads within the same process as if they were different

Re: [sqlite] Adobe AIR Version Issue(?)

2008-11-22 Thread Ben Marchbanks
If you haven't already downloaded it checkout Christian Coenreats SQLite Admin written in AIR. http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ Its a big help for me as my SQLite dbs are created on a Linux server (a select backup from mySQL) and then I embed them into my AIR project

Re: [sqlite] Adobe AIR Version Issue(?)

2008-11-22 Thread Ben Marchbanks
Yes I did resolve it using a large hammer - I just delete the previous sqlite backup file using ulink since for my purposes its a total backup anyway. It would be good to know how to do incremental changes as an option - let me know if you find a solution. One thing I did notice is that the

Re: [sqlite] Adobe AIR Version Issue(?)

2008-11-22 Thread D. Richard Hipp
On Nov 22, 2008, at 6:51 AM, phillipm wrote: > > > > tiggyboo wrote: >> >> I created and populated a table via sqlite3 on a Mac OSX machine, >> and have >> no problem working with it from the sqlite3 prompt. However, when >> I try >> to access the sole table (named cftable) in this

Re: [sqlite] Adobe AIR Version Issue(?)

2008-11-22 Thread phillipm
tiggyboo wrote: > > I created and populated a table via sqlite3 on a Mac OSX machine, and have > no problem working with it from the sqlite3 prompt. However, when I try > to access the sole table (named cftable) in this database via a very > simple Adobe AIR application I'm working on, I get