elven
Joined: 28 Jul 2006 Posts: 259 Location: Germany
|
Posted: Tue Aug 02, 2011 9:48 Post subject: SQL(or anywhere)-stored servervault characters |
|
|
For all those wanting to store their characters not in a filesystem, but in a SQL database instead, here's the proof of concept to do it: a FUSE mount, written in ruby.
It uses FUSE to mount at servervault/; whereupon character loads and saves get redirected to a handler (maybe written by you!), which will be doing the actual work.
This means that it will work on debian and ubuntu, but probably not win32 (although I saw there are fuse bindings as well).
There's a sample handler included that does basic storage in any sequel-compatible database (even sqlite if you roll that way, although I haven't tested how that behaves with many thousand characters).
The code can be found on github - there's some basic install instructions as well.
Note that this is proof of concept-quality code. It isn't actually tested in production and WILL probably eat someone's character (especially when not setting the correct database charset).
However, as soon as it receives some more love, it may be very useful for:
- easier character management by DMs & players themselves
- history/logging (you can easily parse characters with nwn-lib too to extract factoids about them)
- ..? |
|