Notes October 13, 2018

Topics

• Package coverage

• • Hide most system2 calls

• Package error messages

• Chapter: Chapter 5 A persistent database in Postgres in Docker - all at once (05)

• • Is it done?
  • Are the learning objectives correct?

• 3rd normal form?

• • Draft 1
  • Referential integrity is preserved
  • Analyst vs transactional needs

• Book / executables

• • View vs kable: how show rs
  • .R files

• Tables (book, & interaction)

• • Storage

  • Display

  • Size standards

  • Package

    • DT
    • Kable
    • .md
    • glimpse
    • skimr

• Book structure

• • index.Rmd
  • 02-docker_hosting_for_windows.Rmd
  • 03-learning-goals-use-cases.Rmd
  • 04-docker-setup-postgres-connect-with-r.Rmd
  • 05-docker-setup-postgres-with-dvdrental.Rmd
  • 10-environment_diagram.Rmd
  • 10-r-postgres-interaction.Rmd (old, combine into previous)
  • 11-dplyr_sql_summary.Rmd (merge with following)
  • 11-elementary-queries.Rmd
  • 12-a-production-perspective.Rmd
  • 13-sql_pet-examples-part-a.Rmd (Sophie will review, work out .rmd problems; compile problems)
  • 14-sql_pet-examples-part-b.Rmd
  • 15-sql_quick_start_simple_retrieval.Rmd
  • 21-29-drilling-into-db-environment.Rmd (sophie work in progress)
  • 21-r-query-postgres-metadata.Rmd (has pg references to be dropped)
  • 71-explain-queries.Rmd
  • 72-sql-query-steps.Rmd
  • 73_write-to-the-database.Rmd
  • 89-resources.Rmd
  • 90-references.Rmd
  • 92-environment_diagram.Rmd (became 10, delete)

• Todo

• • JDS:

    • Deal with renamed sp_color_markdown_text.R

    • Package dependencies for the book.

      • Bookdown
      • Tidyverse
      • Here

    • Devtools::usepackage

    • Make postgres creation a black box.

      • Return: "Successfully tagged postgres-dvdrental:latest"

    • All functions return a value.

    • Why not able to knit one chapter at a time?

      • Bookdown book
      • Definitive guide to rmarkdown
      • packagedown?