I Cover PostgreSQL Dev Setup and Installation in My Series "Bunches of Databases in Bunches of Weeks"
Tags: database, distributeddatabases
Published: 2019-02-10 19:34:38

---
title: I Cover PostgreSQL Dev Setup and Installation in My Series "Bunches of Databases in Bunches of Weeks"
published: true
description: 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.
tags: database, distributed-databases
---
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 "<a href="https://pragprog.com/book/rwdata/seven-databases-in-seven-weeks" target="_blank" rel="noopener noreferrer">7 Databases in 7 Weeks</a>". In this session I got into a hard look at <a href="https://www.postgresql.org/" target="_blank" rel="noopener noreferrer">PostgreSQL</a> 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.

{% youtube UD5cQ9fMYcQ %}

<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=0s">0:00</a> - The intro image splice and metal intro with tunes..
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=214s">3:34</a> - Start of the video database content.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=274s">4:34</a> - Beginning the local installation of Postgres/PostgreSQL on the local machine.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=1230s">20:30</a> - Getting pgAdmin 4 installed on local machine.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=1460s">24:20</a> - Taking a look at pgAdmin 4, a stroll through setting up a table, getting some basic SQL from and executing with pgAdmin 4.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=3605s">1:00:05</a> - Installing Docker and getting PostgreSQL setup as a container!
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=3636s">1:00:36</a> - Added the link to the <a href="https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04" target="_blank" rel="noopener noreferrer">stellar post at Digital Ocean's Blog</a>.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=3655s">1:00:55</a> - 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!
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=3670s">1:01:10</a> - Installing Postgesql on Ubuntu 18.04.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=4004s">1:06:44</a> - Signing in to Docker hub and finding the official Postgresql Docker Image.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=4168s">1:09:28</a> - Starting the container with Docker.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=4224s">1:10:24</a> - Connecting to the Docker Postgresql Container with pgadmin4.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=4380s">1:13:00</a> - Creating a database and working with SQL, tables, and other resources with pgAdmin4 against the Docker container.
<a href="https://youtu.be/UD5cQ9fMYcQ/watch?v=UD5cQ9fMYcQ&t=4563s">1:16:03</a> - The hacker escape outtro. Happy thrashing code!

For each of these sessions for the "<a href="https://www.youtube.com/playlist?list=PL4f75Y6Ce5ssKPOFLtPjUmDWsinO4K-c4" target="_blank" rel="noopener noreferrer">Bunches of Databases in Bunches of Weeks</a>" series I'll follow this following sequence. I'll go through each database in <a href="http://compositecode.blog/2019/01/04/lets-talk-top-7-options-for-database-gumbo/">this list of my top 7 databases</a> 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 "<a href="https://pragprog.com/book/rwdata/seven-databases-in-seven-weeks" target="_blank" rel="noopener noreferrer">7 Databases in 7 Weeks</a>"

"<strong>Day 1</strong>" 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.

"<strong>Day 2</strong>" 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.

"<strong>Day 3</strong>" 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.

"<strong>Day 4</strong>" and onward I'll determine the path and layout of the topic later, so subscribe on <a href="https://www.youtube.com/channel/UCHSCXYCMOOS-VSUdRsn13GQ" target="_blank" rel="noopener noreferrer">YouTube</a> and <a href="https://www.twitch.tv/adronhall/" target="_blank" rel="noopener noreferrer">Twitch</a>, and tune in. The <a href="https://www.twitch.tv/adronhall/events" target="_blank" rel="noopener noreferrer">events are scheduled</a>, with the option to be notified when a particular episode is coming on that you'd like to watch <a href="https://www.twitch.tv/adronhall/events" target="_blank" rel="noopener noreferrer">here on Twitch</a>.
<h3>Next Events for "<em>Bunches of Databases in Bunches of Days</em>"</h3>
<ul>
	<li><a href="https://www.twitch.tv/events/5JIXYj8rR-yp8Jv_Uy1LfQ" target="_blank" rel="noopener noreferrer">Bunches of Databases in Bunches of Weeks - SQL Server Day 1</a></li>
	<li><a href="https://www.twitch.tv/events/Daf4_TYORvqxIbUFpc-TNw" target="_blank" rel="noopener noreferrer">Bunches of Databases in Bunches of Weeks - Elasticsearch Day 1</a></li>
	<li><a href="https://www.twitch.tv/events/7BCRmc6zT0yXMYIBcHvQig" target="_blank" rel="noopener noreferrer">Bunches of Database in Bunches of Weeks - Redis Day 1</a></li>
	<li><a href="https://www.twitch.tv/events/oaDIP0yEQAmIKWhAxoO0pg" target="_blank" rel="noopener noreferrer">Bunches of Database in Bunches of Weeks - SQLite Day 1</a></li>
	<li><a href="https://www.twitch.tv/events/D0jI84RmS9-x0XdpW-eUpg" target="_blank" rel="noopener noreferrer">Bunches of Databases in Bunches of Weeks - DynamoDB Day 1</a></li>
</ul>

I'm on Twitter [@Adron](https://twitter.com/Adron) and Twitch [@adronhall](https://twitch.tv/adronhall/) listening to metal all the time and coding, writing about coding, learning, and teaching all sorts of topics from database tech to coding chops. Thanks for reading!