[sqlite] famous users of SQLite

You can add Sony to the list on (presuming they don't object). While diagnosing a problem with a Sony Bravia I found it necessary to dump the information stored on the internal Flash storage. There are files there which have extension .sdb and have the

[sqlite] Optimization Opportunity?

Op 7 mrt 2015, om 19:24 heeft Wolfgang Enzinger het volgende geschreven: > Hi dev team, > > not sure if this is actually a useful hint, but ... > > CREATE TABLE a(a1 INTEGER PRIMARY KEY); > INSERT INTO a VALUES (1),(2),(3); > CREATE TABLE b(a1 INTEGER REFERENCES a(a1),b1 INTEGER PRIMARY KEY); >

[sqlite] restructuring databases (was Re: Can I copy one column of data to another table?)

Jim, My data used to be hard coded into my app but now I am porting to Android and the rules have changed. I need smaller subs so the database fills the need to make my large subs smaller due to hard coded data. So in reality I just need a flat file or as you as say, a denormalized

[sqlite] restructuring databases (was Re: Can I copy one column of data to another table?)

Duncan, Thanks for your comments. My db is small and the records are at less than 200. The tables number 7 and the colums 18 not counting the primary auto increment. The UPDATE method I ended up using took about 1 second for the one colum I moved or copied. I am just using this db as "read

[sqlite] sqlite vfs and wal mode

I was trying to figure out what to do about this WAL journal_mode option... 1) my vfs does not (and cannot) have a shared memory interface... so those routines are NULL (so I would think WAL logic should prohibit flagging the database as wal...) 2) I tried to return error on the pragma, but