database2 plugin

database2 plugin page

Under construction

This plugin is not currently installed. Links below purporting to provide examples don't.

This creates an interface between a database and a wiki page. One can have the table shown on one page, and subsets of the data shown on other pages related to views within the database. For instance, the table displayed in sites can be queried, as in Map square J5. As such, it is an alternative to the DataTables and searchtablejs/sortablejs plugins.

At the moment, this seems like the best way to handle HârnWorld settlement data and the only way to handle people data. The downside is that there would then be two points of data entry that would need to be kept in sync. It may be cumbersome for editors to enter data into it directly. Therefore, an alternative would be database-assisted page creation with a db that is not afterward associated with the live wiki. DokuWiki itself does not have a central database, so a sort of page-as-display-form model isn't naturally doable.

It is an old plugin that may no longer be in active development. It worked reasonably well in the previous version of DokuWiki (Hogfather), so one hopes that it still may work now. Other options for a plugin like this are limited and often even older.

It seems a bit finicky, but someone comfortable with working with databases can get a good deal out of it, if not always by the easiest way. For instance, it seems that that individual views need to be created within the db and accessed as if they were tables in order for further filtration on the page to work properly. It is uncertain if parameters can be sent to these views, so they may have to be proliferated by brute force. Still, the parameters (grid squares, hundreds, shires) are finite and known now.