I have a SQLite database that contains a dictionary (just words and definitions) that can be opened with free but proprietary software. To use with the software, it requires an 'unlock' key, which I have. I'm able to see it in this program, but I'd like to manipulate the data and re-arrange it. Currently, I'm paying freelancers on Fiverr to copy/paste every entry to a text document. Old-School Scraping.
I can open these documents in a SQL viewer like DBBrowser for SQLite. The entry listings are in plaintext, but the definitions are in BLOBs. I've tried hex(), which didn't work. I thought there was somewhere I could paste my key in to decrypt this, but I can't find that. What should I do here?
- I have the database
- I have the key required for unlocking it within the software that reads it
- I have the software that reads it
This is my first venture into reverse engineering, so I appreciate your help and patience.