[sqlite] Database is locked

2006-04-22 Thread Steve Bergman
Hi All, I was wondering if anyone here had any comments on this thread on the Python TurboGears group: http://tinyurl.com/qhmyw Essentially, people are getting a Database is locked error from the ORM (SQLObject). The recommendation seems to be "Don't use SQLite". I am seeing this

Re: [sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

2006-04-22 Thread John Stanton
I have actually done that and it works well for a particular class of applications, ones with a relatively small number of simultaneous users. For large numbers we switch to PostgreSQL The basic architecture of Sqlite, and why it is "Lite", is that it uses a single file and file locks for

Re: [sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

2006-04-22 Thread Russell Leighton
I was afraid of that...it would be cool if someone created a sqlite server which handled the networking and serialization...I would take a crack at it myself but right now I don't have time. Dan Kennedy wrote: I had a musing while reading:

Re: [sqlite] Sqlite inside MySQL as one of the pluggable "storage mechanisms" ?

2006-04-22 Thread Dan Kennedy
> > I had a musing while reading: > > > http://news.com.com/2100-7344_3-6063599.html?part=rss=6063599=news > > > where it reminded me of one of MySQL's features: > > MySQL's database is built so that it can use a range of different > storage mechanisms, tuned for different

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

2006-04-22 Thread COS
Hi Christian, - Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: Sent: Thursday, April 20, 2006 11:16 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? > On Thu, 20 Apr 2006, DBTools Software wrote: > > >Hi, > > > >I have an