Subj : Re: Database program to just work with text files?
To   : comp.os.linux
From : Scott Leighton
Date : Sat Aug 21 2004 08:15 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.


 You should take a look at SQLite. No daemon. www.sqlite.org

 DBD::SQLite available at CPAN provides a Perl interface
to it. Works real well.

  Scott

-- 
POPFile, the OpenSource EMail Classifier
http://popfile.sourceforge.net/
Linux 2.6.5-7.104-default x86_64

.