<!-- MHonArc v2.4.4 -->
<!--X-Subject: [MUD-Dev] Re: Databases: was Re: skill system -->
<!--X-From-R13: "Oqnz X. Fubeagba" <nqnzNcubravk.Bevaprgba.SRG> -->
<!--X-Date: Sat, 20 Jun 1998 06:41:55 -0700 -->
<!--X-Message-Id: 19980620093733.B14214#tucson,Princeton.EDU -->
<!--X-Content-Type: text/plain -->
<!--X-Reference: 199806112143.OAA07401#beldin,snugharbor.com -->
<!--X-Reference: Pine.PMDF.3.95.980616103648.541114410A-100000#nova,wright.edu -->
<!--X-Reference: 199806200815.DAA06995@dfw-ix12.ix.netcom.com -->
<!--X-Head-End-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<title>MUD-Dev message, [MUD-Dev] Re: Databases: was Re: skill system</title>
<!-- meta name="robots" content="noindex,nofollow" -->
<link rev="made" href="mailto:adam#phoenix,Princeton.EDU">
</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="msg01152.html">Previous</a>
| <a href="msg01154.html">Next</a>
]
Thread:
[ <a href="msg01152.html">Previous</a>
| <a href="msg01200.html">Next</a>
]
Index:
[ <A HREF="author.html#01153">Author</A>
| <A HREF="#01153">Date</A>
| <A HREF="thread.html#01153">Thread</A>
]
<!--X-TopPNI-End-->
<!--X-MsgBody-->
<!--X-Subject-Header-Begin-->
<H1>[MUD-Dev] Re: Databases: was Re: skill system</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>: [MUD-Dev] Re: Databases: was Re: skill system</LI>
<LI><em>From</em>: "Adam J. Thornton" <<A HREF="mailto:adam#phoenix,Princeton.EDU">adam#phoenix,Princeton.EDU</A>></LI>
<LI><em>Date</em>: Sat, 20 Jun 1998 09:37:33 -0400</LI>
<LI><em>Reply-To</em>: <A HREF="mailto:mud-dev#kanga,nu">mud-dev#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>
On Sat, Jun 20, 1998 at 04:17:25AM +0000, Jon A. Lambert wrote:
> An OO DB might be more attractive than an RDB. Since a whole host
> of OO comes for free. Yet your mud programming language's particular
> implementation of OO might have to match or be translated to a form
> recognizable by the OO DB.
I'm using PostgreSQL in the project I'm working on. I have no idea whether
the speed will eventually be acceptable or not, yet.
My objects are runtime-static in the sense that new object properties and
methods will not be created on the fly.
Postgres works rather nicely for this since you can define tables/classes
in an inheritance relationship, so that class Item can inherit Object but
add the properties Legal_Owner, Parent_Object, and Container_Relationship,
for instance. Then items with weight and bulk can inherit item and add
weight and bulk properties. You can do multiple inheritance, too, so I can
have an item class that inherits both Bulky_Item and Container, to get,
say, an orange crate. Or those two plus Lockable for a chest.
Clearly database manipulation gets very time-expensive. My strategy,
although it's not completely thought through yet is to maintain much of the
world state in in-memory data structures and only commit it to the DB when
a) there's a lull and my system load is low enough that I can do so
without fear of vastly slowing down things, or b) when something that it's
crucial that the rest of the world know about happens (figuring out the
criteria for this is the tricky part), or c) when a timeout happens such
that the DB hasn't been written in X seconds, so that I don't end up with
an impossibly huge transaction queue.
This is all still very nascent, so it's all subject to change a lot.
Adam
--
adam#princeton,edu
"There's a border to somewhere waiting, and a tank full of time." - J. Steinman
</PRE>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<HR>
<ul compact><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><A NAME="01200" HREF="msg01200.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>
<ul compact><li><em>From:</em> "Jon A. Lambert" <jlsysinc#ix,netcom.com></li></ul>
</UL></LI></UL>
<!--X-Follow-Ups-End-->
<!--X-References-->
<UL><LI><STRONG>References</STRONG>:
<UL>
<LI><STRONG><A NAME="00978" HREF="msg00978.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
<UL><LI><EM>From:</EM> "T. Alexander Popiel" <popiel#beldin,snugharbor.com></LI></UL></LI>
<LI><STRONG><A NAME="01070" HREF="msg01070.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
<UL><LI><EM>From:</EM> s001gmu#nova,wright.edu</LI></UL></LI>
<LI><STRONG><A NAME="01152" HREF="msg01152.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
<UL><LI><EM>From:</EM> "Jon A. Lambert" <jlsysinc#ix,netcom.com></LI></UL></LI>
</UL></LI></UL>
<!--X-References-End-->
<!--X-BotPNI-->
<UL>
<LI>Prev by Date:
<STRONG><A HREF="msg01152.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Next by Date:
<STRONG><A HREF="msg01154.html">[MUD-Dev] Re: Analysis and specification - the dirty words of mud development?</A></STRONG>
</LI>
<LI>Prev by thread:
<STRONG><A HREF="msg01152.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Next by thread:
<STRONG><A HREF="msg01200.html">[MUD-Dev] Re: Databases: was Re: skill system</A></STRONG>
</LI>
<LI>Index(es):
<UL>
<LI><A HREF="index.html#01153"><STRONG>Date</STRONG></A></LI>
<LI><A HREF="thread.html#01153"><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>[MUD-Dev] Re: Databases: was Re: skill system</STRONG>, <EM>(continued)</EM>
<ul compact>
<ul compact>
<ul compact>
<LI><strong><A NAME="01074" HREF="msg01074.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Tue 16 Jun 1998, 17:25 GMT
<UL>
<LI><strong><A NAME="01075" HREF="msg01075.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
s001gmu <a href="mailto:s001gmu#nova,wright.edu">s001gmu#nova,wright.edu</a>, Tue 16 Jun 1998, 18:02 GMT
<UL>
<LI><strong><A NAME="01081" HREF="msg01081.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Tue 16 Jun 1998, 18:44 GMT
</LI>
</UL>
</LI>
</UL>
</LI>
<LI><strong><A NAME="01152" HREF="msg01152.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Sat 20 Jun 1998, 08:20 GMT
<UL>
<LI><strong><A NAME="01153" HREF="msg01153.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
Adam J. Thornton <a href="mailto:adam#phoenix,Princeton.EDU">adam#phoenix,Princeton.EDU</a>, Sat 20 Jun 1998, 13:41 GMT
<UL>
<LI><strong><A NAME="01200" HREF="msg01200.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Thu 25 Jun 1998, 05:52 GMT
<UL>
<LI><strong><A NAME="01212" HREF="msg01212.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
J C Lawrence <a href="mailto:claw#under,engr.sgi.com">claw#under,engr.sgi.com</a>, Fri 26 Jun 1998, 06:45 GMT
<UL>
<LI><strong><A NAME="01265" HREF="msg01265.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
Jon A. Lambert <a href="mailto:jlsysinc#ix,netcom.com">jlsysinc#ix,netcom.com</a>, Tue 30 Jun 1998, 06:56 GMT
</LI>
</UL>
</LI>
</UL>
</LI>
</UL>
</LI>
<LI><strong><A NAME="01188" HREF="msg01188.html">[MUD-Dev] Re: Databases: was Re: skill system</A></strong>,
s001gmu <a href="mailto:s001gmu#nova,wright.edu">s001gmu#nova,wright.edu</a>, Wed 24 Jun 1998, 04:45 GMT
</LI>
</UL>
</LI>
</ul>
</ul>
</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>
