Re: [sqlite] Locking and concurrency in SQLite version 3.0

Christian Smith wrote: "Note that the BEGIN command does not acquire any locks on the database. After a BEGIN command, a SHARED lock will be acquired when the first SELECT statement is executed. A RESERVED lock will be acquired when the first INSERT, UPDATE, or DELETE statement is executed."

Re: [sqlite] Locking and concurrency in SQLite version 3.0

At 6:16 PM -0400 6/11/04, D. Richard Hipp wrote: The first alpha release of SQLite version 3.0 will occur in less than 7 days. In preparation for that release, a document describing the new file locking mechanism has be prepared and placed on the website. http://www.sqlite.org/lockingv3.html

Re: [sqlite] Handheld and SQLite

On 6/12/2004 7:57 PM, ISA Programmi wrote: Thanks for help! 1- I do not know the variuos Handheld and the OS that they use (I beleive there is 2 groups of OS: Palm and Pocket PC. Right? 2- Which one (OS) is tu suggest for the purpose I nedd: wireless and very fast operations between

Re: [sqlite] Handheld and SQLite

Thanks for help! 1- I do not know the variuos Handheld and the OS that they use (I beleive there is 2 groups of OS: Palm and Pocket PC. Right? 2- Which one (OS) is tu suggest for the purpose I nedd: wireless and very fast operations between Handheld and PC Thank you in advance,

Re: [sqlite] Locale

Marcos E. Wurzius wrote: D. Richard Hipp wrote: > Version 3 will implement Locale? I do not know what you mean by "Locale". I mean use <,> in numbers. No. The use of ASCII code 0x2c instead of 0x2e for the radix point results in syntactic ambiguities in the SQL language. So SQLite only uses

Re: [sqlite] Locale

D. Richard Hipp wrote: > Version 3 will implement Locale? I do not know what you mean by "Locale". I mean use <,> in numbers. -- Marcos - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] hot journals

D. Richard Hipp wrote: Will Leshner wrote: I had a question about hot journals (in the recently posted document about changes to SQLite's locking mechanism). What happens if somebody (accidently) throws away a hot journal before a database is opened. Is the database now permanently in an

Re: [sqlite] hot journals

Will Leshner wrote: I had a question about hot journals (in the recently posted document about changes to SQLite's locking mechanism). What happens if somebody (accidently) throws away a hot journal before a database is opened. Is the database now permanently in an inconsistent state? Yes. See

Re: [sqlite] Handheld and SQLite

What OS does your handheld run? Check this wiki: http://www.sqlite.org/cvstrac/wiki?p=SqliteUsers Sqlite has ports for Linux, WinCE and PalmOS as far as I know. There are different wrappers available which may help too: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers HTH, Jalil Vaidya ---

[sqlite] Handheld and SQLite

Hi, I would like to know if someone has already programmed for Handheld using SQLite as Db. Please tell me if it is possible to see some example of the skills and speed. I need a small program, running on Handheld, for taking orders and sending to the PC via wireless, in a Cafè/Restaurant. If

[sqlite]change the location of journal file

Hi all, Could the location of journal file be changed? I modified the code in pager.c and the journal file places to the different folder but database image is malformed when opening database.Have any solutions of changing the location of journal file? Best regards, Kei