people use MYSQL for the fact its easy to hook up to there forums so on
|
I am very new to SQL and am wondering which SQL is best fit for rsps.
Everyone here seems to use MySql, but I know there are others like SQLite, etc.
Are there any specific pros/cons you can think of between the different ones?
I'd like to store most of my data in a SQL database, including NPC spawns, player data, and objects.
Again, I really don't know much about SQL besides what it's for etc, but I would really like to learn.
people use MYSQL for the fact its easy to hook up to there forums so on
MySQL is for online use - its possible to connect to it from outside, if you give a username/password. That's why its used for highscores, connecting servers with forums, etc. Because of that, it's more flexible, but also more difficult to set up properly.
SQLite seems to be more of a back-end engine - SQLite is embedded/linked directly to your program at the compiling stage - no requirement for seperate connecting pieces. That makes it easier to configure, since there is no need for setting ports, security settings, etc. However, that also means you cannot connect to it from the outside, so it's strictly local.
Both are SQL, however, so the matter is : do you want a flexible online database (MySQL), or a easy-to-install local one (SQLite)
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |