Memory resident database with locate

[liewald]

Does anyone have any recomentations for a decent memory resident database with a functioning locate statement. I've tried installing rx but it's just killing the IDE.

Help would be greatly appreciated
 

[tatamata]

You can use BufDataset. Locate works for it...

[LuizAmérico]

You can you use TSqlite3Dataset with a memory database:

Sqlite3Dataset.FileName := ':memory:';
Sqlite3Dataset.TableName := 'MyTable';
Sqlite3Dataset.FieldDefs.Add('Field1', ftString);
Sqlite3Dataset.CreateTable;
Sqlite3Dataset.Open;
//data manipulation
Sqlite3Dataset.Close; 

[liewald]

Thanks Guys got it, used bufdataset 

[bentrem]

*1st post; new to FP/Lazarus*

Is BufDataset *nix only?
My text analysis project involves 182K keywords; 5K texts; 230K pages ... my new box (running XP Pro) has 6Gig DDR3. I'm thinking this is the way to go.
Is there a Windows analog?

(I'm almost trolling for a substantial reason to install Linux.)

TIA
ben

[tatamata]

No, it is not Unix only.
In fact, in recent snapshot downloads, the visual wrapper for BufDataSet component is already included in the default installation (see under Data Access tab). DOwnload daily snapshot, so you will see for yourself.
See also http://wiki.lazarus.freepascal.org/How_to_write_in-memory_database_applications_in_Lazarus/FPC#TBufDataSet
which I wrote while there was no such wrapper, but it could still be helpful.

[davesimplewear]

One reason to switch would be only 3gb memory for xp, the rest is wasted.

Regards
Dave

[bentrem]

One reason to switch would be only 3gb memory for xp, the rest is wasted.

I didn't build this box with programming in mind, but all that sand may come in handy! (It's custom for ArmA2, the idea being to have a 3Gig RAM disk.)