Several months ago I decided to try to develop my own reports from RoastMaster data. I contacted Danny Hall, the app’s developer, on the Roastmaster app forum for advice on creating queries from the database. The database management system that Roastmaster uses is SQLite which is commonly used in web applications and other small applications where it is desirable to have the DB embedded in the application rather than running as a separate process. The app user’s database is easily exported on an iPad to the user’s dropbox account. I did some of my development work on my PC primarly using a free application called SQLiteStudio. It is very easy to use. The only shortcoming is there is no printing fuctionality whatsoever. In fact, none of the free applications for SQLite seem to have that feature! Because of this, I am currently using the SQLite3 command line tool to create reports. The tool runs in a windows command window and uses “dot” commands. .help shows a list of commands. You can enter the command line interface from the windows command window.
enters and loads the rm.db database, my Roastmaster database. I renamed it from My Database.sqlite, which is the default name after the database is exported from Roastmaster.