Mysql vs Y_INI - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql vs Y_INI (/showthread.php?tid=395124)

---

Mysql vs Y_INI - Michael_Cruise - 25.11.2012

Hi, Can you guys tell me which one is the best? (MySql or Y_INI)
I am going to learn any 1 of them ...
Please do tell me which one is more usefull for scripting!

---

Re: Mysql vs Y_INI - JJones432 - 25.11.2012

If you are new to scripting, I would suggest Y_INI and use file based systems rather than databases. It will help you out a lot.

---

Re: Mysql vs Y_INI - Glad2BeHere - 25.11.2012

MySQL better and faster to use because thats linking playerstats to the internet
YINI is easier to learn and just as fast as mysql and me result in u making less error and preferable for a beginner @ scripting

Learn YINI so u get a jiff of things and understand what u are doing in the world of scripting then learn MySQL cause its not gonna be easy because u will also need slight web knowledge when doing this because MySQL cannot run without the web, so if u was to have a server MySQL must be hooked up to the website or else server wont run so its your decision but i recommend using YINI and then learn MySQL

---

Re: Mysql vs Y_INI - ikkentim - 25.11.2012

Mysql. Why use y_ini to migratebto mysql later on?

Mysql is THE storage enigine, since it's easy to query bans, stats, players, other stuff. And the biggest pro is external connection for for example a website

---

AW: Mysql vs Y_INI - Skimmer - 25.11.2012

If you are new in scripting, start from Y_INI.
But i use always MySQL, because i can call values from my MySQL to my website.

---

Re: Mysql vs Y_INI - [FSaF]Jarno - 24.06.2013

Sorry for bumping an old thread, but this question is mostly for ******, since i believe he has tested the speed difference.

Is MySQL actually faster than y_ini? For me that doesn't make any sense at all.
First of all, y_ini opens a LOCAL file, writes into it and saves it.
If i have understood anything about MySQL, it sends a packet to the mySQL server, the server processes the query and saves the information. Since you have to send the packet to mySQL, it would make sense that that would add more latency.

---

Re: Mysql vs Y_INI - Deken - 22.12.2018

Question for ******
Now if i have y_ini register system can player hack them or something like that

---

Re: Mysql vs Y_INI - Logic_ - 22.12.2018

That depends on your code and how protected your VPS is.

Same goes for your MySQL code.

---

Re: Mysql vs Y_INI - Gammix - 22.12.2018

This should not be a question, its pretty clear INI file system is meant for intializing not to be used as some sort of database. E.g. you can store server settings in your ini file and then parse them from the ini file into an array for runtime usage, when your gamemode starts.

MySQL on other hand, can be used as a user database, personal vehicles, etc. With better speed and ability to read/write/update multiple rows with complex condition statements.

---