[sqlite] Crashing on some computers

2004-11-09 Thread Tomas Franzén
Hi, I have built a Carbon (Mac OS X) bundle that contains SQLite code. It works great on my two Macs, and on a few other people's boxes. However, on some people's Macs, it crashes on sqlite_open. Has anyone had these kind of problems? Here's the relevant part of the crash log: Thread 0 Crashed:

Re: [sqlite] Crashing on some computers

2004-11-09 Thread b.bum
On Nov 9, 2004, at 6:46 AM, Tomas Franzén wrote: I have built a Carbon (Mac OS X) bundle that contains SQLite code. It works great on my two Macs, and on a few other people's boxes. However, on some people's Macs, it crashes on sqlite_open. Has anyone had these kind of problems? Are you

[sqlite] Client/Server Environment

2004-11-09 Thread Richard Boehme
Hi there. How well does SQLite do in a client/server environment where the SQLite database is handling a batch of 100 inserts and the same number of queries a every 0.5 seconds? The inserts would be batched into a transaction. The queries would most likely not. Thanks for the help. Richard

Re: [sqlite] Pocket PC - SQLite - eMbedded Visual C++

2004-11-09 Thread Mateusz Łoskot
User Aaron Planell Lopez wrote:: [...] But when I execute the program in my Pocket PC show me the next message: 'proyecto1' is not a valid application for Pocket PC [...] What is the sqlite project configuration ? Do you try to

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Clay Dowling
Richard Boehme said: > Hi there. How well does SQLite do in a client/server environment where > the SQLite database is handling a batch of 100 inserts and the same > number of queries a every 0.5 seconds? The inserts would be batched into > a transaction. The queries would most likely not. I'm

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Gerhard Haering
On Tue, Nov 09, 2004 at 10:45:35AM -0500, Richard Boehme wrote: > Hi there. How well does SQLite do in a client/server environment > where the SQLite database is handling a batch of 100 inserts and the > same number of queries a every 0.5 seconds? The inserts would be > batched into a transaction.

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Richard Boehme
This is an extreme case -- records would usually be updated every minute or so. Usually there might be 10 computers trading information (about 100 records every few minutes), for example. I was extrpolating an extreme test case where the system is very heavily used. In such a situation, we

Re: [sqlite] Crashing on some computers

2004-11-09 Thread Tomas Franzén
On 2004-11-09, at 16.42, b.bum wrote: Are you statically linking SQLite or using a dylib? I don't know. That's not a good sign, is it? ;-) I have compiled SQLite and added libsqlite.o and sqlite.h to the project items in XCode. Thanks! Tomas Franzén Lighthead Software http://www.lightheadsw.com/

Re: [sqlite] Client/Server Environment

2004-11-09 Thread Clay Dowling
Richard Boehme said: > This is an extreme case -- records would usually be updated every minute > or so. Usually there might be 10 computers trading information (about > 100 records every few minutes), for example. I was extrpolating an > extreme test case where the system is very heavily used. >

Re: [sqlite] Crashing on some computers

2004-11-09 Thread Clay Dowling
Tomas Franzén said: > On 2004-11-09, at 16.42, b.bum wrote: >> Are you statically linking SQLite or using a dylib? > > I don't know. That's not a good sign, is it? ;-) > I have compiled SQLite and added libsqlite.o and sqlite.h to the > project items in XCode. ldd is your friend here. It will

Re: [sqlite] Crashing on some computers

2004-11-09 Thread b.bum
On Nov 9, 2004, at 10:48 AM, Tomas Franzén wrote: I don't know. That's not a good sign, is it? ;-) I have compiled SQLite and added libsqlite.o and sqlite.h to the project items in XCode. Do you mean libsqlite.a? Do you have libsqlite3.dylib (or something like it) in /usr/local/lib? ...

[sqlite] Single row insert failure

2004-11-09 Thread Roderick A. Anderson
New subscriber butI did check the archives first and did not find reference to this (or used the totally wrong search terms). There was one thread to something similar but it didn't pan out. So here is the issue. Inserting a single row into a SQLite2 database doesn't work using perl on a

Re: [sqlite] Crashing on some computers

2004-11-09 Thread Dave Hayden
On Nov 8, 2004, at 10:51 AM, Clay Dowling wrote: Tomas Franzén said: On 2004-11-09, at 16.42, b.bum wrote: Are you statically linking SQLite or using a dylib? I don't know. That's not a good sign, is it? ;-) I have compiled SQLite and added libsqlite.o and sqlite.h to the project items in XCode.

Re: [sqlite] Single row insert failure

2004-11-09 Thread Eric Bohlman
Roderick A. Anderson wrote: So here is the issue. Inserting a single row into a SQLite2 database doesn't work using perl on a Windows system. I have a data in a MS SQL Server database I need to process on a Linux box (and getting ODBC to work isn't an option at this time) so my cheat is to

Re: [sqlite] PATCH ATTACHED: Re: sqlite assert failure in 2.8.15

2004-11-09 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: This presented itself with the following scenario: - sqlite_open() some unimportant database file - set PRAGMA SYNCHRONOUS=OFF - do some things that cause pPg->needSync to be true for some set of pages. this will also have set pPager->needSync to be true. - ATTACH

Re: [sqlite] Client/Server Environment

2004-11-09 Thread ben . carlyle
Hello, "Clay Dowling" <[EMAIL PROTECTED]> 09/11/2004 02:39 AM Please respond to sqlite-users To: [EMAIL PROTECTED] cc: Subject:Re: [sqlite] Client/Server Environment > Richard Boehme said: > > Hi there. How well does SQLite do in a client/server