Developing Reports for Roastmaster iOS app

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.

sqlite3 rm.db

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.

The SQLite logo as of 2007-12-15
The SQLite logo as of 2007-12-15 (Photo credit: Wikipedia)
Enhanced by Zemanta

Author: korkiley

Systems Administrator at University of Vermont (retired as of 7/1/2012) Married Favorite Activities: Condor Glider Online Competition, Developing web sites, making espresso, and keeping a blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: