2000Q1/
<!-- MHonArc v2.4.4 -->
<!--X-Subject: Re: [MUD&#45;Dev] Databases (was Re: Commercial&#45;use Restrictions on Code Bases) -->
<!--X-From-R13: ptNnzv&#45;pt.UenlEntr.Sqzbagba.OP.QO -->
<!--X-Date: Sun, 16 Jan 2000 10:59:13 &#45;0800 -->
<!--X-Message-Id: 200001161704.KAA13403@ami&#45;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>
[&nbsp;<a href="../">Other Periods</a>
&nbsp;|&nbsp;<a href="../../">Other mailing lists</a>
&nbsp;|&nbsp;<a href="/search.php3">Search</a>
&nbsp;]
<br clear=all><hr>
<!--X-Body-Begin-->
<!--X-User-Header-->
<!--X-User-Header-End-->
<!--X-TopPNI-->

Date:&nbsp;
[&nbsp;<a href="msg00095.html">Previous</a>
&nbsp;|&nbsp;<a href="msg00100.html">Next</a>
&nbsp;]
&nbsp;&nbsp;&nbsp;&nbsp;
Thread:&nbsp;
[&nbsp;<a href="msg00242.html">Previous</a>
&nbsp;|&nbsp;<a href="msg00106.html">Next</a>
&nbsp;]
&nbsp;&nbsp;&nbsp;&nbsp;
Index:&nbsp;
[&nbsp;<A HREF="author.html#00099">Author</A>
&nbsp;|&nbsp;<A HREF="#00099">Date</A>
&nbsp;|&nbsp;<A HREF="thread.html#00099">Thread</A>
&nbsp;]

<!--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:]

&gt; At the risk of being slapped by a mackerel, who here really thinks they
&gt; can do a better database design than those afforded by the likes of the
&gt; free or commercial databases?  [I'll ask those here who've actually
&gt; worked on these databases not to chime in. :)]
&gt;
&gt; It seems to me that segregating the database issues and then simply using
&gt; a database is far better than creating a new one.  This would change
&gt; the "databases/memory management" division above into two divisions -
&gt; database usage, memory management.
&gt;
&gt; 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>&lt;Possible follow-up(s)&gt;<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>&lt;Possible follow-up(s)&gt;<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>
[&nbsp;<a href="../">Other Periods</a>
&nbsp;|&nbsp;<a href="../../">Other mailing lists</a>
&nbsp;|&nbsp;<a href="/search.php3">Search</a>
&nbsp;]
</center>
<hr>
</body>
</html>