• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Server] system for storing player data
#1
i'm looking one system for stroring player data and i found the SQLite and MySQL. The both system are different each other? Or they are the same thing? What system is the for the Data Base? Thx
  Reply
#2
Although I have no experience with MySQL or SQLite I believe they are different from eachother.



If you have limited Pawn experience and Pawn is your first language which seems to be the case, I would recommend not trying to use any SQL dialect(?) as the 'L' stands for language.



There are plenty of file systems that deal with the server's local scriptfiles as opposed to an external database. I'm not sure what the new kids use, but y_less' y_ini in the YSI library has plenty of advantages to make file handling at runtime pretty close to optimal.



Even Pawn's fopen() and fclose() functions would serve you better at this stage then picking up an entirely new quarry language would while you're learning the basics of software development in general.



From web to mobile to desktop applications, written in many languages from?C to Markdown and?yet still I have mostly only seen SQL use in very few places. If we're connecting to a server, unless you're expecting many tens of thousands of players or more, then the benefit from using an external database is neglegable at best. if we're peer-to-peer then GG; save it on the local machine. BTW I'm not saying SQL doesn't have it's place, but don't commit to something you will never use when the time could be better spent on the path you want to take and not getting confusred in the first place.
  Reply


Forum Jump: