[sqlite] A question about the mailing list archive...
Is there anyplace to download the mailing list archive in mbox format? -joe -- Person who say it cannot be done should not interrupt person doing it. -- Old Scottish Proverb
[sqlite] Bare btree.c usage...
Hello all, Was there a discussion on this list about using the btree layer? I've searched the list and can't find the messages I *think* I remember. What I *think* I remember is someone sharing a shell of how to use the btree stuff standalone. I apologize in advance for not looking closer at the source code to answer my own question. After I sort all this out, I'll try to post a simple example of how to use it. TIA, -joe -- Person who say it cannot be done should not interrupt person doing it. -- Old Scottish Proverb
[sqlite] A late Christmas gift / early New Year's gift...
I'm offering 4 gmail invitations to the first four people on this list that ask for them. Thanks again for this community! -joe -- Person who say it cannot be done should not interrupt person doing it. -- Old Scottish Proverb
Re: [sqlite] Storing text in sqlite vs. external flat file
If you decide to store the text in an external file, you might check out this library to make this process a bit more fault tolerant (like sqlite): http://users.auriga.wearlab.de/~alb/libjio/ Cheers! -j On Fri, 10 Sep 2004 13:21:08 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I am looking into using sqlite for storing some data that will be ~100,000 > records in size, where each record will contain text that has an average > size of 40k, but could be > 200k. I will likely need to encrypt (and > potentially compress) the database. > > My question is whether to store the text in the database, or to keep a > separate file for the text with seek pointers and lengths in the database. > My preference is for the former, since I wouldn't have to manage a separate > robust encryption/compression/deletion process, but I am concerned about the > perf and size of the insertion stress experiments I've been running, and > I've seen comments on this list suggesting the latter for BLOBs. Are there > specific tuning tweaks I can make to improve my results? > > Thanks, > > Ken Cooper > >
Re: [sqlite] Lemon Parser Examples - I'll show you my examples
Many thanks for your contribution! -joe On Wed, 4 Aug 2004 22:02:48 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > A user earlier posted a question about terminating > the grammer for a simple calculator done with lemon. > > I ran into the same problem and had to use > the following, which worked fine: > > main ::= in. > in ::= . > in ::= in state NEWLINE. > > I cannot reduce it any further. For instance, > the following does not work: > > in ::= . > in ::= in stmt ENDLINE. > > The version of lemon I'm using is from the > cvs 3.0.3. > > The full calculator, there are 4 examples, can > be downloaded from the following link: > > http://prdownloads.sourceforge.net/souptonuts/lemon_examples.tar.gz?download > > Look at example4.y, if you want to go directly to > the terminating issue above. Everything should be in > this download including lemon.c and lempar.c, so you > won't have to download anything else. > > Take a look at the README. I tried to add documentation > on creating custom tokens, destructors, and a little bit > on what the grammer does. > > To run everything, just run make > >$ make > > Then, each example can be run separately > >$ ./ex1 > >$ ./ex2 > > >$ ./ex4 > > Anyway, I hope this examples will help. Or > inspire you to take a took at lemon. > > Regards, > > Mike Chirico > >
Re: [sqlite] LEMON Examples
I'll second sporkey, would you be able to post your calc source for us all to see? TIA, -j On Tue, 03 Aug 2004 15:38:53 -0400, John Cohen <[EMAIL PROTECTED]> wrote: > Hi all, > > Thanks for all the help! I got it all working fine.. The wrapper did the > trick - I also want to try some speed tests with the others, and see which > is the fastest (which I doubt there is a measurable difference in them, but > its always worth the effort). > > Thanks again, > John > > _ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > >
[sqlite] Examples of SQL available?
Hello all, I hope I've not missed something in the sqlite web pages or mailing list. What I'm looking for is a good set of SQL examples for more esoteric feature (to me at least) of sqlite. Some topics I'd like to understand are: triggers constraints I have Celko's "SQL for Smarties" book, alas I suppose I'm not smart enough to make good use of the book. If there are any good "non-online" resources available for this kind of thing, I'd like to know you all's opinion. Since I approached sqlite from a non-database background (well, to be honest, my last work with DB's was in the DBase era), I may have some new paradigms to adopt. Thanks in advance for your helpful suggestions! Long live sqlite! -joe - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]