Re: [Code] Native Database Driver Support

From: George Greer (greerga@circlemud.org)
Date: 04/02/99


On Fri, 2 Apr 1999, Michael Lemler wrote:

>> Not really, the MySQL code required to load a zone file out of the
>> database with comments and such in the code is only 165 lines.
>
>No included libs?  Don't recall how much extra overhead they take if any..

moving:~/mud/moving10apl4/src$ ldd ../bin/test
        libglib-1.3.so.0 =>
                /usr/local/gnome/lib/libglib-1.3.so.0 (0x4001c000)
        libmysqlclient.so.6 =>
                /usr/local/mysql/lib/mysql/libmysqlclient.so.6 (0x4003e000)
        libdb.so.3 => /lib/libdb.so.3 (0x40052000)
        libc.so.6 => /lib/libc.so.6 (0x4008d000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x40176000)
        libm.so.6 => /lib/libm.so.6 (0x4018c000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x401a8000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x401d5000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

Shared shouldn't take too much.

>Sounds good to me.  I'll have to actually get the code sometime to see
>what you are doing.

The current version doesn't show the sub-database format split yet.  It's
in my working tree which I don't consider to be "ready" for alpha release
yet.

>> All of the SQL-like databases should be able to share the same upper level
>> database if no extensions are used.
>
>True, key based model == key based model.  Beauty of realtions ;)

However, the "no extensions" part may give people headaches. :)

>> I coded up the MySQL module according to their C API.  I'll probably have
>> individual database drivers (though I'd hardly call them drivers based on
>> what I plan to do) for those I have access to and a generic ODBC driver for
>> people to use on databases I don't have.
>
>That sounds good to me.  This way you have the best of both worlds.
>Didn't know if you wanted the extra design time in there, but it isn't all
>that much of a code issue.

I figure I'll get two working (MySQL / ODBC, it now appears) and then
finish the rest of the code up.  The extra databases would be a secondary
issue because the way I want it setup is that other people can easily write
new modules.

--
George Greer            | The CircleMUD FAQ
greerga@circlemud.org   | http://developer.circlemud.org/docs/FAQ/


     +------------------------------------------------------------+
     | 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 : 12/15/00 PST