xml as database
- Started
- Last post
- 8 Responses
- seed
Does anyone have any good links or tips on how to use an xml file as a simple database. I am not finding any straight forward info yet. I mainly want to display a list of painting titles link that pass an ID to show the work detail. I can do this with a database and CF, PHP or ASP but I won't have access to mySQL for this and don't want to use MS Access.
- heavyt0
iTunes uses an XML database. You can look at your library XML file for an example of structure.
TR1
- Hello-Sexy0
you really cant use it as a database, xml is more used as a way to store/transfer information in a well structured, universal format.... (you can do other stuff but not effectively)
meaning there isnt an efficient way to send a sql statement and have it query the xml file, if that is what you are looking for...
what is your font end?
if its flash (and the xml isnt too big) you can import the xml, parse it into an array and search through that... basically using flash to search the xml...
- heavyt0
xslt handles all of that parsing.
http://www.w3.org/TR/xslt
You do not need flash, or SQL to do this.TR1
- enjine0
xslt doesn't handle the parsing, XPath does.
and yes, you can use xml as a database. a lot of people were doing that before mysql became huge.
- Kevin_Sweeney0
just use a CSV flat-file to store everything.
- nRIK0
enjine is right. anyways, heres something quick:
http://pastebin.coconut.se/?id=4…
- ********0
I used to use XML as a dB working with RoboHelp from Macromedia. Pretty slick. You could develop search engines and put them on CD-ROM. No connection needed.
Ace!
- seed0
Thanks for the info. I am still having a hard time finding much on the subject. I normally use ColdFusion and found how to display the data in only a few lines. I'm still not sure how to loop it to display multiple records though.