RE: [sqlite] sqlite3Explorer

2007-11-25 Thread Cariotoglou Mike
maybe... otoh, much of the thing's perceived value comes from things like the datagrid functionality. this is DevExpress, and somehow I doubt they have a version for lazarus. still, might have a look... From: John Elrick [mailto:[EMAIL PROTECTED] Sent: Mon

Re: [sqlite] Threading (again)

2007-11-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 D. Richard Hipp wrote: > SQLite is completely threadsafe in 3.5.2. But that does not mean > that running SQLite will magically fix threading bugs in Linux 2.4 > kernels or in GLIBC. The FAQ warns you to beware these problems. Thanks for the

Re: [sqlite] sqlite3Explorer

2007-11-25 Thread John Elrick
Joe Wilson wrote: --- Cariotoglou Mike <[EMAIL PROTECTED]> wrote: I wish I could "make it for Unix", but it uses a lot of windows-specific things, plus it is done in Delphi, and since Kylix is practically dead, wlll... I didn't realize it was written in Delphi. Yes, that would be

Re: [sqlite] 3.5.x and pthreads design

2007-11-25 Thread Teufel
D. Richard Hipp wrote: For threads within the same process, fcntl is broken by design in POSIX. (You can clearly tell which parts of Unix were invented by Thompson and Richie and which parts were added later by clueless committees. Posix advisory locks belong in the latter category.) SQLite

Re: [sqlite] 3.5.x and pthreads design

2007-11-25 Thread D. Richard Hipp
On Nov 25, 2007, at 5:34 PM, Teufel wrote: Hi everyone, I am using sqlite 3.3 awhile now for some statistic updates in multithreaded enviroment. Now I would like to move on to 3.5.2 use it more for other tasks too. Since the sqlite db is placed here on a fs, which has a broken fcntl, I

Re: [sqlite] Threading (again)

2007-11-25 Thread D. Richard Hipp
On Nov 25, 2007, at 2:21 PM, Roger Binns wrote: I was under the impression that SQLite 3.5.2 is completely threadsafe, meaning you can make any relevant API call in any thread. Examples of things I thought are safe are: - - Using statements from the same connection in different threads - -

[sqlite] 3.5.x and pthreads design

2007-11-25 Thread Teufel
Hi everyone, I am using sqlite 3.3 awhile now for some statistic updates in multithreaded enviroment. Now I would like to move on to 3.5.2 use it more for other tasks too. Since the sqlite db is placed here on a fs, which has a broken fcntl, I disabled it by putting "#define fcntl (A,B,C) 0".

Re: [sqlite] sqlite with C++

2007-11-25 Thread Andreas Volz
Am Sun, 25 Nov 2007 12:11:50 +0100 schrieb Andreas Volz: > Hello, > > I used this minimal example code to test my sqlite connection. This > works without problems. But now I tried to move the 'db' variable into > the private member section of my 'Cache' class to access it from > various member

Re: [sqlite] Request for help with the SQLite Website

2007-11-25 Thread Kees Nuyt
On Wed, 14 Nov 2007 01:40:13 +, [EMAIL PROTECTED] wrote: >The new look for the SQLite website is now in place, >if you haven't already noticed: > >http://www.sqlite.org/ > >Even though the new look is "in place" you should >understand this as a work in progress, not a done >deal. I am

Re: [sqlite] Threading (again)

2007-11-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roger Binns wrote: > I was under the impression that SQLite 3.5.2 is completely threadsafe, > meaning you can make any relevant API call in any thread. I should be clearer what I meant by threadsafe. The most important notion is that there is no

[sqlite] Undefined collation: Peculiar observations ...

2007-11-25 Thread Ralf Junker
Imagine that a SQLite3 database opened in a custom application with a registered a collation sequence named "unknown" has created the following table: CREATE TABLE a (b COLLATE unknown); Now open this table in the default SQLite3 CLI. Up to here, everything works as expected. Now some

[sqlite] Threading (again)

2007-11-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I was under the impression that SQLite 3.5.2 is completely threadsafe, meaning you can make any relevant API call in any thread. Examples of things I thought are safe are: - - Using statements from the same connection in different threads - -

RE: [sqlite] sqlite3Explorer

2007-11-25 Thread Joe Wilson
--- Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > I wish I could "make it for Unix", but it uses a lot of windows-specific > things, plus it is done > in Delphi, and since > Kylix is practically dead, wlll... I didn't realize it was written in Delphi. Yes, that would be a difficult port to

RE: [sqlite] [OT] "encrypted" e-mail address (was Re: [sqlite] sqlite3Explorer)

2007-11-25 Thread Karsten Bräckelmann
On Sun, 2007-11-25 at 13:56 +0200, Cariotoglou Mike wrote: > no, a mistake. the address IS : > mikecar at singular dot gr (mike will also work) > thanks for pointing out the header problem. I was hoping the mailing > list was "hiding" this info, obviously not Publicly accessible and searchable

[sqlite] Reported Error with SQLITE_MEMORY_SIZE

2007-11-25 Thread Teg
Another question about this option. Is there any way I can tell how much memory SQLite might need? I've set it to 10 megs, 20 and 40 megs and I still get SQLITE_NOMEM errors from time to time. C - To unsubscribe, send

Re: [sqlite] Re: building a custom DBD::SQLite

2007-11-25 Thread P Kishor
and therein lies the tale of computer programmers and users... Scott, and others... I *am* good at a few things, but compiling programs is not one of them. I am basically a copy artist -- I can follow instructions, but the instructions have to be good and explicit. And then, I can create new good

RE: [sqlite] [OT] "encrypted" e-mail address (was Re: [sqlite] sqlite3Explorer)

2007-11-25 Thread Cariotoglou Mike
no, a mistake. the address IS : mikecar at singular dot gr (mike will also work) thanks for pointing out the header problem. I was hoping the mailing list was "hiding" this info, obviously not An unencrypted address was plainly visible in the message headers ("From" and "X-Return-Path").

RE: [sqlite] sqlite3Explorer

2007-11-25 Thread Cariotoglou Mike
ooops mail obfuscation was wrong! it is actually : mike atsign singular dot gr (I used ampersand in the original post which was wrong. well, english is not my native lang...) - To unsubscribe, send email to [EMAIL

[sqlite] sqlite with C++

2007-11-25 Thread Andreas Volz
Hello, I used this minimal example code to test my sqlite connection. This works without problems. But now I tried to move the 'db' variable into the private member section of my 'Cache' class to access it from various member functions. That's all. I would assume that this makes no difference.