<!-- MHonArc v2.4.4 --> <!--X-Subject: Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases) --> <!--X-From-R13: ptNnzv-pt.UenlEntr.Sqzbagba.OP.QO --> <!--X-Date: Sun, 16 Jan 2000 10:59:13 -0800 --> <!--X-Message-Id: 200001161704.KAA13403@ami-cg.GraySage.Edmonton.AB.CA --> <!--X-Content-Type: text/plain --> <!--X-Head-End--> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html> <head> <title>MUD-Dev message, Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions o</title> <!-- meta name="robots" content="noindex,nofollow" --> <link rev="made" href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA"> </head> <body background="/backgrounds/paperback.gif" bgcolor="#ffffff" text="#000000" link="#0000FF" alink="#FF0000" vlink="#006000"> <font size="+4" color="#804040"> <strong><em>MUD-Dev<br>mailing list archive</em></strong> </font> <br> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] <br clear=all><hr> <!--X-Body-Begin--> <!--X-User-Header--> <!--X-User-Header-End--> <!--X-TopPNI--> Date: [ <a href="msg00095.html">Previous</a> | <a href="msg00100.html">Next</a> ] Thread: [ <a href="msg00242.html">Previous</a> | <a href="msg00106.html">Next</a> ] Index: [ <A HREF="author.html#00099">Author</A> | <A HREF="#00099">Date</A> | <A HREF="thread.html#00099">Thread</A> ] <!--X-TopPNI-End--> <!--X-MsgBody--> <!--X-Subject-Header-Begin--> <H1>Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</H1> <HR> <!--X-Subject-Header-End--> <!--X-Head-of-Message--> <UL> <LI><em>To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#kanga,nu</A></LI> <LI><em>Subject</em>: Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</LI> <LI><em>From</em>: <A HREF="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</A></LI> <LI><em>Date</em>: Sun, 16 Jan 2000 10:04:48 -0700</LI> <LI><em>Reply-To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#kanga,nu</A></LI> <LI><em>Sender</em>: <A HREF="mailto:mud-dev-admin#kanga,nu">mud-dev-admin#kanga,nu</A></LI> </UL> <!--X-Head-of-Message-End--> <!--X-Head-Body-Sep-Begin--> <HR> <!--X-Head-Body-Sep-End--> <!--X-Body-of-Message--> <PRE> [Charles Hughes:] > At the risk of being slapped by a mackerel, who here really thinks they > can do a better database design than those afforded by the likes of the > free or commercial databases? [I'll ask those here who've actually > worked on these databases not to chime in. :)] > > It seems to me that segregating the database issues and then simply using > a database is far better than creating a new one. This would change > the "databases/memory management" division above into two divisions - > database usage, memory management. > > Yes? No? You are ignoring the issue of the appropriateness of commerical or other standard databases. Calling the persistence back-end of MUD system its "database" is handy, in that it describes it in one word that has a lot of the right meaning. That does not mean, however, that the way that backend works is anything like the ways a normal database works. This was discussed not that long ago, I believe. The inappropriateness of standard databases is one reason many MUD authors create their own. For example, my "database" has no concept of "tables" or "rows". It simply associates a hunk of saved data with a key, and provides automatic means for saving/restoring such data, and provides an efficient caching mechanism for the hunks of saved data. Some of the hunks are strings, some are arrays of integers, some are compessed hash tables, etc. They vary wildly in length and in internal structure. I have no idea how to use a standard database to store such things anywhere near as efficiently as my custom "database" does. From the other direction, the nice indexing and searching facilities of normal databases are of very little use to my MUD system. There has been discussion of using normal databases as MUD backends, but, to me, it seems a lot like working very hard to use a hammer and pliers to work with screws. -- Don't design inefficiency in - it'll happen in the implementation. Chris Gray cg#ami-cg,GraySage.Edmonton.AB.CA <A HREF="http://www.GraySage.Edmonton.AB.CA/cg/">http://www.GraySage.Edmonton.AB.CA/cg/</A> _______________________________________________ MUD-Dev maillist - MUD-Dev#kanga,nu <A HREF="http://www.kanga.nu/lists/listinfo/mud-dev">http://www.kanga.nu/lists/listinfo/mud-dev</A> </PRE> <!--X-Body-of-Message-End--> <!--X-MsgBody-End--> <!--X-Follow-Ups--> <HR> <!--X-Follow-Ups-End--> <!--X-References--> <!--X-References-End--> <!--X-BotPNI--> <UL> <LI>Prev by Date: <STRONG><A HREF="msg00095.html">Re: player politics (was RE: [MUD-Dev] An introduction...)</A></STRONG> </LI> <LI>Next by Date: <STRONG><A HREF="msg00100.html">[MUD-Dev] Re: Databases</A></STRONG> </LI> <LI>Prev by thread: <STRONG><A HREF="msg00242.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></STRONG> </LI> <LI>Next by thread: <STRONG><A HREF="msg00106.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></STRONG> </LI> <LI>Index(es): <UL> <LI><A HREF="index.html#00099"><STRONG>Date</STRONG></A></LI> <LI><A HREF="thread.html#00099"><STRONG>Thread</STRONG></A></LI> </UL> </LI> </UL> <!--X-BotPNI-End--> <!--X-User-Footer--> <!--X-User-Footer-End--> <ul><li>Thread context: <BLOCKQUOTE><UL> <LI><STRONG>Re: [MUD-Dev] Re: Databases</STRONG>, <EM>(continued)</EM> <ul compact> <ul compact> <ul compact> <ul compact> <LI><strong><A NAME="00115" HREF="msg00115.html">Re: [MUD-Dev] Re: Databases</A></strong>, Kevin Littlejohn <a href="mailto:darius#connect,com.au">darius#connect,com.au</a>, Tue 18 Jan 2000, 07:01 GMT <UL> <LI><strong><A NAME="00245" HREF="msg00245.html">Re: [MUD-Dev] Re: Databases</A></strong>, J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sun 30 Jan 2000, 21:45 GMT </LI> </UL> </LI> </ul> </ul> </ul> </ul> </LI> <LI><strong><A NAME="00096" HREF="msg00096.html">[MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>, Charles Hughes <a href="mailto:charles.hughes#bigfoot,com">charles.hughes#bigfoot,com</a>, Sun 16 Jan 2000, 01:56 GMT <UL> <LI><strong><A NAME="00242" HREF="msg00242.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>, J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sun 30 Jan 2000, 21:21 GMT </LI> </UL> <UL> <li><Possible follow-up(s)><br> <LI><strong><A NAME="00099" HREF="msg00099.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>, cg <a href="mailto:cg#ami-cg,GraySage.Edmonton.AB.CA">cg#ami-cg,GraySage.Edmonton.AB.CA</a>, Sun 16 Jan 2000, 18:59 GMT </LI> <LI><strong><A NAME="00106" HREF="msg00106.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>, Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Mon 17 Jan 2000, 19:52 GMT </LI> <LI><strong><A NAME="00109" HREF="msg00109.html">Re: [MUD-Dev] Databases (was Re: Commercial-use Restrictions on Code Bases)</A></strong>, Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Mon 17 Jan 2000, 22:02 GMT </LI> </UL> </LI> <LI><strong><A NAME="00089" HREF="msg00089.html">[MUD-Dev] Re: Commercial-use Restrictions on Code Bases (was: help me find 100% fre (fwd)</A></strong>, J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sat 15 Jan 2000, 04:29 GMT <UL> <li><Possible follow-up(s)><br> <LI><strong><A NAME="00090" HREF="msg00090.html">[MUD-Dev] Re: Commercial-use Restrictions on Code Bases (was: help me find 100% fre (fwd)</A></strong>, J C Lawrence <a href="mailto:claw#kanga,nu">claw#kanga,nu</a>, Sat 15 Jan 2000, 04:31 GMT </LI> </UL> </LI> </UL></BLOCKQUOTE> </ul> <hr> <center> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] </center> <hr> </body> </html>