SQLite files can't easily be merged. Putting one database in another database doesn't allow you to take advantage of the best features of either one.
Text files are a good idea, and I've done that for many of my own projects. You just need to figure out a filename scheme, and a file format (JSON? YAML?). It's great to be able to atomically commit a fix to the source code, and also close the bug report.
I'm not sure how well it would scale. (Mozilla has 1.5M bug reports in their Bugzilla!) At the least, you'd need a local client that could index the text files into a format more suitable for sorting/searching. It would only need to download the diffs, though.
Oh oops, there already exist bug trackers for a few decades :)
Take your favorite bug tracker and put its offline storage into a git submodule?? I imagine they are all better than GitHub issues which are literally just a forum of threads
Text files are a good idea, and I've done that for many of my own projects. You just need to figure out a filename scheme, and a file format (JSON? YAML?). It's great to be able to atomically commit a fix to the source code, and also close the bug report.
I'm not sure how well it would scale. (Mozilla has 1.5M bug reports in their Bugzilla!) At the least, you'd need a local client that could index the text files into a format more suitable for sorting/searching. It would only need to download the diffs, though.