Re: [sqlite] database writes by multiple processes (on a very old computer)

On Tue, Aug 24, 2010 at 08:38:03AM -0400, Chad Rebuck scratched on the wall: > After changing my script to make use of querysingle instead of the > query/fetchArray loop I was still seeing database locked notices. My > scripts would end unexpectedly if the database lock occured at the right >

Re: [sqlite] "Using SQLite" - O'Reilly Deal of the Day

Wednesday, August 25, 2010, 9:37:17 AM, you wrote: GS> On 8/24/2010 8:09 AM, Jay A. Kreibich wrote: >> >>"Using SQLite" has gone to press! To celebrate, "Using SQLite" is >>is today's O'Reilly "Ebook Deal of the Day." GS> And quite a deal it is! Thank you for posting the

Re: [sqlite] "Using SQLite" - O'Reilly Deal of the Day

On 8/24/2010 8:09 AM, Jay A. Kreibich wrote: > >"Using SQLite" has gone to press! To celebrate, "Using SQLite" is >is today's O'Reilly "Ebook Deal of the Day." And quite a deal it is! Thank you for posting the announcement, Jay. I had just been wondering what book to start reading on

Re: [sqlite] Precompiled binary for sqlite3_analyzer requires libicui18n.so.44?

On Mon, Aug 23, 2010 at 9:59 PM, Richard Hipp wrote: > There is now a new build of sqlite3_analyzer for linux up that should not > require libicu18n.  Let me know if the new version fails to work for you. Thank you. > To build sqlite3_analyzer, you have to manually edit

[sqlite] Compile SQlite 32 and 64 bits universal with ICU support on MacOSX

Hello, I met today a difficult situation where I wanted to have SQLite 32 and 64 bits with the ICU support, Unfortunately ICU does not support the universal 32 and 64 bits... but using lipo and a bit of manual work, we have it working! I wrote the detailed procedure on my blog

Re: [sqlite] Suggestion for project: Chat

On 24/08/10 17:21, Artur Reilin wrote: > I thinking about coding a chat with sqlite. You know the most hosts not > allow you to use chats or something that way, because they write and read > to often data from mysql database. > > So my thought is to make a chat which use forums software mysql

Re: [sqlite] Suggestion for project: Chat

> On Tue, Aug 24, 2010 at 10:23:55PM +0530, Roger Binns wrote: >> On 08/24/2010 09:51 PM, Artur Reilin wrote: >> > I thinking about coding a chat with sqlite. >> >> The hard part of implementing chat is not storing the messages, but >> rather dealing with all the clients at the same time

Re: [sqlite] Suggestion for project: Chat

On Tue, Aug 24, 2010 at 10:23:55PM +0530, Roger Binns wrote: > On 08/24/2010 09:51 PM, Artur Reilin wrote: > > I thinking about coding a chat with sqlite. > > The hard part of implementing chat is not storing the messages, but > rather dealing with all the clients at the same time especially

Re: [sqlite] Suggestion for project: Chat

FWIW: The SQLite Core developers all keep in touch using a private, proprietary chatroom that is backed by an SQLite database. The chat server is written in 152 lines of Tcl code and the client (involving a GUI and therefore being more complex) is 1068 lines of Tcl/Tk. We have other means of

Re: [sqlite] Why the deadlock?

On Aug 24, 2010, at 10:57 AM, Nikolaus Rath wrote: > Nikolaus Rath writes: >> Still no one able to clarify the issues raised in this thread? >> >> Let me try to summarize what I still don't understand: >> >> - Will SQLite acquire and release an EXCLUSIVE

Re: [sqlite] Suggestion for project: Chat

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/24/2010 09:51 PM, Artur Reilin wrote: > I thinking about coding a chat with sqlite. The hard part of implementing chat is not storing the messages, but rather dealing with all the clients at the same time especially with potentially hostile

[sqlite] Suggestion for project: Chat

I thinking about coding a chat with sqlite. You know the most hosts not allow you to use chats or something that way, because they write and read to often data from mysql database. So my thought is to make a chat which use forums software mysql tables for user data, but writes and read chat text

Re: [sqlite] SQLite fails to build for WinCE 4.2 (WM 2003)

On Windows CE, you need to compile with SQLITE_OMIT_WAL. SQLite currently doesn't support the WAL journaling mode on CE. On Tue, Aug 24, 2010 at 6:32 AM, Aleksandr Jr. wrote: > Hi. > > I got a problem when compiling SQLte 3.7.2 for Windows CE 4.2 (Windows > Mobile

Re: [sqlite] Why the deadlock?

Er, did you not see Dan Kennedy's comments a fed days ago?? On 8/24/10, Nikolaus Rath wrote: > Nikolaus Rath writes: >> Still no one able to clarify the issues raised in this thread? >> >> Let me try to summarize what I still don't

[sqlite] "Using SQLite" - O'Reilly Deal of the Day

"Using SQLite" has gone to press! To celebrate, "Using SQLite" is is today's O'Reilly "Ebook Deal of the Day." TODAY ONLY (Tues. 24-Aug-2010), the ebook version of "Using SQLite" is available for only $9.99 using the discount code "DDSLE". Once purchased, the book can be downloaded

Re: [sqlite] Why the deadlock?

Nikolaus Rath writes: > Still no one able to clarify the issues raised in this thread? > > Let me try to summarize what I still don't understand: > > - Will SQLite acquire and release an EXCLUSIVE lock while keeping a >SHARED lock if one executes a

Re: [sqlite] database writes by multiple processes (on a very old computer)

After changing my script to make use of querysingle instead of the query/fetchArray loop I was still seeing database locked notices. My scripts would end unexpectedly if the database lock occured at the right moment. Finally found the root cause of the trouble was due to not defining a

[sqlite] SQLite fails to build for WinCE 4.2 (WM 2003)

Hi. I got a problem when compiling SQLte 3.7.2 for Windows CE 4.2 (Windows Mobile 2003) - it cannot be done. In the function winShmSystemLock(...) is called API-function UnlockFileEx(...), but it is implemented only in Windows CE 5.0 and later (and there in winShmSystemLock(...) is used