Log in

View Full Version : No SQL database?


MortalMan
03-08-2012, 06:58 AM
After downloading the files I notice that this doesn't use a sql database to store player information.

You can't have a fair and fun game with more than just a couple close buddies if important information such as your stats, skills, or even your bottlecaps are stored on the client. One player could very easily use a cheat program to change the value of there skills to maybe 999 so that they one shot every other player in game.

Is some sort of database system planned on being developed in the future? Is this mod supposed to be for just a small intimate group of friends were you don't have to worry about cheaters?
Volumed
03-08-2012, 10:30 AM
I'm sure this will be added in the future.
Mars
03-09-2012, 10:56 PM
SQLite (https://www.sqlite.org/) is quite compact, mature, and public domain, it also gives you the option of in memory or on file space for storing the data base information. It is missing some feature of a full SQL implementation however, mySQL licensing seems a bit iffy (https://en.wikipedia.org/wiki/MySQL) with Oracle running the show and postgress (https://www.postgresql.org/) is enormous. SQLite also allows you to collect objects into a uniform file (IE the tables blobs etc.) which could be useful for distributing 'server' file sets I suppose. I'll go back to lurking. Mars
Volumed
03-10-2012, 12:45 AM
SQLite (https://www.sqlite.org/) is quite compact, mature, and public domain, it also gives you the option of in memory or on file space for storing the data base information. It is missing some feature of a full SQL implementation however, mySQL licensing seems a bit iffy (https://en.wikipedia.org/wiki/MySQL) with Oracle running the show and postgress (https://www.postgresql.org/) is enormous. SQLite also allows you to collect objects into a uniform file (IE the tables blobs etc.) which could be useful for distributing 'server' file sets I suppose. I'll go back to lurking. Mars

Hello Mars,

I don't want to insult you or something i believe you are smart guy and i think you know where you are talking about. But i believe that Recycler knows how SQL works and where to find the right tools. And something else MySQL is made for web base.

Mars i don't know you, but is this the first time you join a forum? Because you are not doing it right.. MortalMan made a topic for "hes" question nobody ask for this. If you got suggestions in the development send a message directly to Recycler.

I hope you understand it.
MortalMan
03-10-2012, 05:03 AM
Hello Mars,

I don't want to insult you or something i believe you are smart guy and i think you know where you are talking about. But i believe that Recycler knows how SQL works and where to find the right tools. And something else MySQL is made for web base.

Mars i don't know you, but is this the first time you join a forum? Because you are not doing it right.. MortalMan made a topic for "hes" question nobody ask for this. If you got suggestions in the development send a message directly to Recycler.

I hope you understand it.

Mysql is also used very successfully in many emulated MMO servers. I know of a lineage 2 emu server running sql databases with more than 6,000 concurrent players. It's possible that there are better database systems out there, but sql is certainly capable.
CTCCoco
03-10-2012, 09:55 AM
MySQL is used for many purposes, not only web based. I'm sure it will be implemented to VaultMP, without any doubt, and it's more efficient than SQLLite, which is flat file.
Volumed
03-10-2012, 11:59 AM
Ok Sorry mostly used for web base, But i'm not sure if it's the best choose.
And look what i said: "I'm sure this will be added in the future."
crapvile
03-10-2012, 01:04 PM
Hello Mars,

I don't want to insult you or something i believe you are smart guy and i think you know where you are talking about. But i believe that Recycler knows how SQL works and where to find the right tools. And something else MySQL is made for web base.

Mars i don't know you, but is this the first time you join a forum? Because you are not doing it right.. MortalMan made a topic for "hes" question nobody ask for this. If you got suggestions in the development send a message directly to Recycler.

I hope you understand it.
Hahahahaha