I use ChannelsDVR to record all of my content -- which I then import into Plex to stream to all of my TVs. As you may know, Plex's naming convention of episodes can be off to what Channels shows because of sourcing differences. I'd like to use the episode name from Channels to override what Plex fetches from thetvdb.com for some of my shows. However, I want to avoid parsing the filename itself directly to get the episode information. Where are the DB files located for recordings, and can I query them directly? I assumed that they were SQLLite -- but I tried to open up one of the DB backup files, and SQLLite threw an error.
The databases are Bolt. It's a Key-Value database (NoSQL) implemented entirely in Go. If you really want to browse the databases, give BoltDbWeb a try.
If you're looking for something easier to work with, note API endpoints that a client accesses when looking up series by enabling HTTP logging in the DVR Web UI Experimental section. Then make your requests with cURL and use jq to parse the returned JSON. Shouldn't be terribly difficult—think of finding which endpoint to hit like finding the right DB table, and your jq query like the SQL statement.
You could also enable the mcebuddy experimental option, which will drop a json file next to each recording.
The json file has exactly the info I need and I can parse it out from there; thanks for the help!