DB

by Dantom
[Share] [Zip]
To download this library for your Linux/Mac installation, enter this on your command line:

DreamDownload byond://Dantom.DB##version=6

Emulator users, in the BYOND pager go to File | Open Location and enter this URL:

byond://Dantom.DB##version=6

2856 downloads
Version 0.6
Date added: Nov 30 2002
Last updated: Jul 16
13 fans
Access databases from DM. [More]
Dantom.DB is compatible with unix & Windows (as of BYOND release 413). Originally written by Dan; currently maintained by Nadrew.

As of this writing, Dantom.DB supports access to MySQL databases (either local or remote). If you only require a local database, you are probably better off using the built-in SQLite database datum instead of Dantom.DB, as it is simpler and more efficient.

Installation:
Dantom.DB relays SQL commands from your game/program to the remote server. In order to do this, it makes calls to a "client connector" library that can speak the protocol. So you have to install this first. We recommend using Maria DB's connector due to their active development and permissive (LGPL) license. You can install the client connector for your particular system from the MariaDB download repository (be sure to download or build the 32-bit versions only!) or compiled for BYOND usage here:

To use the packages, simply copy the included .dll or .so file to your BYOND/bin folder (where DreamDaemon resides).

If you are running a version of BYOND prior to 507, after installation, rename (or symlink) libmariadb.dll -> libmysql.dll (Windows) or libmariadb.so -> libmysqlclient.so (Linux/FreeBSD).

Updates:
v0.6
* Updated the documentation.

* Commented out DBQuery.SetConversion(), my tests show it doing absolutely nothing to the resulting data.

* Moved the defines into their own file to reduce the clutter in core.dm

* Cleaned up the commenting of the code and the code itself a bit more.

v0.5
* Added DBConnection.SelectDB() see db.html for details.
* Changed all global constants to quicker #defines.
* Added global variables DB_SERVER and DB_PORT to help SelectDB() out.
* Moved this information and the core code into seperate files.

v0.4
* Cleaned up the code even more. Rewrote the argument names for the procs to be less cryptic.
* Added a few comments here and there.
* Sped up various procs by "modernizing" some of the code inside of them.
* Wrote some actual documentation for the library, since as of 4.13 it should get a bit more usage.

v0.3
* Fixed long-standing bug with the connection process, adding a workaround to a strange BYOND bug.
* Updated all of the command arguments to not match local variables, as it was causing tons of issues.
* The arguments aren't named very well, but you can tell what they do.
* Added GetColumnData() function to the DBQuery datum, this function will allow you to obtain a list of table data referenced by name and not by index number.

v0.2
Cleaned up the code significantly.

v0.1
Initial release.

More Info

MySQL and BYOND by Nadrew

Advertisement

Comments

Pirion: (Mar 31, 8:03 pm)
DBConnection.SelectDB() uses the constants rather than the instance vars for Server and Port when it builds the DBI. This would be more consistent to use the Instance variables.
RageFury33: (Aug 24 2011, 11:02 am)
Love the system, though I am still trying to get use to it, and relearn my MySQL skills.