From: Clark C . Evans <cce@cl...> - 2001-07-29 05:21:31
----- Forwarded message from "Clark C . Evans" <cce@...> -----
Date: Sun, 29 Jul 2001 01:26:00 -0400
From: "Clark C . Evans" <cce@...>
Subject: Re: [sml-dev] Problem: GUI-less RDB data entry
| I want an easy, generic way to get data in and out of a
| relational database...
Definately. This is my problem domain.
| It would also be nice to be able to maintain all the data
| in the database via file system text files. Perhaps a database
| table is just a (read-only) run-time image of my text file data.
| Perhaps these text files are a just an easy-to-read and grep
| snapshot of the database or some portion of the database.
| Perhaps I have a way to change data in either the DB or the
| text files and, on demand, synchronize the two (or push data
| in one of the two directions).
Neat. I'm all for this. I've been working on implementing
a YAML interface for PostgreSQL. You might find some
of that interesting. Since YAML has the List and Map
data structures, the mapping is relatively easy...
Four hours were wasted today
re-installing Win2K for the
10th time. I think it's a
problem with my memory...
Wrote up an e-mail to SML-DEV
list and posted it! The hours
spent is a null value.
| A single text file could group a set of related data,
| regardless of whether the data belonged to a single table.
| For example, if I had a person table and a journal-entry table,
| one file could list one record of the person table and all of
| journal-entry records that belong to that person. Seems
| ideal for 1-M relationships. Might we squeeze a way to
| manage relationships out of this too?
See the above... since YAML is a graph, you can do M-M
relationships as well... ;)
| I see myself maintaining my data in RDBMs. The data I care
| about conforms nicely to this model of data representation.
| I don't need mixed content
| I don't need hierarchy. (But I do need relationships.)
Aka, you need graph structure...
| What language and tool set would be ideal for addressing
| this problem? Is anyone in this group interested in
| exploring this space?
Yes, but I'm very biased since I have enormous amount
of time invested in YAML and since YAML has the support
of many others such as Oren Ben-Kiki, Brian Ingerson,
Jason Diamond, and Neil Kandalgaonkar. I can't just
start from scratch again... however, YAML is still
young enough where you could have some significant
impact... I removed most of my discussions of this
topic from SML-DEV since it seemed to be restricting
itself to XML compatible syntaxes...
----- End forwarded message -----