Skip to content

Using SQL Alchemy to query a database and build a Flask app based off the query results

Notifications You must be signed in to change notification settings

kimco2/sqlalchemy_flask

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 

Repository files navigation

Using SQLAlchemy and Flask

 ### Overview Using SQL Alchemy explore and analyse climate data from the climate database and Flask to build an app based off the queries.

Aspects Covered

  • Using SQLAlchemy to connect to the SQLite database
  • Linking python to the database by creating a SQLAlchemy session
  • Querying the database to answer specific questions.
  • Charting with matplotlib
  • Developing a Flask API with different routes based off the earlier queries

Visualisations

flask_api

Folder structure

The folder *SurfsUp contains:

  • Climate_analysis.ipynb - analysis undertaken on the climate data
  • app.py - code for the climate app

The folder Resources contains the data files used for this project.



Contact

Email: kymcoleman@gmail.com


About

Using SQL Alchemy to query a database and build a Flask app based off the query results

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published