XML DB Vs MySQL

shahid_146 · 11-12-2005, 01:33 PM

Whenever I have to give an option to admin of the website to be able to change content on individual pages, I store the content in the database (most of the time MySQL). A new guy in my company joined recently and has advised me to use XML for storing text content of the websites which according to him is a better way then storing it into the database.
I want to know what are the main advantages of using XML file for storing text content or are there any ? Would love to know both the pros and cons.

URL: Binarytrends

sjp · 11-12-2005, 01:37 PM

What were that guy's arguments, or did he just tell you to use XML "because it's better" with no arguments supporting his point of view?

shahid_146 · 11-13-2005, 11:17 AM

His argument was that it is faster in accessing. But I wanna know if there are any other benefits as well.

stscac · 11-13-2005, 12:20 PM

I use a combination of the two. I use MySQL for backend administration, and for data that I need parsed that doesn't need to be secure, I use XML. I have also written a tiny bit of VB.NET in my time as a "part-time programmer" and fetching information from a remote database is much easier and creates a smaller exe whwen using XML parsing.

-Steve

sjp · 11-13-2005, 01:08 PM

You need to clarify something else. Are you talking about XML databases or are you talking about XML files? These are two very different things.

XML databases are for example the freeware Berkeley XML DB or Oracle XML DB. These databases can be filled with XML-style information and they can be queried using XPath instead of SQL or something. The concept is relatively new as far as database history goes. I've only used Oracle XML DB briefly myself, I don't have any real experience with them.
????: NamePros.com http://www.namepros.com/programming/139535-xml-db-vs-mysql.html

XML files are just plain-text files in a certain format. They are good for small files like config files but completely unsuitable to access large amounts of data in a fast way. Relational databases are *a lot* faster when it comes to accessing data.

Zubair1 · 11-13-2005, 01:41 PM

I think that using MySQL Database's is a much better choice rather then using XML to parse / access large sets of data time by time. By using XML as files you will quite frankly being using your file storage one way or another that is not for many especially if you are putting large amount of data to it. as the file grows the time to load it also grows. MySQL is fully powered with great features and loads of new coming accessing data from a mysql db is one of the easiet and fastest in my opinion.

Though i suppose maybe XML good for using template engines or reading small data from it.

shahid_146 · 11-15-2005, 01:42 PM

Thank you all for the replies. The conclusion which I get from this discussion is that what i was doing was more apropriate. Means storing my data in MySQL DB than XML files.

I really appreciate your help.

11-12-2005, 01:33 PM	THREAD STARTER #1 (permalink)
shahid_146 NamePros Member Join Date: Sep 2005 Posts: 30	XML DB Vs MySQL Whenever I have to give an option to admin of the website to be able to change content on individual pages, I store the content in the database (most of the time MySQL). A new guy in my company joined recently and has advised me to use XML for storing text content of the websites which according to him is a better way then storing it into the database. I want to know what are the main advantages of using XML file for storing text content or are there any ? Would love to know both the pros and cons. URL: Binarytrends

11-13-2005, 01:41 PM	#6 (permalink)
Zubair1 NamePros Regular Join Date: Mar 2005 Posts: 912	I think that using MySQL Database's is a much better choice rather then using XML to parse / access large sets of data time by time. By using XML as files you will quite frankly being using your file storage one way or another that is not for many especially if you are putting large amount of data to it. as the file grows the time to load it also grows. MySQL is fully powered with great features and loads of new coming accessing data from a mysql db is one of the easiet and fastest in my opinion. Though i suppose maybe XML good for using template engines or reading small data from it. __________________ Live Support : Zubair11 [at] hotmail.com Free SEO Directory! \|\| Free Online TV \|\| Tech Blog Web Design & Web Development Services \|\| Reliable Web Hosting

11-15-2005, 01:42 PM	THREAD STARTER #7 (permalink)
shahid_146 NamePros Member Join Date: Sep 2005 Posts: 30	Thanks guys Thank you all for the replies. The conclusion which I get from this discussion is that what i was doing was more apropriate. Means storing my data in MySQL DB than XML files. I really appreciate your help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 02:24 PM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 01:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 09:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

11-12-2005, 01:37 PM	#2 (permalink)
sjp NamePros Member Join Date: Oct 2005 Location: Andromeda Posts: 136	What were that guy's arguments, or did he just tell you to use XML "because it's better" with no arguments supporting his point of view?

11-13-2005, 11:17 AM	THREAD STARTER #3 (permalink)
shahid_146 NamePros Member Join Date: Sep 2005 Posts: 30	His argument was that it is faster in accessing. But I wanna know if there are any other benefits as well.

11-13-2005, 12:20 PM	#4 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,809	I use a combination of the two. I use MySQL for backend administration, and for data that I need parsed that doesn't need to be secure, I use XML. I have also written a tiny bit of VB.NET in my time as a "part-time programmer" and fetching information from a remote database is much easier and creates a smaller exe whwen using XML parsing. -Steve

11-13-2005, 01:08 PM	#5 (permalink)
sjp NamePros Member Join Date: Oct 2005 Location: Andromeda Posts: 136	You need to clarify something else. Are you talking about XML databases or are you talking about XML files? These are two very different things. XML databases are for example the freeware Berkeley XML DB or Oracle XML DB. These databases can be filled with XML-style information and they can be queried using XPath instead of SQL or something. The concept is relatively new as far as database history goes. I've only used Oracle XML DB briefly myself, I don't have any real experience with them. ????: NamePros.com http://www.namepros.com/programming/139535-xml-db-vs-mysql.html XML files are just plain-text files in a certain format. They are good for small files like config files but completely unsuitable to access large amounts of data in a fast way. Relational databases are a lot faster when it comes to accessing data.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

XML DB Vs MySQL

Thanks guys