Should I switch to YSI/y_ini?
#2

I'm going to break my 1337 post count for this but I'll tell you something...

This question has been asked countless amounts of time. Using Dini is a mistake since it's very poorly slow and was made just to ease out to work with files, but later we got to see SQLite implementation and MySQL plugins in SA-MP.

Many people go forward to learn different saving systems rather than SQL because they think it's hard or useless, whereas SQL is a different language. It's not something that you'll just use in your SA-MP modifications, but also when you work with web development, and other projects.

SQL provides database relations and so much features, that it's something that you should use as a saving system rather than other INI/ file based solutions that are not just slower, but also come up with bugs and other issues. For example, if you need help with a INI file, many people would just give their guesses but if you get stuck with SQL, you will not just find SA-MP forum to help you with that, but also different websites and communities.

Also, there's no fast way to convert anything to a different saving system, take your time and do your changes slowly since you're new to it. Put your time in learning it and adapting your script to it and to be just dependent of it.

SQLite is a built-in native implementation in SA-MP server and it doesn't require a SQL server to store the database, it saves it in scriptfiles folder. Whereas MySQL requires use of external plugins and is way faster than SQLite, for it's own reasons. MySQL allows you to show your data on your websites incase if you want to have a UCP or something similar. SQLite also provides this feature but your server and website should be on one machine.

SQLite in my opinion is an overkill for SA-MP. So you should just stick to it if you don't want to go for MySQL.

I've built lots of Call of Duty TDM scripts, some roleplay and I've sticked to SQLite for most of them since they are just enough and you won't need MySQL unless you want your project to be Hi-Fi.

---

EDIT: Quoting ****** from an older post:

"I've said this before. People think that MySQL is some simple plug-and-play magic bullet that you can use to just make your mode instantly better. They don't realise that the "L" in "SQL" means "language". So instead of programming PAWN, and using a bit of this mystery thing, you are now programming in two languages at once. If you spend months learning PAWN, you should spend the same time learning SQL, if not more - it is probably the more complex of the two languages, and not something that just gets bolted on to the side."
Reply


Messages In This Thread
Should I switch to YSI/y_ini? - by andrejc999 - 24.04.2018, 08:53
Re: Should I switch to YSI/y_ini? - by Logic_ - 24.04.2018, 09:01
Re: Should I switch to YSI/y_ini? - by jasperschellekens - 24.04.2018, 09:05
Re: Should I switch to YSI/y_ini? - by andrejc999 - 24.04.2018, 09:07
Re: Should I switch to YSI/y_ini? - by andrejc999 - 24.04.2018, 09:09
Re: Should I switch to YSI/y_ini? - by Logic_ - 24.04.2018, 09:10
Re: Should I switch to YSI/y_ini? - by andrejc999 - 24.04.2018, 09:15
Re: Should I switch to YSI/y_ini? - by Logic_ - 24.04.2018, 09:39
Re: Should I switch to YSI/y_ini? - by andrejc999 - 24.04.2018, 10:53
Re: Should I switch to YSI/y_ini? - by jasperschellekens - 24.04.2018, 11:51

Forum Jump:


Users browsing this thread: 3 Guest(s)