sql-pet
sql-pet copied to clipboard
smithjd
Exploring a realistic postgreSQL database with R via Docker
**Is your feature request related to a problem? Please describe.** Chapter 8 focuses on one table and works through some exploratory data analysis. It would be good to extend the...
``` There were 31 warnings (use warnings() to see them) > warnings() Warning messages: 1: In for (i in seq_len(n)) { ... : closing unused connection 33 (999-references.Rmd) 2: In...
``` [WARNING] This document format requires a nonempty element. Please specify either 'title' or 'pagetitle' in the metadata, e.g. by using --metadata pagetitle="..." on the command line. Falling back to...
There still seems to be a case or two where the initialization isn't right. For example, if an existing image has port 5432 that the code doesn't know about, the...
Add these two functions to the sqlpetr package. They are developed in file 150 and used in 155 as part of the dplyr exercises. sp_tbl_pk_fk_sql
**Is your feature request related to a problem? Please describe.** In Ch. 13 "[SQL joins and complex queries](https://smithjd.github.io/sql-pet/chapter-sql-joins-complex.html)": - Data inserted with `dbExecute` and `SQL` code has date fields initialized...