Top Mud Sites Forum - View Single Post - MySQL for CircleMUD Player Saves: Thoughts?

plamzi · 10-22-2010, 01:50 AM

Just wanted to report back in case someone else decides to go down a similar path. It was long and tedious, and full of all-night tweakery, but now we have a CircleMUD with no real bottlenecks when it comes to permanent storage and things are looking up!

Because all player files are in SQL, I can add a new player property in minutes without having to rebuild or upgrade existing player saves. Grabbing data easily in the order and under the criteria you want and modifying only the property that needs changing (without having to rewrite the whole file) are some of the other highlights of this brave new world.

Also, the same SQL database now drives a quest-building web browser wizard which is hooked back into the MUD. The goal is to allow players to submit quest ideas online and also to kick off their own quests for other players if they provide a reward. The questbuilder website "pushes" events to the MUD code via the database, which acts like a bridge.

I'm really liking all the possibilities...

10-22-2010, 01:50 AM	#5
plamzi Senior Member Join Date: Nov 2009 Home MUD: bedlam.mudportal.com:9000 Home MUD: www.mudportal.com Posts: 292	Re: MySQL for CircleMUD Player Saves: Thoughts? Just wanted to report back in case someone else decides to go down a similar path. It was long and tedious, and full of all-night tweakery, but now we have a CircleMUD with no real bottlenecks when it comes to permanent storage and things are looking up! Because all player files are in SQL, I can add a new player property in minutes without having to rebuild or upgrade existing player saves. Grabbing data easily in the order and under the criteria you want and modifying only the property that needs changing (without having to rewrite the whole file) are some of the other highlights of this brave new world. Also, the same SQL database now drives a quest-building web browser wizard which is hooked back into the MUD. The goal is to allow players to submit quest ideas online and also to kick off their own quests for other players if they provide a reward. The questbuilder website "pushes" events to the MUD code via the database, which acts like a bridge. I'm really liking all the possibilities...