Why there is SQL and NOT XML!

Hi,

Since everyone asks why they should use SQL instead of XML here is a thread with the answer.

First of all:

SQL stands for Structured Query Language and is used for data storage.

XML stands for eXtensible Markup Language and is mostly used for customizable files which are ONLY loaded. Saving XML data is not as efficient as saving data using SQL.

Why use SQL?
- SQL is alot faster for both computer & human.
- It's easier to overview.
- It's easier to modify.
- It doesn't require as much space as XML because it's stored as binary.


How I can use a SQL server?
For that you might want to take a visit in our tutorial section or use the search function to find a specific answer!

Recommended tutorials:
http://otland.net/f479/nothing-full...niform-server-forgotten-server-0-3-6-a-77593/
(Absolute beginner tutorial on how to get server, database, website up and working, and how to use it).

http://otland.net/f137/tutorial-how-setup-mysql-database-updated-detailed-guide-49/
(An Detailed tutorial about how to setup a sql database using MySql)
http://otland.net/f137/how-setup-mysql-database-photos-4882/
(Setting up a Sql database with images)
http://otland.net/f137/lets-get-started-sql-mysql-7463/
(Another tutorial to help you out from step to step)
If you know any helpful information or want to correct some wrong info then you can send me a private message about this!

That's all from now and I hope I've helped you atleast a bit from creating or understanding a SQL server!

Great, hope the newbies knows this now

I like XML

I learned SQL by a tutorial made by Black Swordsman at Tibiafans

Tho it was like 6 months ago.

Neon said:

I like XML

Click to expand...

who dosnt

Great job I love SQL!

I loved XML too but there's no choice .

XML is disappearing from Open Tibia community !

for newbies is xml the best coz like all say fix something in config then fix your acc then just open the ot
but sql you neeed to follow the whole tutorial to use sql
then when you are done you need to fix all this blas bla download
bla bla myphp something...
but i must say like Xenios said SQL is much better then xml
more stabile

RamboIII said:

who dosnt

Click to expand...

Me..
Anyways, most of people like xml more because its the first one they try and when they switch to sql and they don't find players and account folder they gte in panic.

RamboIII said:

who dosnt

Click to expand...

I dont. ^.-

Jester is right. Xd

Sqlite is not harder nor complex than XML :blink:

XML is old.But I still like it a little.I'm using one right now because me and my friends don't feel like hosting an 8.31 SQL server.And also because we don't want to take 6 days/weeks editing all of the monsters,spells.

In ots delete char -.- ;ss ?

XML is easyer to follow 100000000x times
but
SQL is ofc. faster and u need learn SHITS

You can also run quick and nice queries to modify all players at the same time or so.. you could do it in XML too by PERL scripts but I prefer SQL

I loved xml...
but not much server 8.1 + :/

I downloaded Forgotten Server and all is fidne it's running and other player can play too^^
But at first I want to run it like XML and not SQL but for this I need a data called "Player" where is it?^^
Cause I have to make CM's and other position of Acc. Manager
Can you help me?
Sry maybe this post is at the wrong palce then delete it...

P.S: I will use SQL at the weekend but now my programs got bugs^^

Try this tutorial: http://otland.net/f137/how-setup-mysql-answers-normal-errors-too-photos-now-11804/

I think Jester is right too^^
Taht's my problem xD