12.04.2018, 10:09
I know you have a background but to put it simply
DINI or any INI file saving system would be as much as efficient as SQL both SQLite and MySQL, both systems would be fast and both systems would be doing the job you wish it to do, if you know what you want and if you know how to manipulate the data properly. Both would do the same nonetheless..
now to explain advantages and disadvantages
DINI or any INI file saving system
Advantage
- Easy to setup
- Knowledge of path and system should be easy to understand
Disadvantage
- Redundancy
- File Errors
- Prone to Corruption
SQL systems
Advantage
- Less Redundancy
- Corruption is a bit less frequent
- And easy to handle
Disadvantage
- Needs a lot of time to understand and learn, the basic and the advance
(If you only use the basic type of using database system then I recommend you do the File System based, or INI based system since database system in basic form would do you more harm than good.)
- Needs a lot of time to setup and completely and correctly finish it without doing more harm to your system
(In other words testing is a must, although both does the same but MySQL has much more functions and things to adjust for you to make it work as much as fast and as harmless to the easy setup INI files)
All in all both systems would do the same nonetheless as long as you know how to manipulate your data to be safe for use, although MySQL has the edge on this, by a mile, knowledge on how to use MySQL is far more diverse than just saving and updating and making it to a perfect system, unlike INI files which is a much less hassle.(This is On My Opinion, although I prefer MySQL than File System, and had gradually learned through most advanced things that can be used to call the system safe than harmful)
A best bet on advice would be try to learn the curve on File System, it will gradually give you a big edge on how fast you would be able to learn MySQL. Without the syntax and function calls both would just be the same on most parts, other than the part where you try to make your system as redundant free as it should be...
DINI or any INI file saving system would be as much as efficient as SQL both SQLite and MySQL, both systems would be fast and both systems would be doing the job you wish it to do, if you know what you want and if you know how to manipulate the data properly. Both would do the same nonetheless..
now to explain advantages and disadvantages
DINI or any INI file saving system
Advantage
- Easy to setup
- Knowledge of path and system should be easy to understand
Disadvantage
- Redundancy
- File Errors
- Prone to Corruption
SQL systems
Advantage
- Less Redundancy
- Corruption is a bit less frequent
- And easy to handle
Disadvantage
- Needs a lot of time to understand and learn, the basic and the advance
(If you only use the basic type of using database system then I recommend you do the File System based, or INI based system since database system in basic form would do you more harm than good.)
- Needs a lot of time to setup and completely and correctly finish it without doing more harm to your system
(In other words testing is a must, although both does the same but MySQL has much more functions and things to adjust for you to make it work as much as fast and as harmless to the easy setup INI files)
All in all both systems would do the same nonetheless as long as you know how to manipulate your data to be safe for use, although MySQL has the edge on this, by a mile, knowledge on how to use MySQL is far more diverse than just saving and updating and making it to a perfect system, unlike INI files which is a much less hassle.(This is On My Opinion, although I prefer MySQL than File System, and had gradually learned through most advanced things that can be used to call the system safe than harmful)
A best bet on advice would be try to learn the curve on File System, it will gradually give you a big edge on how fast you would be able to learn MySQL. Without the syntax and function calls both would just be the same on most parts, other than the part where you try to make your system as redundant free as it should be...