RE: [sqlite] how to fix problem of lock

2006-04-04 Thread Marian Olteanu
first-come-first-served basis. -Original Message- From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 1:23 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] how to fix problem of lock Please people help me :D, the project will be open source... On 4

Re: [sqlite] how to fix problem of lock

2006-04-04 Thread John Stanton
The method I have found works well and efficiently is to surround your Sqlite accesses with a semaphore and have accessing processes WAIT to get access to Sqlite. For best performance you would only block when an INSERT was in progress and let multiple SELECTs run concurrently. This assumes t

RE: [sqlite] how to fix problem of lock

2006-04-04 Thread Doug Nebeker
-Original Message- From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 1:23 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] how to fix problem of lock Please people help me :D, the project will be open source... On 4/4/06, Cesar David Rodas Mald

Re: [sqlite] how to fix problem of lock

2006-04-04 Thread Cesar David Rodas Maldonado
. > > Fred > > > -Original Message- > > From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, April 04, 2006 1:23 PM > > To: sqlite-users@sqlite.org > > Subject: Re: [sqlite] how to fix problem of lock > > > > >

RE: [sqlite] how to fix problem of lock

2006-04-04 Thread Fred Williams
gt; Subject: Re: [sqlite] how to fix problem of lock > > > Please people help me :D, the project will be open source... > > On 4/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > > > OK English is not my first language, i am from south America, from > &g

Re: [sqlite] how to fix problem of lock

2006-04-04 Thread Cesar David Rodas Maldonado
Please people help me :D, the project will be open source... On 4/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > OK English is not my first language, i am from south America, from > Paraguay so i speak Spanish... > > I am doing a project in C multiplataform.. right it project lik

Re: [sqlite] how to fix problem of lock

2006-04-04 Thread Cesar David Rodas Maldonado
OK English is not my first language, i am from south America, from Paraguay so i speak Spanish... I am doing a project in C multiplataform.. right it project like google, for a Linux. the project uses SQ Lite for repository. The software is a server which listen connection UDP. The server could

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread John Stanton
Try to explain what you are doing. How do you access SQLITE? What language? What SQL are you using. How many concurrent users do you have? Are you getting a LOCK error because of multiple users? Cesar David Rodas Maldonado wrote: please i need some help On 4/3/06, Cesar David Rodas Maldon

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Pam Greene
You can't SELECT from your database while an INSERT has not finished. SQLite will return the SQLITE_BUSY error if you try. You can't fix that. It is not broken. In fact, it's necessary. You can have your application simply loop with a delay, trying the SELECT and waiting for the SQLITE_BUSY to g

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Jay Sprenkle
> I suspect that the tone of your messages and your insistence on getting > some sort of unspecified help has irked more than a few members of this > list. I didn't think I could help without spanish. I'm the guy who asked 'who is the bathroom' when I tried it last... ;)

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Kurt Welgehausen
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote: > but is posible open several DATABASE with a programm and do transaccion > without locked the table??? No. A transaction will always lock the database at some point. Regards

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Dennis Cote
Cesar David Rodas Maldonado wrote: please i need some help Cesar, I suspect that the tone of your messages and your insistence on getting some sort of unspecified help has irked more than a few members of this list. I appreciate that English may not be your first language, but your state

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Cesar David Rodas Maldonado
please i need some help On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > i insert numbers and select numbers, so what could be the solutions, > couse i have to do that > > > On 4/3/06, Pam Greene < [EMAIL PROTECTED]> wrote: > > > > An INSERT can change the results of your SELE

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Cesar David Rodas Maldonado
i insert numbers and select numbers, so what could be the solutions, couse i have to do that On 4/3/06, Pam Greene <[EMAIL PROTECTED]> wrote: > > An INSERT can change the results of your SELECT, so the database has to be > locked during INSERT. Otherwise, the result of your SELECT would depend >

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Pam Greene
An INSERT can change the results of your SELECT, so the database has to be locked during INSERT. Otherwise, the result of your SELECT would depend on whether the INSERT had finished yet. (The INSERT might even have only partly finished, which would mean the SELECT was looking at a database in an

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Cesar David Rodas Maldonado
HElp me, couse i just need to do insert and select, i dont use delete or replate or update On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > thanx man > > > but is posible open several DATABASE with a programm and do transaccion > without locked the table??? > > On 4/3/06, Jay

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Cesar David Rodas Maldonado
thanx man but is posible open several DATABASE with a programm and do transaccion without locked the table??? On 4/3/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > I have a database ok... i do a lot of insert and select,

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Jay Sprenkle
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > I have a database ok... i do a lot of insert and select, but there is > sometime that i cant do the select couse the database is locked... > > i have to do a lot of insert every time, so how can i do for dont lock the > databas

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Cesar David Rodas Maldonado
I have a database ok... i do a lot of insert and select, but there is sometime that i cant do the select couse the database is locked... i have to do a lot of insert every time, so how can i do for dont lock the database... understand guy? On 4/3/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: >

Re: [sqlite] how to fix problem of lock

2006-04-03 Thread Jay Sprenkle
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > I have a database that i do a lot of insert and select... really a lot > > but i have a problem with the lock database, couse when i do a lot of insert > i can do a select > > i know that that is normal, but how can i fix it?, usin

[sqlite] how to fix problem of lock

2006-04-03 Thread Cesar David Rodas Maldonado
I have a database that i do a lot of insert and select... really a lot but i have a problem with the lock database, couse when i do a lot of insert i can do a select i know that that is normal, but how can i fix it?, using a memory for insert or using another database like a mirror or how??? tha