Re: [sqlite] query on match between application and sqlite

2007-02-20 Thread Jay Sprenkle
On 2/19/07, Eric S. Johansson <[EMAIL PROTECTED]> wrote: The application is an experimental anti-Spam testbed exploring the use of reputation through proof for puzzles and user interaction. The list of things I'm tracking is fairly significant (for me) and I'm trying to pull things together.

Re: [sqlite] query on match between application and sqlite

2007-02-19 Thread P Kishor
On 2/19/07, Eric S. Johansson <[EMAIL PROTECTED]> wrote: Joe Wilson wrote: >> 2) can I use it for a message store and have it run faster than a 1 >> message per file system? > > What does that mean? Is "file system" a unit of time? ack! bad sentence construction... comparing a system storing

Re: [sqlite] query on match between application and sqlite

2007-02-19 Thread Joe Wilson
> 1) need to know if sqlite can help me cut down on the number of little db's Sure. > 2) can I use it for a message store and have it run faster than a 1 > message per file system? What does that mean? Is "file system" a unit of time? You can store messages in BLOBs or as TEXT in an SQLite

Re: [sqlite] query on match between application and sqlite

2007-02-19 Thread Eric S. Johansson
Eric S. Johansson wrote: Again, I do most sincerely apologize for size of this request. I've spent 30 years avoiding databases and I guess this is payback. :-) Any advice, good online tutorials on SQL, or feedback would be valued. urk. I hate it when I forget to ask for what I need after

[sqlite] query on match between application and sqlite

2007-02-19 Thread Eric S. Johansson
I apologize if this comes across as a "do my homework for me" type of query but I'm in a bit of a bind and I'm trying to come up to some reasonable amount of knowledge in less than no time. I've been using ad hoc DBM files for a variety of small databases and well, it's crumbling. I'm seeing