Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Due to spam on this forum, all posts now need moderator approval.
Entire forum
➜ Programming
➜ General
➜ C++ and Mysql
It is now over 60 days since the last post. This thread is closed.
Refresh page
Pages: 1
2
| Posted by
| Jon Lambert
USA (26 posts) Bio
|
| Date
| Reply #15 on Thu 31 Aug 2006 01:43 AM (UTC) Amended on Thu 31 Aug 2006 04:40 AM (UTC) by Jon Lambert
|
| Message
| I'd argue Postgres over MySQL, but rather let's cut to the chase or the root of the problem. Using MySQL with the default storage backend MyISAM is an accident just waiting to happen as it is not ACID compliant. Override the defaults and use the InnoDB as the backend for MySQL. I think there's a storage parameter on CREATE TABLE DDL. MyISAM storage can be very easily corrupted if the server is killed for any reason, signal or power outage. InnoDB is immune to such corruption and is of necessity slightly slower because it journals, a good thing, but you'll not notice it.
I'm using Sqlite. http://sqlite.org
SQLite is also not a "real" rdbms as it don't support many of the necessary relational algebras such as constraints and schema alter very well. However, it is ACID compliant and can be nicely embedded in a server without any need for administrative (root) permissions.
Watch for the next release of Murk++. ;-)
Here's another tutorial on it:
http://docs.cs.byu.edu/docs/sqlite/index.php
Also Postgres supports GIS databases with spatial query language additions. The usefulness of this for roomless muds has yet to be explored AFAIK. There was a discussion on GIS over on the MudLab forum. Do a search on GIS over there if it's of interest. :-)
| | 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.
66,545 views.
This is page 2, subject is 2 pages long: ![[Previous page]](/images/thin_prev.gif)
1
2
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top