Unit 5b: Databases and Datastores

Learning Objectives

This unit provides optional reference material for students interested in exploring alternative, more advanced data storage solutions, including relational databases. :smiley_cat:

Discussions and Notes

• Google Sheets:

  • The gspread Package

• Relational Databases (SQL):

  • The sqlite Module (for SQLite databases)

  • The psycopg Package (for PostgreSQL databases)

  • The pymysql Package (for MySQL databases)

  • The sqlalchemy Package (an ORM for various relational databases)

  • The bigquery Package (for Google BigQuery)

• Document-object Storage ("No SQL"):

  • The pymongo Package (for MongoDB databases)

Activities and Exercises

• Database Exercise - follow the sqlite module notes to connect to and query an example SQLite database!