# devrimgunduz/pagila

PostgreSQL Sample Database

Repository: https://github.com/devrimgunduz/pagila
Canonical: https://ross.abutalabs.com/products/pagila
Language: PLpgSQL
License: NOASSERTION
License Family: other
Last push: 2026-08-06T10:21:42+00:00

## Health v2 (maintenance only)
Score: 97/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 96, release rhythm 96, longevity 100
- inputs: {"age_days": 4108, "days_push": 27, "days_rel": 27, "gap_med": 8, "n_releases_24m": 2}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1104, forks 375 (observed 2026-08-28T04:03:36.299243+00:00)

## What it is
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
- artifact type: dataset
- maturity: active
- function: database, search-engine, developer-tools
- domain: databases, developer-tools, education, tutorials
- platform: cross-platform
- tags: postgresql, sample-database, sakila-port, sql-examples, b, fulltext-search, dvd-rental-schema, postgres, docker

## Member repositories
- devrimgunduz/pagila (main) score 97

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:36.299243+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:45:27.702752+00:00, confidence not recorded.
  - readme: https://github.com/devrimgunduz/pagila (fetched 2026-08-28T04:03:36.299243+00:00, sha 34625a6351dd)
- Data as of 2026-08-30T08:39:29.467469+00:00.