Re: [sqlite] Number of columns in table

Am Wed, 30 Jan 2008 17:04:17 -0700 schrieb Dennis Cote: > > What if I like e.g. to write each table row into a file in one > > line? I need to know when a row is finished and the next begins. I > > could compare azColName, but I hope there is a better way. > > > > Andreas, > > Your

[sqlite] Number of columns in table

Hello, It's simple to the the maximum number of rows in a table with SELECT count(*) FROM table But how to find out the number of columns for a query like: SELECT * FROM table My practical problem is the read callback function: int readCallback (void *data, int argc, char **argv,

Re: [sqlite] Using sqlite3 from multiple threads

Am Wed, 9 Jan 2008 10:20:31 -0800 (PST) schrieb Ken: > Definately use 3.5.4. > > Not sure how to determine at compile time if the threadsafe part is > enabled. You can always compile yourself to guarantee its set, thats > what I do. > > sqlite will lock the database file for you automatically.

Re: [sqlite] Using sqlite3 from multiple threads

Am Wed, 9 Jan 2008 10:20:31 -0800 (PST) schrieb Ken: > Definately use 3.5.4. > > Not sure how to determine at compile time if the threadsafe part is > enabled. You can always compile yourself to guarantee its set, thats > what I do. > > sqlite will lock the database file for you automatically.

Re: [sqlite] Using sqlite3 from multiple threads

Am Wed, 09 Jan 2008 18:17:55 + schrieb [EMAIL PROTECTED]: > Andreas Volz <[EMAIL PROTECTED]> wrote: > > > > I've only 3.4.1 installed. But Gentoo has 3.5.4 in the unstable > > tree. I'll install that one if needed. > > > > I see this idea ex

Re: [sqlite] Using sqlite3 from multiple threads

Am Wed, 9 Jan 2008 09:03:35 -0800 (PST) schrieb Ken: > Andears, > > SQLITE 3.5.x is thread safe when configured and compiled with > --enable-threadsafe. I've only 3.4.1 installed. But Gentoo has 3.5.4 in the unstable tree. I'll install that one if needed. And is it possible to find out at

[sqlite] Using sqlite3 from multiple threads

Hello, I like to use sqlite3 from a multi-threaded application. The situation is that I've several threads that like to write into a single DB file and into the same table. I read something about sqlite is thread save. But I'm not sure how much. Is it allowed to open the DB file and table

[sqlite] Date functions

Hello, I like to save a date for each row in my database. Later I would select the rows with a query: SELECT * FROM Store_Information WHERE Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999' Is there a date data type in sqlite? I've not found it in the docs. If not, I had the idea to use UNIX

Re: [sqlite] sqlite with C++

Am Mon, 26 Nov 2007 08:36:47 -0500 (EST) schrieb Clay Dowling: > > Andreas Volz wrote: > > 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 > &g

Re: [sqlite] sqlite with C++

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 &

[sqlite] sqlite with C++

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.

Re: [sqlite] BLOB data performance?

Am Tue, 13 Nov 2007 12:46:11 -0800 (PST) schrieb Ken: > I think your blob file performance may greatly depend upon the file > system that it used and the workload. > > I found this article: > > http://oss.sgi.com/projects/xfs/papers/filesystem-perf-tm.pdf Very interesting document. But I

Re: [sqlite] BLOB data performance?

Am Tue, 13 Nov 2007 15:15:49 -0600 schrieb John Stanton: > You might find the method used by Squid to manage its cache would be > worth emulating. I don't know how squid works. Could you explain it in simple steps? > Using TransmitFile on Windows or sendfile on Unix to despatch the > file to

Re: [sqlite] BLOB data performance?

Am Tue, 13 Nov 2007 07:18:19 -0600 schrieb John Stanton: > In a cache situation I would expect that keeping the binary data in > files would be preferable because you can use far more efficient > mechanisms for loading them into your cache and in particular in > transmitting them downstream.

Re: [sqlite] BLOB data performance?

Am Mon, 12 Nov 2007 23:41:59 + schrieb [EMAIL PROTECTED]: > Andreas Volz <[EMAIL PROTECTED]> wrote: > > Hello, > > > > I'll tell you my current situation. I implemented a web cache > > function for images and other data in my application. In the past I &g

[sqlite] Data encryption

Hello, I think about to encrypt the data in my DB. Does sqlite offer a data encryption on a lower level? Or should I encrypt my data before putting it into the table on a higher level in my application without involving sqlite? regards Andreas