10.05.2013, 20:08
I really don't understand why people only talk about MySQL?
MySQL is NOT SOMETHING that a beginner file-writer should start with!
You don't even NEED MySQL for SA-MP, I find it way stupid that people prefer MySQL over EVERYTHING.
MySQL is a database system made for HEAVY business management. And trust me, I only see supermarket's or huge corporate companies using MySQL for data storage.
Reasons why I hate MySQL -
Complex
Hard to set up
Takes up too much space (You need to install some database manager like XAMP or WAMP before you can start using MySQL)
Then what to use? SQLite is the answer.
SQLite is INBUILT in SA-MP, and is MUCH easier to manage.
No plugin, no password or etc. Just PLUG-N-PLAY!
You just need a 6MB SQLite database manager which can be downloaded from anywhere.
Why SQLite?
Easier to set up
Does not consume much space
Easier to manage
Probably one of the FASTEST system's out there (MySQL and SQLite run closely same, except I prefer to believe that SQLite is faster as it doesn't require plugins, and doesn't use stuff like WAMP or XAMP, and the language is much easier to manage, even though it doesn't offer the same features)
Less features, mainly aimed at what we're really going to be using (MySQL has stuff you'll NEVER EVER need if you're going to be creating simple gamemode's)
Easier to debug and fix (I've had problems mainly setting up the database itself, so I never actually properly used MySQL)
MySQL - something I'd prefer for bad-ass management with heavy protection and etc.
SQLite - something for general SA-MP coding or game coding.
You're not going to be managing millions/billions of user accounts at the same time. SA-MP has a number of maximum slots as 1000 (500 in other cases), so why use MySQL?
And just in case you want simpler file systems, go for Y_INI or SII, since you're not going to be around with it so long, efficiency doesn't matter as long as you don't plan to stick to that shit.
MySQL is NOT SOMETHING that a beginner file-writer should start with!
You don't even NEED MySQL for SA-MP, I find it way stupid that people prefer MySQL over EVERYTHING.
MySQL is a database system made for HEAVY business management. And trust me, I only see supermarket's or huge corporate companies using MySQL for data storage.
Reasons why I hate MySQL -
Complex
Hard to set up
Takes up too much space (You need to install some database manager like XAMP or WAMP before you can start using MySQL)
Then what to use? SQLite is the answer.
SQLite is INBUILT in SA-MP, and is MUCH easier to manage.
No plugin, no password or etc. Just PLUG-N-PLAY!
You just need a 6MB SQLite database manager which can be downloaded from anywhere.
Why SQLite?
Easier to set up
Does not consume much space
Easier to manage
Probably one of the FASTEST system's out there (MySQL and SQLite run closely same, except I prefer to believe that SQLite is faster as it doesn't require plugins, and doesn't use stuff like WAMP or XAMP, and the language is much easier to manage, even though it doesn't offer the same features)
Less features, mainly aimed at what we're really going to be using (MySQL has stuff you'll NEVER EVER need if you're going to be creating simple gamemode's)
Easier to debug and fix (I've had problems mainly setting up the database itself, so I never actually properly used MySQL)
MySQL - something I'd prefer for bad-ass management with heavy protection and etc.
SQLite - something for general SA-MP coding or game coding.
You're not going to be managing millions/billions of user accounts at the same time. SA-MP has a number of maximum slots as 1000 (500 in other cases), so why use MySQL?
And just in case you want simpler file systems, go for Y_INI or SII, since you're not going to be around with it so long, efficiency doesn't matter as long as you don't plan to stick to that shit.