Free Small Stand-Alone DataBase?
Unfortunately, the trade is not under my direct control, which is why I want long-term locks (start when the trade starts, end when it's confirmed by the game).
If this is for a single application (with multiple threads) then a hand crafted solution would be fastest and take up the least memory. Hash driven index resolution isnt that hard (including for strings...)
It might be possible that the entire DB can be memory resident (using simple transaction logfiles to protect against failures between DB sync image saves).
Otherwise random access files with memory resident hash indexing if your entire
dataset id too large...
InterThread record locks are likewise not that difficult to code (Critical Section protected Lock lists...)
A decent programmer could write the code in a day.
It might be possible that the entire DB can be memory resident (using simple transaction logfiles to protect against failures between DB sync image saves).
Otherwise random access files with memory resident hash indexing if your entire
dataset id too large...
InterThread record locks are likewise not that difficult to code (Critical Section protected Lock lists...)
A decent programmer could write the code in a day.
Unfortunately, it's for a single application that will have multiple instances running at once that need to access the same database. Of course, it's theoretically possible to make it a single application, but not at all simple and that would bring additional complications (such as eliminating the protection from other processes that the OS provides, and making it much more difficult to kill an individual instance should it hang, etc).
Also, it would be very difficult to make a utility to search the logs as well as is possible with even the simplest of the databases proposed in this thead.
Also, it would be very difficult to make a utility to search the logs as well as is possible with even the simplest of the databases proposed in this thead.
This topic is closed to new replies.
Advertisement
Popular Topics
Advertisement