pagila
pagila copied to clipboard
devrimgunduz
PostgreSQL Sample Database
At the very least we want to quickly see the table relations in an ERD diagram Any plan to include like a screenshot to quickly see how the table relationships...
The current examples for JSONB (`yum` and `apt`) are outside the domain of the DVD rental example. It might be more beneficial to add JSONB columns to either the existing...
I have only formatted the second "List of relations" in the part docker-compose. of the readme.
It could be a good idea to have a link to Sakila in the readme, for people who are also interested in the MySQL version.
TODO: Add partitioning with pg_partman for educational purposes.
The current docker-compose file has a `container_name: pagila`. Therefore, update the instruction to use call and execute to pagila container name.
In the original Sakila schema, the `payment_id` column in the `payment` table has a PRIMARY KEY constraint. Pagila does not. I found this by accident when I restored a backup...
I noticed that the .sql files are in PGDMP format. This is fun, but the extension of .SQL is pretty much always in ASCII text or UTF-8 text format. My...
