Using a database is a highly talked about subject in regards to muds. Rom is one of the most popular in fact. I wanted to get some more ideas on the subject. Get some pro's and cons together. Afterall, I do have a sourceforge account, with CVS, a modified C++ editor that I released years ago with support for olc and mobprogs so I think that if I can actually grasp this concept, I am one who can release of stock rom with this added sql support for those who have a need for it..
On the last thread alone. DB usage was mentioned various times about how it made certain things easier and for what reasons.. I merely sat down and was really trying to grasp what so many people keep talking about.. >>Didn't you tell us you rewrote ROM in something other than C? How >>much coding was that? Much less than recoding a widows editor for Rom. I also don't know anyone that every actually did a full conversion by hand.. But heh, I get lazy too! There is still a bit to edit afterwards but the blunt can be done with such things as file converters. I mean, C can be converted to C++, java, VB to C/C++, VB to wxwidgets/C++ for X on Linux and so forth. Search engines are an invualable tool for developers.. As is http://www.programmersheaven.com/ >>In the time it took you to do that, you could >>have just as easily ported ROM to use a DB store. One of the many con's of the subject is even with those that I am faced with. While I do have a hefty gaming/personal pc, I don't want the mud on it so instead, I am faced with my mud box being a pc133, 128mb ram and it won't run sql. As would be the case with any mud host.. They don't have Dual Xeon 4GIG mem servers, they use fairly simple computers. And when I looked around for hosting, None of the real mud hosts offer packages nor do they support hosting sql based muds. The cost was 5x times the original amount when I did find one. $100.00 plus monthly for a mud hosting account is just plain silly. You can rent a whole server for that price. >>You are missing the trees for the forest. Well, in regards to the type of applications that you mention, I'd like to see a list of those coded in C.. PHP is moreless the standard language for use on the web as you mention. hotscripts.com shows that php scripts are written now at twice that of Perl, JSP, ASP, ASP.NET and so on.. Sure, there are tons of apps written like shopping carts using backends, But they don't allow access via a c program and sql.. Again, talking about SQL brings up all the topics about C and it short comings, not what is being done in regards to web scripting. >>I specifically mentioned caching in my post, and it's incredibly important. I had no clue that C supported the use of caching and I can't find any reference of C being able to facilitate this. Not even a mention in the mysql c api docs. And I also don't mean the mysql query cache feature as benchmark tests show, thats a powerful system that is done on. Not anything remotely close to what would host a mud. Do you have any info or links related to this? Chris
