Category: SQL

1. How much can President Trump's Tariffs Impact Canadian Households? 2025-09-12

   An exploratory analysis of the potential effects of President Trump's tariffs on Canadian households using

2. Do you need a custom R package or Shiny dashboard for your team? 2025-09-01

   I build production-ready R tools that solve business problems.

3. Install PostGIS on Red Hat Enterprise Linux (RHEL) 8 2024-06-05

   A solution that took me hours of 'averaging' Google search results and using my brain.

4. Canadian Hansard Live Database 2023-07-27

   A ready to use SQL database that we can consult with dplyr.

5. Using Arrow with Shiny 2022-01-03

   A quick exploration of different technologies to work with

6. Comparing SQLite, DuckDB and Arrow with UN Trade Data 2021-08-27

   A quick exploration of different technologies to work with

7. SQL Databases for Students and Educators 2020-09-18

   Different SQL engines to cover small edge cases when moving between DB back ends

8. A Crash Course on PostgreSQL for R Users 2020-08-09

   How to read and write data in efficient ways

9. Writing tables into a PostgreSQL database using R 2018-03-14

   A short guide to install and use RPostgreSQL and/or odbc packages.