Currently I use Fossil (which is not bad, but there could be a better way (possibly even modifying Fossil to support such thing), I think). If it is on a remot

Currently I use Fossil (which is not bad, but there could be a better way (possibly even modifying Fossil to support such thing), I think). If it is on a remote server, support using a SQLite virtual table to access it (this does not mean the server needs to use SQLite to store the database, but only that it supports the equivalent of xBestIndex) (for local data you can just use a SQLite database without a virtual table), then you can make up your own queries (although you may need authorization to post messages, to view them shouldn't need authorization). A command-line interface to file issues (as well as to view/download them) is also helpful, and perhaps a HTML interface too. Use whichever interface works best for your use, or all of them, if needed.