StraightSql

Accessing relational database systems from Python is straighforward. The Python standard library comes with a simple in-memory relational database system SQLite via de sqlite3 module. Other RDBMS can be accessed similarly using SQLAlchemy.

What is it?

1. fill_db.py: this script will initialize an SQLite3 database by creating a table weather with three fields city_code, date, and temperature. The inserted values are randomly determined.
2. query_db.py: this script uses a database such as the one generated by the script above and cmoputes the average temperature for each city code between a given date range.
3. weather-db: an example SQLite database.