PostgreSQL Day 1 — Bunches of Databases in Bunches of Weeks
May the database deluge begin, it’s time for “Bunches of Databases in Bunches of Weeks”. We’ll get into looking at databases similar to how they’re approached in “7 Databases in 7 Weeks“. In this session I got into a hard look at PostgreSQL or as some refer to it just Postgres. This is the first of a few sessions on PostgreSQL in which I get the database installed locally on Ubuntu. Which is transferable to any other operating system really, PostgreSQL is awesome like that. Then after installing and getting pgAdmin 4, the user interface for PostgreSQL working against that, I go the Docker route. Again, pointing pgAdmin 4 at that and creating a database and an initial table.
Below the video here I’ve added the timeline and other details, links, and other pertinent information about this series.
0:00 — The intro image splice and metal intro with tunes..
3:34 — Start of the video database content.
4:34 — Beginning the local installation of Postgres/PostgreSQL on the local machine.
20:30 — Getting pgAdmin 4 installed on local machine.
24:20 — Taking a look at pgAdmin 4, a stroll through setting up a table, getting some basic SQL from and executing with pgAdmin 4.
1:00:05 — Installing Docker and getting PostgreSQL setup as a container!
1:00:36 — Added the link to the stellar post at Digital Ocean’s Blog.
1:00:55 — My declaration that if Digital Ocean just provided documentation I’d happily pay for it, their blog entries, tutorials, and docs are hands down some of the best on the web!
1:01:10 — Installing Postgesql on Ubuntu 18.04.
1:06:44 — Signing in to Docker hub and finding the official Postgresql Docker Image.
1:09:28 — Starting the container with Docker.
1:10:24 — Connecting to the Docker Postgresql Container with pgadmin4.
1:13:00 — Creating a database and working with SQL, tables, and other resources with pgAdmin4 against the Docker container.
1:16:03 — The hacker escape outtro. Happy thrashing code!
For each of these sessions for the “Bunches of Databases in Bunches of Weeks” series I’ll follow this following sequence. I’ll go through each database in this list of my top 7 databases for day 1 (see below), then will go through each database and work through the day 2, and so on. Accumulating additional days similarly to the “7 Databases in 7 Weeks”
“Day 1” of the Database, I’ll work toward building a development installation of the particular database. For example, in this session I setup PostgreSQL by installing it to the local machine and also pulled a Docker image to run PostgreSQL.
“Day 2” of the respective database, I’ll get into working against the database with CQL, SQL, or whatever that one would use to work specifically with the database directly. At this point I’ll also get more deeply into the types, inserting, and storing data in the respective database.
“Day 3” of the respective database, I’ll get into connecting an application with C#, Node.js, and Go. Implementing a simple connection, prospectively a test of the connection, and do a simple insert, update, and delete of some sort against the respective database built on the previous day 2 of the same database.
“Day 4” and onward I’ll determine the path and layout of the topic later, so subscribe on YouTube and Twitch, and tune in. The events are scheduled, with the option to be notified when a particular episode is coming on that you’d like to watch here on Twitch.