Subj : Re: Database program to just work with text files?
To   : comp.os.linux
From : adams_forum
Date : Tue Aug 24 2004 01:17 pm

> > 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.

I couldn't find a way to import data from a text file into SQLite.  Is
that what I need Perl for or is there a command to do this and if so,
what is it?

.