SQLite

Also commonly known as "sqlite3".

I just found out about a plugin for Firefox that lets me dig around in sqlite databases.

Working with Python and SQLAlchemy

For day to day stuff, I use Python and SQLAlchemy to talk to databases. Look for "SQLite Manager".

I also use the command line program, sqlite3.

Yaris app

I started writing an app that uses SQLite to track and map my Yaris MPGs. I was planning on putting it on my Garmin Monterra. Not doing any Android work right now though!

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