Subj : Re: Database program to just work with text files?
To   : comp.os.linux
From : Jerry McBride
Date : Sat Sep 18 2004 01:52 pm

Adam wrote:

> Hello,
> 
> Does anyone know if there exists a database program for Linux that
> just modifies one or more text files?
> 
> I've been using mysql, but I don't want something for networks; I
> don't like the daemon that runs in the background (according to top
> and KDE System Guard, it has 4 threads running taking about 25MB
> each!).  I just have a personal "database" consisting of tab-separated
> values and I want to query it with SQL statements rather than look
> through the file.
> 
> All I want is a program to do the following:
> 1. open 1 or more text files, 1 file per database table
> 2. read the data into memory
> 3. execute an SQL statement on it
> 4. if the statement was a modification, save the data back
> 
> Permissions would be handled by the file permissions and owner(s), no
> daemons, no networks, no sockets, just nice and simple.

Well.... mysql is perfect for just about any database project that uses sql.
However, have a look at kirbybase... You can use either python or perl for
your scripts... nice for small, embedable projects.


-- 

******************************************************************************
                     Registered Linux User Number 185956
              FSF Associate Member number 2340 since 05/20/2004
             Join me in chat at #linux-users on irc.freenode.net
    Buy an Xbox for $149.00, run linux on it and Microsoft loses $150.00!
    12:49pm  up 18 days, 13:02,  6 users,  load average: 2.92, 2.99, 2.99

.