Cayo Jamboree 2024 - Breakout session: Database

This is a website contains all the resources that you would need to follow along with the Database breakout session.

Requirements

You have the option to follow along in any language of your choosing though the examples provided in this session are in R, Python and SQL. Since we will be connecting with the live database, internet connection is required throughout the session.

Examples within each language assumes basic knowledge of the language.

R

Necessary libraries:

• RPostgres
• DBI
• tidyverse (optional)

Python

Necessary libraries:

• psycopg2
• pandas (optional)

Use of Jupyter notebook is highly recommended for exploring data

SQL

The following SQL clients are recommended:

• DBeaver
• PGAdmin
• DataGrip (paid)

Web based option

If none of the above options are suitable for you however you'd like to follow along using a browser then you can register an account on https://explore.thlhp.org to write your own queries and view all previous queries.