XML vs SQL - Your Thoughts!

[Zaggyzigzig]

I use to host a long time ago with xml, It banked every player in files inside the server, Also I remember how easy it was to edit things...

Then SQL Comes OUT! 10x easier to manage, saves space on my pc because it wont use as much computer resources, And on top of it all! It's password protected unlike xml!

Whats your thoughts, What do you use? And how does it effect you?

 

[Evan]

The answer is pretty obvious.

I don't think there is a single XML server out there.

 

[Zerak]

I think he is comparing SQLite with MySQL

 

[Tony32]

I think he is comparing SQLite with MySQL

He's not. There used to be XML servers before MySQL/SQLite servers.

 

[Zerak]

He's not. There used to be XML servers before MySQL/SQLite servers.

Oh, just made a quick research, thank you

 

[Evil Puncker]

SQL all the way.

 

[Breed]

Actually xml is easier to edit, read & backup than sql, xml is more merciful if you make a mistake unlike sql if you make a mistake with a query you may need to resintall the entire database.

Parsing an xml document into a readable format is simpler than that of sql, security wise xml sucks lol

Depends really tho on what job your using either for.

 

[Tony32]

Oh, just made a quick research, thank you

It's cool man


Also OnT, XML is also much slower loading wise compared to SQL. A long time ago when the "switch" was made from XML to SQL someone had a thread on the pros and cons between them, including benchmarks. I believe it doesnt exist anymore doe.
Some would say that XML is easier to edit as said earlier, but some people think SQL is. That's a matter of preference I would say

EDIT 3:
Found some old threads about it, might have some good info in there.
http://otland.net/threads/sql-vs-xml.302/
and http://otland.net/threads/why-there-is-sql-and-not-xml.12234/

 

[Breed]

Also OnT, XML is also much slower loading wise compared to SQL. A long time ago when the "switch" was made from XML to SQL someone had a thread on the pros and cons between them, including benchmarks. I believe it doesnt exist anymore doe.
Some would say that XML is easier to edit as said earlier, but some people think SQL is. That's a matter of preference I would say

Not a troll post, but if sql is faster at loading data, why is the items.xml file data in xml format and not stored in the database?

Actually I think that is a really good question and has it been asked before.