[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: wacky XML

• To: "Simon St.Laurent" <simonstl@s...>,<xml-dev@l...>
• Subject: RE: wacky XML
• From: "Chris Wilper" <cwilper@c...>
• Date: Mon, 19 Jan 2004 06:58:06 -0500
• Thread-index: AcPUo7GPNNLeASU1TbaDIDcN8c6bSgJ1VBkG
• Thread-topic: wacky XML

This is a pretty late response, but...

I use XML to avoid Database DDL madness.  Googling "ddl xsql" or "sqlml" reveals a couple other attempts at similar functionality.

Basically, in my app, I define:

<database name="abc123">
<table name="myTable">
  <column name="col1" type="int(11)" autoincrement="true">
    <comment>The first column</comment>
  </column>
  <column name="col2" type="varchar(32)" index="col2"/>
</table>
</database>

At install-time, I pass these through a translator that generates db-specific DDL calls (like CREATE SEQUENCE/TRIGGER for autoincrements in oracle).  Then I pipe that through the appropriate database driver and voila: I've saved precious brain space while supporting McKoi, Oracle, and MySQL as backend dbs.

Of course my favorite thing about this is that I can tweak our app's database schema in vi with xml syntax highlighting.

- Chris

-----Original Message-----
From:	Simon St.Laurent [mailto:simonstl@s...]
Sent:	Tue 1/6/2004 5:22 PM
To:	xml-dev@l...
Cc:	
Subject:	 wacky XML
I'm trying to convince a few people that XML is still interesting stuff,
and that people are doing amazing things with it.  I think that kind of
conversation might also add some relevant but entertaining conversation
to the list.

[..truncated..]

• Prev by Date: Re: Postel's law, exceptions
• Next by Date: RE: [Announce] New book on XML in Microsoft Office 2003
• Previous by thread: RE: wacky XML
• Next by thread: Problem with display of XHTML files...
• Index(es):
  • Date
  • Thread