Re: Circlemud design issues

From: Rob Baumstark (shirak@CONNECT.AB.CA)
Date: 04/24/98

   I'd like to suggest a third alternative for storing players (It has been
mentioned before, but I think it should be again here.)  What about storing
everything in an external SQL database?  There are plenty of free small and
fast SQL compliant servers out there for Unix and Windows.  Besides making
loading/saving extremly easy and fast (SQL server code is FAR more optimized
then Circle's load/save code will ever be), it also makes for very easy
searches for players (removes the need for the player index), and it could
allow for much more functionality in the MUD for Implementors.  I would love
to be able to type in "Find players where level > 50", and have it give them
all back.  It would be easy to parse that, and change it to SQL (Wouldn't
want people to type in direct SQL.)
   Player editing would also be easy with SQL (assuming you know some basic
SQL)  Changing a players gold would just be "UPDATE Players SET Gold = 300
WHERE Name = 'Joe'"   The playerpurge util could be replaced just by "DELETE
FROM Players WHERE DATEDIFF(dd, GETDATE(), Last_Logon) > 30" (I'm familiar
with TransactSQL from MS SQL Server, but it should be very similar or the
same for other DBMS's)
   This could be taken farther, and put the entire world into the DBMS, but
I think that it would make building much harder, as all building would have
to be done through OLC.
G:  "If we do happen to step on a mine, Sir, what do we do?"
EB: "Normal procedure, Lieutenant, is to jump 200 feet in
     the air and scatter oneself over a wide area."
-- Somewhere in No Man's Land, BA4
     Rob Baumstark:

     | Ensure that you have read the CircleMUD Mailing List FAQ:  |
     | |

This archive was generated by hypermail 2b30 : 12/15/00 PST