As a small project I have been creating a MMO RPG as a small challenge to my self I don't plan on really ever finishing it just as practice going parts.
Anyway I decided for login and stats I would use a SQL database a H2.
I am not liking SQL too much while the options with it seem good its seems to be a pain to do simple little things.
Before this I was just reading from a YML file, but I realized I hate SnakeYML and really hate using it.
So just kinda looking for other suggestions of what to do or maybe a better SQL book/tutorial then what I have been using.
Learning SQL is a bit of an art. I was really bad with it when I first got started, but I've grown much better with time. Realize that SQL is a tool that you use to summon up and organize data. If you're trying to do other stuff with it, then you're probably not using it in the correct situation. If that is what you're trying to do with it, however, then you've got the right language.
It can be a bit weird and also slightly jarring because it's a declarative language. Instead of telling the language how to do something (like in an imperative language), you simply tell it what you want it to produce for you, and it'll figure out the rest on its own.
One question is how much SQL have you done? If you've done a decent bit of it and are comfortable with its syntax and structure but are having a hard time figuring out how to solve problems with it, then the MySQL Cookbook is exactly what you want because that's exactly what it covers. It gives practical examples of situations you might come across and then steps through the solutions.
If you're still learning the syntax (like if you're unsure of how to properly do a join and then are unsure of what results you might get from doing one), then I'm unsure of any good books or tutorials, to be honest. I initially learned it from a college course and then built upon that with self-learning.
I really have done almost none at all read some tutorials on it I can get data and create tables ect.
But I have been messing with OODB and its made a lot more sense.
Player can just be a class with stats and I just create an object of it I already did this already this just makes it easier with the DB.
I will probably go back and learn SQL at some point, but for now I just kinda want to spend more time on the game rather then learning another language to talk to a DB.
Anyway I decided for login and stats I would use a SQL database a H2.
I am not liking SQL too much while the options with it seem good its seems to be a pain to do simple little things.
Before this I was just reading from a YML file, but I realized I hate SnakeYML and really hate using it.
So just kinda looking for other suggestions of what to do or maybe a better SQL book/tutorial then what I have been using.
It can be a bit weird and also slightly jarring because it's a declarative language. Instead of telling the language how to do something (like in an imperative language), you simply tell it what you want it to produce for you, and it'll figure out the rest on its own.
One question is how much SQL have you done? If you've done a decent bit of it and are comfortable with its syntax and structure but are having a hard time figuring out how to solve problems with it, then the MySQL Cookbook is exactly what you want because that's exactly what it covers. It gives practical examples of situations you might come across and then steps through the solutions.
If you're still learning the syntax (like if you're unsure of how to properly do a join and then are unsure of what results you might get from doing one), then I'm unsure of any good books or tutorials, to be honest. I initially learned it from a college course and then built upon that with self-learning.
But I have been messing with OODB and its made a lot more sense.
Player can just be a class with stats and I just create an object of it I already did this already this just makes it easier with the DB.
I will probably go back and learn SQL at some point, but for now I just kinda want to spend more time on the game rather then learning another language to talk to a DB.