MySQL XML XSLT

[k1000]

Hello,

Just want to have feedback about applying XSLT on XML doc stored in a MySQL Database.

Can i integrate XSLT processor as an UDF of MySQL ? Is it relevant ?

Thanks

K1000

[[deleted]]

Depends on how complicated you want to make your development. XML is basically a plaintext database, so storing that in MySQL makes no sense.
The applying XSLT while you have PHP makes little sense either.

MYSQL->XML->PHP->XSLT->HTML how many layers do you want? 🙂

[k1000]

All i want to do is trying to use each of this standard :

• PHP to contain the business logic of the application
• XSLT to generate the output (HTML, WML, ..)
  from XML datas
• XML/mysql to store datas

Do you suggest me that XML datas have to be stored as files ?

Thanks

K1000

[[deleted]]

"Do you suggest me that XML datas have to be stored as files ?"

No, what I'm saying is that XML is a way of storing data, much like how a database stores data. So if you are going to store XML in a database, it is like storing a database in a database, which makes no sense.

(XML itself is good for containing data, but it is very bad (very very bad) for data storage. You can't effectively use XML as an alternative for a database, it just doesn't work.)

The same thing goes for the XSLT layer, it is used to transform XML into HTML, but so is PHP.

So what you'd be doing is use PHP to get data from mysql and generate XML, which is fed to XSLT which then transforms it into HTML.

But you could also use PHP to get data from mysql and generate HTML immediately.

XML and XSLT are meant to be distributed, so everyone can interpret the data 'easily'. If you're the only one who uses the data, then save yourself a lot of trouble andforget all about XML and XSLT for now.

[k1000]

Thank you Vincent. I got a better view of what can be used and also why.

K1000