Data storage, logging and some other thoughts...

Hello,
I've been thinking about this for a while. I'm a web developer and incredibly like plugins, that support MySQL. That is because I can easily query the Database and write my own Statistics scripts. But for now I have Plugins that support SQL and some that don't. Now I have the Problem, that I have to configure every plugin for use with SQL. I have to supply a database name, a user name and a password in every single config. And even worse: some don't support prefixes for tables.
Now I thought, what if we had a plugin that handles all that storage stuff. You configure it to use SQL, every plugin sends their requests to the SQL database. You configure it to use flat files, the requests are send to flat files. In addition, table prefixes would be nice.

Another thought I had for while is logging. There is this huge server.log that contains all logging on the server. Maybe there is a way to categorize these logs. To tag every line regarding their importance and the plugin that produces it. Troubleshooting will be significantly easier. With this step, there could be plugins, that send you emails or instant messages regarding certain events, like players disobeying world guard or griefing.

So, just a few thoughts worth to discuss.

Regards
Default112

 

Something like this?

http://forums.bukkit.org/threads/admin-customlog-0-20-create-customized-log-file-935.10164/

Splits the log files. But yea, i agree. A centralized plugin for this would be great. There currently isn't a logging plugin which does it all :O

This one is x-ray specific:

http://dev.bukkit.org/server-mods/logores/

So yea i agree, we need a plugin which logs things easily. And it would be even more epic if you could have like a webpage front end with a user login. That way you could give your moderators access to reviewing the log files. Would make life so much easier.

So yea.. Just my 2 cents. I myself don't have the knowledge yet to make something like this. If I had i'd do it.

 

As a web developer - you know PHP can parse flatfiles just as easily?

For small data storage flatfiles are far superior to anything else.

 

@codename_B Yes, I know. But it's kind of convenient having all data right at "my hand" without parsing flatfiles. And the idea is to have a centralized plugin which takes over the whole storage thingy, so that a developer does not have to worry abaout sql, sqllite or flatfiles.

@sukosevato Oh, must have missed that one... At first glance this does not log all events. But I will take a look

regards