[Giovanni]

Ok, so I have been using Dini for so long now. And I wanna switch the ways of saving data now.



So I heard that MySQL is not really senseful for SA:MP communities and that SQLite is like one of the best ways. But I don't really understand it, although I read some tutorials already, but most of them need a special include and I really don't want that.


My other option would be just switching to a better file system. I tried out y_INI but it is so much different from dini (and yes, that is a problem for me). Then I heard about SII but somewhere I also heard that the speedtests, shown in the release topic are not really accurate/are wrong anyway. So I am unsure with it.

My questions are:

• Is there any file system, where the functions are similar to the ones of dini, but which is also pretty fast?
• (Optional) Can somebody explain me how I would do a basic register system with SQLite?* (Without using any includes)

* I have read a lot of tutorials about SQLite already but they either use an include (and I really don't want that) or leave some parts out that are important for me.



Thanks for reading.

[Kush]

Quote:

Originally Posted by Giovanni So I heard that MySQL is not really senseful for SA:MP communities and that SQLite is like one of the best ways. But I don't really understand it, although I read some tutorials already, but most of them need a special include and I really don't want that.Thanks for reading.

Firstly, don't believe all what you hear. Lots of people in the community post incorrect information, nor do they even take in the simple fact of proven tests. MySQL offers much more features, so saying it is not 'senseful' or if I did interpret what that means correctly, then that is plain false.

Quote:

Originally Posted by Giovanni My other option would be just switching to a better file system. I tried out y_INI but it is so much different from dini (and yes, that is a problem for me). Then I heard about SII but somewhere I also heard that the speedtests, shown in the release topic are not really accurate/are wrong anyway. So I am unsure with it.

https://sampforum.blast.hk/showthread.php?tid=273088
https://sampforum.blast.hk/showthread.php?tid=267808

[Giovanni]

Quote:

Originally Posted by Kush Firstly, don't believe all what you hear. Lots of people in the community post incorrect information, nor do they even take in the simple fact of proven tests. MySQL offers much more features, so saying it is not 'senseful' or if I did interpret what that means correctly, then that is plain false.

I do not believe everything people post in here, don't worry. But a lot of members have talked out of own experience. They did develope gamemodes using MySQL and did not really see it as the best choice after it. So I think that I can trust in their words.


Anyway, thanks for the links to your tutorials. I am going to check them out later.

[Kyosaur]

MySQL is completely "senseful" for SA-MP. Its faster than sqlite naturally (a HELL of a lot faster if you dont use a special PRAGMA line), and offers threading. It's the better choice out of the two for this reason alone. There of course are other arguments, but i think this is reason enough to pick it over SQLite.