MySQL Support

[SugarD-x]

I'm just a bit curious as to why this hasn't been done yet, but what about adding MySQL database support as a second option for storing data? Theoretically it would actually be much faster than plain file storage, and would be a lot more secure. It could also enable many other features for communities that are interested in expanding upon this.

If this isn't easily possible, or not something you're interesting in adding right now, what about making plugins possible with FSHost, or even open-sourcing the project so others can also enjoy your wonderful work?

[Russell Gilbert]

Hi,

MySQL support is something that's been on the wish list for a long time, but I think you're maybe only the second person in all these years to ask for it.  It's definitely possible, but not trivial to add.  I use MySQL a lot though, and I like the idea in general.  Can you tell me more about how you envision the feature working?

Thanks,
Russell

[SugarD-x]

Hi,

MySQL support is something that's been on the wish list for a long time, but I think you're maybe only the second person in all these years to ask for it.  It's definitely possible, but not trivial to add.  I use MySQL a lot though, and I like the idea in general.  Can you tell me more about how you envision the feature working?

Thanks,
Russell

Well, aside from some obvious, largely argued reasons, I actually play and develop in a large gaming community which hosts many multiplayer game modification servers, your's included, and we're developing a way to link specific information across these servers with a unified system for various purposes. One thing holding back the FSHost server from being used in this system, though, is a fast and secure method to link it to our centralized MySQL database. Having support for the MySQL database itself would open up many opportunities for this system we are developing, and I'm sure overall that server hosters of this mod themselves would also appreciate the option of using this database storage method.

As for the feature overall, I assume it would just be the basic "databased" information that is currently stored in other methods being output to the MySQL database, should that option be selected for use. It wouldn't be a major change in the most simplistic sense of it's implementation other than how information gets stored. I'm sure others could build on top of the idea, though. Hell, server hosters could even theoretically make stats websites via linking to the MySQL database information, and integrate it into their own sites directly. The possibilities with every feature you add to this fun mod are endless!

Edit: Seems you were right about others requesting it too! To-do list, huh?
http://www.chocolatesoftware.com/forum/index.php?topic=323

[Air SeaTac]

I can see it being useful if pilot logs were recorded in a MySQL database, especially if a VA wanted to check that a logged flight was 'legitimate' in that slew or rate acceleration modes hadn't been used.

Would be easier to query a database rather than try to parse a pilot log for the relevant information.

[SugarD-x]

I can see it being useful if pilot logs were recorded in a MySQL database, especially if a VA wanted to check that a logged flight was 'legitimate' in that slew or rate acceleration modes hadn't been used.

Would be easier to query a database rather than try to parse a pilot log for the relevant information.

Exactly! There's another use for it.

One of the personal features I think it would be nice for it is storing ban information along with those pilot logs, (as well as the other "databased" stuff that FSHost already records). It would also be much faster for FSHost to save and retrieve than a file-based system if the server is very popular and active, which normally would strain it if a lot of people were constantly joining and it had to retrieve information often, so this works as a stability option too.

[SugarD-x]

Sorry to bump this, but did I provide you the information you were looking for Russell?

[Russell Gilbert]

Hi,

Yep, all good info, thanks.  I'll give it some thought and maybe it'll make it into a future version.  Sorry, I don't have any time estimate at the moment.

Thanks,
Russell

[SugarD-x]

Hi,

Yep, all good info, thanks.  I'll give it some thought and maybe it'll make it into a future version.  Sorry, I don't have any time estimate at the moment.

Thanks,
Russell

Not a problem. Thanks for the response and consideration!