<!-- MHonArc v2.4.4 --> <!--X-Subject: Re: [MUD-Dev] Re: Databases --> <!--X-From-R13: "Znherag Pbffnivg" <obffnivgNplorepnoyr.se> --> <!--X-Date: Mon, 17 Jan 2000 15:51:38 -0800 --> <!--X-Message-Id: E12ALrC-0001yE-00#kanga,nu --> <!--X-Content-Type: text/plain --> <!--X-Reference: 38839726.7879CA50@classic-games.com --> <!--X-Head-End--> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html> <head> <title>MUD-Dev message, Re: [MUD-Dev] Re: Databases</title> <!-- meta name="robots" content="noindex,nofollow" --> <link rev="made" href="mailto:bossavit#cybercable,fr"> </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="msg00111.html">Previous</a> | <a href="msg00113.html">Next</a> ] Thread: [ <a href="msg00111.html">Previous</a> | <a href="msg00113.html">Next</a> ] Index: [ <A HREF="author.html#00112">Author</A> | <A HREF="#00112">Date</A> | <A HREF="thread.html#00112">Thread</A> ] <!--X-TopPNI-End--> <!--X-MsgBody--> <!--X-Subject-Header-Begin--> <H1>Re: [MUD-Dev] Re: Databases</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] Re: Databases</LI> <LI><em>From</em>: "Laurent Bossavit" <<A HREF="mailto:bossavit#cybercable,fr">bossavit#cybercable,fr</A>></LI> <LI><em>Date</em>: Tue, 18 Jan 2000 00:15:09 +0100</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> [On databases in general] I wouldn't use MySQL - the fastest SQL database around - for a MUD. It's optimized for ultra-frequent fetches of small to medium large chunks of information; our databases services 50 queries/sec and about a quarter of a gigabyte. It all fits on one (admittedly beefed up) machine. But I wouldn't use any of the "big" databases either; they are optimized to scale to terabytes of data, with robustness and consistency of the data given much higher priority than performance. Fact is, I wouldn't consider using an SQL database for a M* type application; it's too much of a pain to map SQL records to the object oriented data used in most such software. My wish would be for a native XML data store, with the ease of use and top-notch performance of MySQL, and a query language as useful and usable as SQL. This would be perfect for a MUD, and in fact many other types of applications - with a good XML database you don't need SQL, you don't need an OODBMS (XML-Data bindings do the OO part, the data store does the dirty work), you don't need much of anything. Unfortunately there isn't such a thing out there yet. Sigh. -[Morendil]- Disk crash in progress - tagline service interrupted. _______________________________________________ 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> <ul compact><li><strong>Follow-Ups</strong>: <ul> <li><strong><A NAME="00115" HREF="msg00115.html">Re: [MUD-Dev] Re: Databases</A></strong> <ul compact><li><em>From:</em> Kevin Littlejohn <darius#connect,com.au></li></ul> <li><strong><A NAME="00113" HREF="msg00113.html">Re: [MUD-Dev] Re: Databases</A></strong> <ul compact><li><em>From:</em> "Dream Weaver at home" <windminstrel#home,net></li></ul> </UL></LI></UL> <!--X-Follow-Ups-End--> <!--X-References--> <UL><LI><STRONG>References</STRONG>: <UL> <LI><STRONG><A NAME="00111" HREF="msg00111.html">Re: [MUD-Dev] Re: Databases</A></STRONG> <UL><LI><EM>From:</EM> Greg Miller <gmiller#classic-games,com></LI></UL></LI> </UL></LI></UL> <!--X-References-End--> <!--X-BotPNI--> <UL> <LI>Prev by Date: <STRONG><A HREF="msg00111.html">Re: [MUD-Dev] Re: Databases</A></STRONG> </LI> <LI>Next by Date: <STRONG><A HREF="msg00113.html">Re: [MUD-Dev] Re: Databases</A></STRONG> </LI> <LI>Prev by thread: <STRONG><A HREF="msg00111.html">Re: [MUD-Dev] Re: Databases</A></STRONG> </LI> <LI>Next by thread: <STRONG><A HREF="msg00113.html">Re: [MUD-Dev] Re: Databases</A></STRONG> </LI> <LI>Index(es): <UL> <LI><A HREF="index.html#00112"><STRONG>Date</STRONG></A></LI> <LI><A HREF="thread.html#00112"><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><A NAME="00100" HREF="msg00100.html">[MUD-Dev] Re: Databases</A></strong>, T. Alexander Popiel <a href="mailto:popiel#wolfskeep,com">popiel#wolfskeep,com</a>, Sun 16 Jan 2000, 18:59 GMT <UL> <LI><strong><A NAME="00104" HREF="msg00104.html">Re: [MUD-Dev] Re: Databases</A></strong>, Greg Miller <a href="mailto:gmiller#classic-games,com">gmiller#classic-games,com</a>, Mon 17 Jan 2000, 19:54 GMT </LI> </UL> <UL> <li><Possible follow-up(s)><br> <LI><strong><A NAME="00108" HREF="msg00108.html">RE: [MUD-Dev] Re: Databases</A></strong>, Sellers, Michael <a href="mailto:MSellers#maxis,com">MSellers#maxis,com</a>, Mon 17 Jan 2000, 22:02 GMT <UL> <LI><strong><A NAME="00111" HREF="msg00111.html">Re: [MUD-Dev] Re: Databases</A></strong>, Greg Miller <a href="mailto:gmiller#classic-games,com">gmiller#classic-games,com</a>, Mon 17 Jan 2000, 22:27 GMT <UL> <LI><strong><A NAME="00112" HREF="msg00112.html">Re: [MUD-Dev] Re: Databases</A></strong>, Laurent Bossavit <a href="mailto:bossavit#cybercable,fr">bossavit#cybercable,fr</a>, Mon 17 Jan 2000, 23:51 GMT <UL> <LI><strong><A NAME="00113" HREF="msg00113.html">Re: [MUD-Dev] Re: Databases</A></strong>, Dream Weaver at home <a href="mailto:windminstrel#home,net">windminstrel#home,net</a>, Tue 18 Jan 2000, 02:18 GMT </LI> <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> </LI> </UL> </LI> </UL> </LI> </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 </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>