devrimgunduz/pagila resource

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1104 stars · 375 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Pagila is a PostgreSQL port of the MySQL Sakila sample database, providing a standard DVD rental schema with tables, data, views, and functions for use in books, tutorials, and examples. It showcases PostgreSQL features like boolean fields, triggers, foreign keys, fulltext search, JSONB, and SQL/JSON functions.

Use cases

• learn postgresql with a sample database
• practice sql joins on a realistic schema
• try postgres fulltext search examples
• experiment with b and sql/ functions
• use a standard schema for database tutorials and articles
• test postgres tools against sample data
• set up a demo database with docker compose and pgadmin

When to choose

• you need a well-known sample schema for teaching or writing about postgresql
• you want to practice postgres-specific features like b, fulltext search, and triggers
• you need consistent example data for testing database tools or queries

When to avoid

• you need production data or a real application backend
• you want a sample database for mysql rather than postgresql
• you need large-scale or big-data volumes for benchmarking

Facets

dataset · maturity active

database search-engine developer-tools databases developer-tools education tutorials cross-platform postgresql sample-database sakila-port sql-examples b fulltext-search dvd-rental-schema postgres docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="devrimgunduz/pagila")