SQLite

From Wildsong
Revision as of 03:28, 24 December 2012 by Brian Wilson (talk | contribs) (Created page with 'I am using SQLite for a web + Android app that will track and map my MPGs. Schema id key date datetime odometer decimal(7,1) mileage decimal(5,1) distance traveled since la…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

I am using SQLite for a web + Android app that will track and map my MPGs.

Schema 

id key
date datetime
odometer decimal(7,1) 
mileage decimal(5,1) distance traveled since last fillup
gallons decimal(5,3)
price decimal(6,3) price per gallon
cost decimal(6,2) total purchase
lat text
lon text
comment text ex: gas station name and address

Calculated 

mpg
average mpg
Retrieved from "https://wiki.wildsong.biz//index.php?title=SQLite&oldid=7383"