Web Development and Marketing

16 Mar, 2008

XML in Database

Posted by: revvi In: General

There are one thing that I missed from current MySQL which is XML function. It’s kind of tricky to perform XML functions in there. A common trick is to store xml tags within a string/text field. Then you may do any XML stuff manually in your script.

PostgreSQL 8.3 has this XML integrated.. finally! There are set of XML functions already there. It means you can have for
example searching inside the tag directly. It speeds up anything as the process will be performed in the database.

I wish that MySQL can have this unique feature embedded in the next version.

5 Responses to "XML in Database"

1 | XML in Database | Technology

March 16th, 2008 at 8:38 pm

Avatar

[...] Read the rest of this great post here [...]

2 | Blog » XML in Database

March 26th, 2008 at 1:35 am

Avatar

[...] Tim wrote an interesting post today onHere’s a quick select [...]

3 | Rich

March 28th, 2008 at 9:31 am

Avatar

XML tuh ukuran baju ya? Hiihihi

4 | 4b1L

May 25th, 2008 at 8:16 pm

Avatar

learning XML is so difficult for a newbie like me :(

5 | dj0k3rz

June 12th, 2008 at 2:14 pm

Avatar

it will be added fosho….hehehe….all we need just a little patience..(Guns N’ Roses said so) =)