MISSION 129

Project: PostgreSQL Installation

In this project, we'll walk through how to install the PostgreSQL database system and the psycopg2 Python library for Windows, Mac, and Linux. We'll focus on installing and running PostgreSQL locally on your own machine instead of on a remote server.

In Using PostgreSQL and other lessons in this course as well as past courses, we've explored many database concepts using SQLite and PostgreSQL. We've also explored the pros and cons of using SQLite and PostgreSQL. Specifically, we discovered that SQLite has the following advantages:

  • The database is stored in a single file, making it portable.
  • You can use a SQLite database directly from Python; you don't need a separate program running.
  • It implements most SQL commands, enabling you to use most of the statements you're familiar with.

Moreover, we found that PostgreSQL is preferred when developing complex applications because you may have multiple processes updating information in the database at the same time. For example, on Facebook, one process might handle updating user information, and another might handle generating the news feed.

Objectives

  • Learn how to install PostgreSQL and the Psycopg2 library.

Mission Outline

1. Introduction
2. Installing PostgreSQL
3. Psycopg2
4. Connecting to PostgreSQL from psycopg2

sql-databases-advanced

Course Info:

Advanced

The median completion time for this course is 6.1 hours. View Details

This course requires a basic subscription. This course includes four missions and one installation tutorial.  It is the 13th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside