PostgreSQL Dev Setup and Installation in "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.
Click through on the video for a timeline of specific topics throughout the session.
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.