What avantages does sql have over regular world/player files. I remeber a
post on CeramicMouse about how SQL wouldn't work right in a MUD atmosphere.
But for some reason I am stuborn and probally will try to add SQL support to
my mud. Any one want to help takle this huge thing. ATM I don't have a
mud and nor the will to get a MUD started so I love to work on stuff to
submit back to the circlemud community. So e-mail me if you are
interrested.
~Brandon
http://nxt.dhs.org/~bennetb
bennetb@sw2.k12.wy.us
----- Original Message -----
From: Dan Merillat <harik@chaos.ao.net>
To: <CIRCLE@post.queensu.ca>
Sent: Wednesday, April 12, 2000 3:48 PM
Subject: Re: [CIRCLE] [CODE] Multiple dimension arrays & binary delimiters
> Patrick Dughi writes:
> >
> > If you would like to avoid this, you have a few options:
> >
> > ascii pfiles.
> > separate all pfiles into individual binary files.
>
> ... or my favorite (for the criminally insane): SQL
>
> I wrote a thin SQL abstraction layer if anyone else wants to do the
> same... it dosn't work for all types of commands yet but you can
> exec anything and get columns out of rows.
>
> currently it's setup to connect to a postgresql database, but it's
> trivial to convert to any SQL database that has a C library interface.
>
> http://chaos.ao.net/~harik/concept/ (there's a link to it)
>
> concept is my classless/levelless mud, which is up to the... loading
> room names/numbers/descriptions/exits from SQL stage. (first stage of
boot)
>
> Most of my experiments are on my (infrequently online) stock circle...
>
> I havn't tried integrating SQL into circle directly, since this requires
> a rewrite of the way the runtime DB handles objects, so I havn't tried to
> implement it in stock circle. It's a good project for an experienced
> coder, though.
>
> You might get away with a varchar field containing a comma delimited
> list of item numbers a player has loaded, or some other string
> representation of items. ex: "5,3(2,2,2,3(4,4),8),9" where 3 is a
> bag and 2 is something like a ration.
>
> --Dan
>
>
> +------------------------------------------------------------+
> | Ensure that you have read the CircleMUD Mailing List FAQ: |
> | http://qsilver.queensu.ca/~fletchra/Circle/list-faq.html |
> +------------------------------------------------------------+
+------------------------------------------------------------+
| Ensure that you have read the CircleMUD Mailing List FAQ: |
| http://qsilver.queensu.ca/~fletchra/Circle/list-faq.html |
+------------------------------------------------------------+
This archive was generated by hypermail 2b30 : 04/10/01 PDT