sqlpetr
is the companion R package for the database tutorial eBook at
https://github.com/smithjd/sql-pet. It has two classes of functions:
sqlpetr
has a pkgdown
site at https://smithjd.github.io/sqlpetr/.
You will need the following software:
See below for the details if you’re a Linux desktop user.
If you are working through the code in the book, you will need to install this package first. Note that these instructions assume Windows or MacOS. For Linux, you will need to install some Linux packages. See below for the details on Ubuntu, Fedora or Arch Linux.
Make sure you have a writeable personal library.
Update all your packages with update.packages()
.
Install remotes
if you haven’t already.
In an R console, type
remotes::install_github("smithjd/sqlpetr", force = TRUE, build = FALSE, quiet = TRUE)
We support Ubuntu Linux 18.04 LTS (“Bionic Beaver”) or later, Fedora 28 or later and Arch Linux. You will need to install RStudio yourself, but we provide scripts to install all the other Linux dependencies including R and Docker.
Install Linux - any desktop should work.
Browse to
https://github.com/smithjd/sqlpetr/tree/master/inst/linux. You
will find install scripts for Ubuntu, Fedora and Arch. Download the
one for your distro, make it executable and run it. The script will
install R and the Linux dependencies for sqlpetr
, install Docker,
add you to the docker
group and enable/start the Docker service.
Now do
remotes::install_github("smithjd/sqlpetr", force = TRUE, build = FALSE, quiet = TRUE)
to install sqlpetr
.
Note that you will need to log out back to the display manager prompt
and log back in for Docker commands to work without sudo
.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.