Re: [sqlite] Local data structures vs sqlite

2009-11-06 Thread Jean-Christophe Deschamps
>I just don't want anyone saying "but >this one dude told me to replace all my structs with SQLite memory >tables." Indeed that wouldn't be very clever SQLite promotion! >I think the best plan in this case would be to get a real language But, surprisingly this thing is a real language, with

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread John Crenshaw
>>I wouldn't use SQLite for most in memory data that never needs to be >>stored on disk > >Even this depends entirely on your context. Of course if only a simple >lookup in a table is more or less all you ever need, there is little >point in SQLite. But if or when your requirements get more

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Jean-Christophe Deschamps
>Nice Freudian slip! Again rotfl, when you know that slip is French word for men underwear... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Jean-Christophe Deschamps
>I think "worth" should be more accurate. Yes, rotfl! I realize this while hitting Send and didn't dare one more post. You know, I'm a victim of rogue cosmic rays and badly need one of those stock ECC brains. Sorry for my French accent btw! ___

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Mohd Radzi Ibrahim
I think "worth" should be more accurate. - Original Message - From: "Jean-Christophe Deschamps" <j...@q-e-d.org> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Friday, November 06, 2009 9:47 AM Subject: Re: [sqlit

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Bruce Robertson
On Nov 5, 2009, at 5:44 PM, Jean-Christophe Deschamps wrote: > Hi John, > >> I wouldn't use SQLite for most in memory data that never needs to be >> stored on disk > > Even this depends entirely on your context. Of course if only a > simple > lookup in a table is more or less all you ever

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Jean-Christophe Deschamps
You read 'worse' instead of 'worst', of course! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Jean-Christophe Deschamps
Hi John, >I wouldn't use SQLite for most in memory data that never needs to be >stored on disk Even this depends entirely on your context. Of course if only a simple lookup in a table is more or less all you ever need, there is little point in SQLite. But if or when your requirements get

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread John Crenshaw
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan Sent: Thursday, November 05, 2009 5:44 PM To: General Discussion of SQLite Database Subject: [sqlite] Local data structures vs sqlite I saw a presentation on sqlite by Dr

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread Kavita Raghunathan
Ok, sqlite group, please accept my apologies. It was thoughtless of me. On 11/5/09 4:54 PM, "P Kishor" wrote: > First, you shouldn't hijack a thread. If you have a new subject, start > a new email thread instead of using an existing one. > > > On Thu, Nov 5, 2009 at 4:43

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread D. Richard Hipp
On Nov 5, 2009, at 5:43 PM, Kavita Raghunathan wrote: > > I saw a presentation on sqlite by Dr Hipp that mentioned that > anytime I'm > storing data in structures or tables, I should be thinking about using > sqlite instead. > > Would it be more efficient to use the sqlite database to store a

Re: [sqlite] Local data structures vs sqlite

2009-11-05 Thread P Kishor
First, you shouldn't hijack a thread. If you have a new subject, start a new email thread instead of using an existing one. On Thu, Nov 5, 2009 at 4:43 PM, Kavita Raghunathan wrote: > > I saw a presentation on sqlite by Dr Hipp that mentioned that anytime I'm >

[sqlite] Local data structures vs sqlite

2009-11-05 Thread Kavita Raghunathan
I saw a presentation on sqlite by Dr Hipp that mentioned that anytime I'm storing data in structures or tables, I should be thinking about using sqlite instead. Would it be more efficient to use the sqlite database to store a table that Looks like this: where lets say I'm looking for the word