Pervasive sql questions

[BearFather]

So I have yet to do this, mainly cause I keep forgetting. But I have couple of questions for those that run this setup.

First I take it once this is setup you can't do direct edits to the dats. Do I have to use an update file method instead? Or can nightmare actually still edit it.

Also when it comes to the live data on the board while it's running can you edit while the board still live? So if I wanted to update a item or added a line to a textblock in the sql data, will the board pick it up or do I need to wait for a restart?

Also how does it handle power losses? I run my server in a vm, and sometime when power drops I loose the vm, and I have found sql DB's don't like that very much.

So those two last questions kinda the same with how active is the game with that DB while it running.

[syntax]

Nothing changes. The format of the databases aren't changed, only the "versioning" of them. So it's still btrieve and not SQL. It's just a newer engine.

[BearFather]

I thought it was a sql DB, and you able to get queries from it while it was running.

[syntax]

I thought it was a sql DB, and you able to get queries from it while it was running.

You can through the pervasive server it sets up, but that has nothing to do with the format of the files themselves and how mmud / nmr / wg interacts with them. The format only changes slightly which is why the newer DLL is required. But all of functions you use to interact with the board will also use that DLL so it's all the same.

[BearFather]

Ok I think I understand it now. When I actually get around to this mod I holler if I have more questions.