[Home] [Downloads] [Search] [Help/forum]

Register forum user name Search FAQ

Gammon Forum

[Folder]  Entire forum
-> [Folder]  MUSHclient
. -> [Folder]  General
. . -> [Subject]  Recommended database
Recommended database

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page

Posted by Pokkie   (11 posts)  [Biography] bio
Date Thu 29 Oct 2009 03:45 PM (UTC)
Message
I wish to start writing a database for my character. At the first it will just contain equipment but I might want to expand upon it later and have it contain other stuffs as well.

My question is, given my requirements which database implementation, MySQL vs SQLite would you recommend I use.



[Go to top] top
Posted by WillFa   USA  (525 posts)  [Biography] bio
Date Reply #1 on Thu 29 Oct 2009 06:33 PM (UTC)
Message
Which are you familiar with? Do you have a MySql database server somewhere?

If you're starting from scratch with nothing, then Sqlite is easier since it needs no other software than the database file.

If you have MySql, and are familiar with the quirks in its implementation of SQL, then use that.
[Go to top] top
Posted by Pokkie   (11 posts)  [Biography] bio
Date Reply #2 on Thu 29 Oct 2009 07:56 PM (UTC)
Message
I am not a DBA but I do work databases and SQL on a daily basis. So, I would prefer to work with MySQL. Just wasnt sure if it would be complete overkill for what I am trying to do.
[Go to top] top
Posted by Nick Gammon   Australia  (22,975 posts)  [Biography] bio   Forum Administrator
Date Reply #3 on Thu 29 Oct 2009 08:22 PM (UTC)
Message
MySQL is fine - I did some plugins that demonstrate using that. However MySQL is not zero-administration like SQLite3 is. In other words, you need the MySQL server to be running somewhere.

For a single process (ie. a MUD world) that just wants to save stuff (like mobs) to a database, probably SQLite3 is the easiest to use.

http://mushclient.com/sql

However if you want to use MySQL (and there is no major objection at all) then see this forum post:

http://www.gammon.com.au/forum/?id=5983

You would need to download and install MySQL, make sure it is running (eg. as a service on Windows, or possibly on a separate PC somewhere) and then interface with it as described in that forum post (this requires the mysql.dll to be installed to provide the functionality).

SQLite3 however is actually coded into recent versions of MUSHclient, and is available without any installation, configuration, or extra DLLs.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

14,915 views.

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page

Go to topic:           Search the forum

[Go to top] top

Quick links: MUSHclient. MUSHclient help. Forum shortcuts. Posting templates. Lua modules. Lua documentation.

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

[Home]

Written by Nick Gammon - 5K   profile for Nick Gammon on Stack Exchange, a network of free, community-driven Q&A sites   Marriage equality

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( https://gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Hosted at HostDash]