[Tfug] Managing data

Glen Pfeiffer glen at thepfeiffers.net
Fri Dec 11 11:20:22 MST 2009


On 10 Dec 2009, Claude Rubinson wrote: 
> I'm thinking that I'm just going to write a script that reads the
> various tables and creates SQL statements from them to (re)create the
> data.  Then I can just hook that script into Emacs such that when I
> modify a text file and save it, the data in the database gets
> automatically updated.  The database would be only for reading and all
> data maintenance would be done on the text files.

Another approach may be to find a database platform that uses 
formatted plain text files for its storage. Then edit with emacs; 
query with the db tool.

I know that MySql has different engines. Does anyone know if it 
has an engine that stores the data in a plain text file that is 
easily edited by hand? And would that cause problems for MySql?

I dunno, but it seems a bit far fetched now that I've written it.

-- 
Glen 





More information about the tfug mailing list