pagila 3.1.0

This is a maintenance release by 5 contributors:

What's Changed

• Format 2nd list of relations. by @michelc in #20
• ✨ pgAdmin by @Qoyyuum in #27
• 📝 container name in Docker Compose by @Qoyyuum in #24
• 🎉 Sakila Link by @Qoyyuum in #25
• 🎉 Schema Diagram by @Qoyyuum in #26

New Contributors

• @michelc made their first contribution in #20
• @Qoyyuum made their first contribution in #27

Full Changelog: pagila-v3.0.0...pagila-v3.1.0

Add JSONB data, add docker compose support, and fix various issues.

This new release brings in some new features and bugfixes:

• Add JSONB sample data (based on the packages at apt.postgresql.org and yum.postgresql.org)
• Add docker compose support ( contributed by @theothermattm ) #16
• Add steps to create pagila database on docker by @dedeco in #13
• Add missing user argument by @zOxta in #14
• Update dates to 2022
• Fix various issues reported in Github

2.1.0: Bug fixes and improvements

Version 2.1.0:

This release works against PostgreSQL 11+.

• Replace varchar(n) with text (David Fetter)
• Match foreign key and primary key data type in some tables (Ganeshan Venkataraman)
• Change CREATE TABLE statement for customer table to use
  DEFAULT nextval('customer_customer_id_seq'::regclass) for customer_id
  field instead of SERIAL (Adrian Klaver).

2.0.1

• Update schema for newer PostgreSQL versions
• Remove RULE for partitioning, add trigger support.
• Update years in sample data.
• Remove ARTICLES section from README, all links are dead.

Pagila 0.11.0

This release has a few improvements over previous one:

Update schema for newer PostgreSQL versions
Remove RULE for partitioning, add trigger support.
Update years in sample data.