Zenox - a new international classic server (dev)

[coreys]

Originally Posted by fowlplay4

Transactions, queries to analyze your data, and a centralized backup of all data seem like big benefits to me.

It's a mud system, what kind of analysis are you gonna be doing? Also backup is pretty easy no matter system you're using. Transactions are useful, of course, but I still don't see SQLite as being worthwhile as a replacement to other methods.

Originally Posted by firefighter

Hmm I don't think that this is a problem because mostly only integer numbers (for the indices) must be held and the memory is large enough i think

You'd be surprised. Now that Stefan seems to be migrating to new servers, memory may likely not be an issue, but you'd be surprised. If this was a few years ago memory would be a genuine cause for (lots of) concern in a system like this.

Originally Posted by firefighter

I hate storing data in files ...
Sometimes there is no other method to store data but I prefer to store it at least in a Database-NPC (I think also based on files but held in the memory). And storing the data on logout isn't good because the logout-event isn't called e.g. if the graal client crashes or not?

Hm, I've never had a problem onPlayerLogout not being called if a client crashes. Ideally I would think it's called when the connection is lost.

Originally Posted by firefighter

I don't know if it makes sense

Oh, I was joking about the RSA encryption stuff lol There's honestly just very little we as scripters can do to protect from most forms of hacking. That has to be done in the network code, which is Stefans end of things.