Posts

Tutorial on using sqlite on GRAV

Task The Lacrosse team has asked for a web interface to keep track of player information. (This is based on a question I was asked on the GRAV forum).   Perhaps because the GRAV CMS has been rated highly for several years, the decision was made to use it. So how to set up an interface using GRAV and keep all the data in an SQL database. Solution In this tutorial, I will show one way to list the data, add to the data, update data. It is possible to add a button to delete rows, but I think that sort of power should be left with the site administrator, not with an ordinary user. It is assumed that anyone reading this tutorial will have already installed a version of GRAV, and installed the Admin plugin. Consequently, later when I write 'install <plugin>', I can assume that the reader will know to login to the Admin plugin, click on the plugins tab, search for the plugin name and install it. There are other, more painful, ways to install a plugin, but if you know