sql_future.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# The Future is Now\n",
    "Welcome to the future of Jupyter -- JupyterLab. To get to JupyterLab just change the URL of the jupyternotebook to say `lab` instead of `tree`. In my example that was changing this URL, `https://si330jup.umsi.courses/user/264095/tree` to this one `https://si330jup.umsi.courses/user/264095/lab`\n",
    "\n",
    "Let's do a quick tour, then get on to SQL."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remember our connection parameters?\n",
    "```\n",
    "# connection information\n",
    "host=\"localhost\"\n",
    "dbname=\"si330\"\n",
    "user=\"jovyan\"\n",
    "password=\"si330studentuser\"\n",
    "```\n",
    "We need to turn these into a connection string - a URL which describes the database, machine, and username/password which we want to use. For this docker container, we'll use `postgres://jovyan:si330studentuser@localhost:5432/si330`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Preliminary steps\n",
    "Open up a new terminal and check to see whether the Jupyter SQL extension is correctly installed with `jupyter serverextension list`, you want to see output like the following:\n",
    "\n",
    "```\n",
    "jovyan@jupyter-264095:~$ jupyter serverextension list\n",
    "\n",
    "config dir: /home/jovyan/.jupyter\n",
    "    jupyterlab_sql  enabled \n",
    "    - Validating...\n",
    "      jupyterlab_sql  OK\n",
    "config dir: /opt/conda/etc/jupyter\n",
    "    jupyterlab  enabled \n",
    "    - Validating...\n",
    "      jupyterlab 1.2.1 OK\n",
    "    jupyter_nbextensions_configurator  enabled \n",
    "    - Validating...\n",
    "      jupyter_nbextensions_configurator 0.4.1 OK\n",
    "```\n",
    "\n",
    "If that is missing then we just need to enable the jupyter server extension. We can do this with the command `jupyter serverextension enable jupyterlab_sql --py`. After that finishes you need to rebuild the application cache within JupyterLab, with `jupyter lab build`. This command will take awhile.\n",
    "\n",
    "After that you need to restart your JupyterLab system, so log out and shutdown your notebook.\n",
    "\n",
    "Finally, remember to start up your postgres service from the command line with `sudo service postgresql start`."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now lets try the SQL extension, File->New Launcher->SQL."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}