[sqlite] database locking

Hi List I have a python script that runs 3 instances simultaneously on a quadcore x86 system. I'm not using the multiprocessing libraries. The programs are just run in parallel. They all access (for reading only) a single sqlite3 database. I'm setting the following pragma commands: offset_db.

Re: [sqlite] inserting a number as a string and keeping it that way

Hi Roger Thanks a lot for such a quick reply... On Sun, Sep 27, 2009 at 3:18 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Sean Moss-Pultz wrote: >> How can I get the string to stay 0123? > > It isn't a string - you supplied an integ

[sqlite] inserting a number as a string and keeping it that way

Hi List Here's basically what I'm doing: sqlite> create table test(t text); sqlite> insert into test values(0123); sqlite> select * from test; 123 How can I get the string to stay 0123? I've read the docs about "Column Affinity." But I guess I'm not smart enough to figure this out :-) B