JackSparrow414

PostgreSQL

Environment setup and practices for procedural languages.

2 posts · In reading order

  1. PostgreSQL (Part 1): Setting Up a Learning Environment

    Sets up a PostgreSQL learning environment with Docker Compose, configures database options through an .env file, and persists data with a volume. It covers connecting with pgAdmin and basic operations inside the container, including creating a table, querying tables, and inserting data.

  2. PostgreSQL (Part 2): Best Practices for Procedural Language Usage

    Database server-side programming with PL/pgSQL.