3 ms·
Related: You can use the Fossil bug tracker as a generic SQLite table. You can modify the interface for any type of input. While you can edit the schema if you
by bachmeier 4y ago
Related: You can use the Fossil bug tracker as a generic SQLite table. You can modify the interface for any type of input. While you can edit the schema if you want to use it as a traditional SQL database, I've found it easiest to treat one of the text columns as JSON and do queries on that.
The advantages: You get a web interface for free (using CGI) if you want one, it's distributed and version controls your database automatically. You can view reports graphically, at the command line, or from any other app that read an SQLite database. And in terms of stability, since Fossil is developed by the SQLite project, you can be confident that it'll be maintained for the rest of your life.
https://fossil-scm.org/home/doc/trunk/www/index.wiki https://fossil-scm.org/home/doc/trunk/www/index.wiki