Zugg Software :: View topic - Next Beta version converts all databases to SQLite v3

Posted: Wed Jul 08, 2009 11:03 pm

Just a quick note to let everyone know that the next Beta version of CMUD (3.09) will be converting all of your existing database files from SQLite v2.8 into SQLite 3.3.13.

Starting in the 2.36 public version, CMUD could read *both* SQLite v2 and v3 files. So converting files to v3 should still allow you to use the same files in the 2.37 public version. But if you try to use earlier versions of CMUD, it won't be able to read the new files.

A *_bak.* backup file will automatically be generated for any file that is converted.

The list of files that are commonly converted the first time you run CMUD 3.09 include:
sessions.db
session_keys.db
muds.db
pkgcache.db (package library cache)
and *.pkg packages

The help file was already converted to SQLite v3 in an earlier version as a test.

All of this should be transparent to users (except for some "converting" messages, or slower than normal package loading the first time you open a session).

The advantage of converting everything to SQLite v3 is that once your files are converted, CMUD will no longer need the v2.8 SQLite.dll file. And this is the DLL file that sometimes fails to load on Windows Vista if Vista has not properly unloaded the library. Upon investigating this issue, it seems to be an issue with how Vista tries to relocated DLLs in memory and the old SQLite v2.8 DLL could sometimes fail to be relocated. This problem was fixed by the SQLite people in the v3 release. So there was no way for me to "fix" this SQLite.DLL loading error on Vista except to get everything converted to SQLite v3.

Since the CMUD v3 Beta has been using SQLite 3 extensively for many months now, I don't expect there to be any problems. But I wanted to give everyone a head's up, especially in case there is anyone still using CMUD versions older than 2.36 for some weird reason.