SQLite: Difference between revisions

From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs)
mNo edit summary
Brian Wilson (talk | contribs)
Line 36: Line 36:


== Working with Python and SQLAlchemy ==
== Working with Python and SQLAlchemy ==
For day to day stuff, I use Python and [[SQLAlchemy]] to talk to databases.
I also use the command line program, sqlite3.


[[Category: Android]]
[[Category: Android]]

Revision as of 01:18, 11 June 2015

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

Schema

log

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

journal

id key
date datetime
odometer decimal(7,1) 
weight int(11)
comment text

trip

id key
date datetime
start decimal(7,1)
stop decimal(7,1)
comment text

Reports

Calculated

mpg
average mpg


Working with Python and SQLAlchemy

For day to day stuff, I use Python and SQLAlchemy to talk to databases.

I also use the command line program, sqlite3.