MySQL, SQLite and Y_INI - Printable Version

MySQL, SQLite and 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, SQLite and Y_INI (/showthread.php?tid=650871)

MySQL, SQLite and Y_INI - IdonTmiss - 08.03.2018

So yeah first of all which one is the best, like fast loading and stuff probably MySQL, but that's complicated i think

so between SQLite and Y_INI which one is better, faster etc

And can you load accounts from Y_INI to SQLite/MySQL

Re: MySQL, SQLite and Y_INI - Stev - 08.03.2018

I would suggest using MySQL, because in the future you can always make a user control panel or you want to attach database to websites. I would recommend this.

As for the speed comparison, I would say they are both very similar speeds.

Re: MySQL, SQLite and Y_INI - IdonTmiss - 08.03.2018

Quote:

Originally Posted by Stev

I would suggest using MySQL, because in the future you can always make a user control panel or you want to attach database to websites. I would recommend this.

As for the speed comparison, I would say they are both very similar speeds.

Oh so let's say i don't know like anything about MySQL like how to database functions and stuff i know how to create one but idk how to load users and stuff so can u suggest me a full thro tutorial

Re: MySQL, SQLite and Y_INI - Stev - 08.03.2018

There are many tutorials to be with MySQL, It's the case of searching in forums.

Re: MySQL, SQLite and Y_INI - Sew_Sumi - 08.03.2018

SQLite vs YINI, you'd have to wonder what ****** would recommend for this.

In long term it's wise to dabble in MySQL, but if you're not keen and are more focused on learning Pawn, then don't worry, it's not important.

If you know YINI, or even a little SQLite, then these wouldn't be a bad avenue, but if you are learning all of them, hit MySQL...

https://sampforum.blast.hk/showthread.php?tid=290257 Read this, beware it is old, but it's more for the MySQL server setup, and the 'basics'... More reading material than a tutorial.

https://sampforum.blast.hk/showthread.php?tid=627520 This is more a decent tutorial that many use as it's simple and mainly for accounts, but using this, you could expand it to be more than this.

Re: MySQL, SQLite and Y_INI - IdonTmiss - 09.03.2018

Quote:

Originally Posted by Sew_Sumi

SQLite vs YINI, you'd have to wonder what ****** would recommend for this.

In long term it's wise to dabble in MySQL, but if you're not keen and are more focused on learning Pawn, then don't worry, it's not important.

If you know YINI, or even a little SQLite, then these wouldn't be a bad avenue, but if you are learning all of them, hit MySQL...

https://sampforum.blast.hk/showthread.php?tid=290257 Read this, beware it is old, but it's more for the MySQL server setup, and the 'basics'... More reading material than a tutorial.

https://sampforum.blast.hk/showthread.php?tid=627520 This is more a decent tutorial that many use as it's simple and mainly for accounts, but using this, you could expand it to be more than this.

Thanks i already know how to setup a database and how to connect to it but thanks anyway gonna use the second one tomorrow for now i wrote the code gonna play with it tomorrow try do something else

Re: MySQL, SQLite and Y_INI - AroseKhanNiazi - 09.03.2018

Y_INI or SQLite if you don't have big plans. Y_INI is pawno's so for that you don't have to learn an another language but for using MySQL you need to learn another language. MySQL is easy if you want to use data in multiple places. I'll suggest that as my personal preference.