Memory resident database with locate
lazarus / 16-Databases

----------------------------------------------------------------------
liewald · 2010-02-14 17:27

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 · 2010-02-14 19:43

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

----------------------------------------------------------------------
LuizAmérico · 2010-02-15 00:07

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 · 2010-02-16 09:16

Thanks Guys got it, used bufdataset

----------------------------------------------------------------------
bentrem · 2010-04-15 01:18

*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 · 2010-04-15 03:26

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 · 2010-04-15 04:51

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

Regards
Dave

----------------------------------------------------------------------
bentrem · 2010-04-15 17:48

Quote from: davesimplewear on April 15, 2010, 06:51:51 amOne 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.)