[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: 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..]
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|