sakila VS pagila

FROM yugabytedb/yugabyte:latest # get Sakila DDL and DML scripts ADD https://github.com/jOOQ/sakila/raw/main/yugabytedb-sakila-db/yugabytedb-sakila-schema.sql . ADD https://github.com/jOOQ/sakila/raw/main/yugabytedb-sakila-db/yugabytedb-sakila-insert-data.sql . # Start YugabyteDB to run the scripts RUN yugabyted start \ && until ysqlsh -h $(hostname) -c "create database sakila" ; do sleep 1 ; done | uniq \ && ysqlsh -h $(hostname) -d sakila -f yugabytedb-sakila-schema.sql \ && ysqlsh -h $(hostname) -d sakila -f yugabytedb-sakila-insert-data.sql \ && yugabyted stop \ && rm -f /root/var/data/yb-data/*/wals/table-*/tablet-*/index.* # starting a container can re-start YugabyteDB ENTRYPOINT yugabyted start --background=false

The script only contains INSERT statements, you apparently did not create the table and sequences before you ran that script. You need to run the script to create the schema first: https://github.com/jOOQ/sakila/blob/main/postgres-sakila-db/postgres-sakila-schema.sql

Then downloading the database https://github.com/jOOQ/sakila (has a ERD to help you write your queries as well)

The tutor told us that he wrote the whole file for us, but now thanks to both your leads I have found out that the file PAGILA is a GIT project at https://github.com/devrimgunduz/pagila , the "translation" of Sakila training database for MySQL.

One day, I was puzzled about how to generate some random data for development and testing without leaving my warm SQL console (in my case, psql). That’s when this set of SQL-scripts was born to generate a large amount of data for Pagila, a popular PostgreSQL sample database. You can find these scripts here: https://github.com/synthesized-io/pagila-data-generation (in "sql" folder) – and adapt them to your database schemas. I would be extremely grateful for any advice and ideas.

Create HTTP and/or gRPC server for pagila database (DVD rental database). Each server should expose metrics for scraping as well as emit traces (either to Zipkin or Jaeger, or if you feel adventurous you can support both). Start with either HTTP or gRPC and first implement just Customer service that would return customer by ID and allow inserting new one, that should be good start. When done with server(s) create GUI applications, one native, one for web (Rust + WebAssembly). Everything should be pushed to GitHub, have GitHub Actions configured for tests and build.

You can get interesting sample db here: https://github.com/devrimgunduz/pagila - it uses quite a lot of different features of pg, including fkeys.

Would running a sample database in a container also be too much? You could have some example images with a schema like Pagila loaded into them.