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
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
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.
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
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
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.
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
&
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
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
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
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
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
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.
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.
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,
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
16 matches
Mail list logo