This. MySQL is a far better performer than reading flat files. Any plugin that supports it should be using it. Plus, having your data in MySQL means accessing the data from third party apps is easy too. For example, I'd must rather just do a "SELECT id FROM region" to get a list of WorldGuard regions rather than have to parse a YML file.
This. MySQL is a far better performer than reading flat files. Any plugin that supports it should be using it. Plus, having your data in MySQL means accessing the data from third party apps is easy too. For example, I'd must rather just do a "SELECT id FROM region" to get a list of WorldGuard regions rather than have to parse a YML file.
Just to throw around "This" again. SQL is made for exactly the function you are talking about, storing and transferring information. A flatfile should really only be used in the case of reading configuration or possibly storing a more or less permanent value. Things with common entries or frequent savings should be handled by a data manager made for this.
Everything for the reasons above (performance mainly).
More importantly MySQL can be accessed very easily, if for example you want to have a list of groups made on your server (via a MySQL supporting plugin) on your website you can simply write a PHP script to fetch the data and show it (which would be a very basic PHP script). MySQL is a million times faster, especially if you run it all in RAM.
Rollback Post to RevisionRollBack
"Terminator like robots may one day rule the world, as long as they don't run Windows Vista"
Everything for the reasons above (performance mainly).
More importantly MySQL can be accessed very easily, if for example you want to have a list of groups made on your server (via a MySQL supporting plugin) on your website you can simply write a PHP script to fetch the data and show it (which would be a very basic PHP script). MySQL is a million times faster, especially if you run it all in RAM.
What are the alternatives to RAM? Last time I checked there were none.
What are the alternatives to RAM? Last time I checked there were none.
I would venture a guess that mayhap he means using the FRM/MYD/MYI on a RAM drive rather than a disc? *shrug* Faster access for sure, but I don't think I'd trust that heh.
How would I go about making bukkits MYSQL compatible? I put in all my info and I don't know what to do with drivers....
For each plugin that supports MySQL you just need to edit the configuration to tell it the server address, username and password. Some plugins will also need you to give a table prefix or other data. You may also have to set some sort of flag letting it know you want to use SQL, like in PEX it's "backend: sql" or some such.
Mcmmo?
Essentials?
I have over 2,000 users in my server and I think the enormous list might be bugging me down.
Anyways that wasnt my question.
What do you use MYSQL with??
-
View User Profile
-
View Posts
-
Send Message
Retired Staff-
View User Profile
-
View Posts
-
Send Message
Curse PremiumExperience: Op in #McMyAdmin, Plugin Developer, <codename> Dev.
-
View User Profile
-
View Posts
-
Send Message
Curse PremiumThis. MySQL is a far better performer than reading flat files. Any plugin that supports it should be using it. Plus, having your data in MySQL means accessing the data from third party apps is easy too. For example, I'd must rather just do a "SELECT id FROM region" to get a list of WorldGuard regions rather than have to parse a YML file.
-
View User Profile
-
View Posts
-
Send Message
Retired StaffJust to throw around "This" again. SQL is made for exactly the function you are talking about, storing and transferring information. A flatfile should really only be used in the case of reading configuration or possibly storing a more or less permanent value. Things with common entries or frequent savings should be handled by a data manager made for this.
Keep looking but cant find it.
-
View User Profile
-
View Posts
-
Send Message
Curse PremiumIf it hasn't got it listed on the factions page, no.
-
View User Profile
-
View Posts
-
Send Message
Forum AdminNo, it does not.
More importantly MySQL can be accessed very easily, if for example you want to have a list of groups made on your server (via a MySQL supporting plugin) on your website you can simply write a PHP script to fetch the data and show it (which would be a very basic PHP script). MySQL is a million times faster, especially if you run it all in RAM.
-
View User Profile
-
View Posts
-
Send Message
Curse PremiumWhat are the alternatives to RAM? Last time I checked there were none.
How would I go about making bukkits MYSQL compatible? I put in all my info and I don't know what to do with drivers....
-
View User Profile
-
View Posts
-
Send Message
Curse PremiumI would venture a guess that mayhap he means using the FRM/MYD/MYI on a RAM drive rather than a disc? *shrug* Faster access for sure, but I don't think I'd trust that heh.
For each plugin that supports MySQL you just need to edit the configuration to tell it the server address, username and password. Some plugins will also need you to give a table prefix or other data. You may also have to set some sort of flag letting it know you want to use SQL, like in PEX it's "backend: sql" or some such.