Quote:
Originally Posted by itimpi
If you want to play around with editing the database directly then there are quite a few tools for manipulating sqlite3 databases. If you are using a PC then I recommend sqliteman as a good tool.
Obviously you should also first make a back-up in case things go wrong!
|
I can manipulate the database easily enough. The problem is that it contains triggers, and those triggers relate to functions that are not actually in the database. I assume they are implemented in Python, but I don't know. I don't know of a client for sqlite that will allow the triggers to be disabled and, even if there were a way to do so, I don't know what damage it would do to the underlying data if I edited the data without the triggers having effect. My suspicion is that it would be fine for the changes I envisage, but I don't know.
It's not a huge bit deal -- I don't have enough books that I can't make these changes manually if I have to. I could probably have done it in less time than I've already spent fiddling around with the database :/