PostgreSQL 16.15
Pagila
DVD rental store. Pick a table to see the source and the synthetic copy together.
- Tables
- 22
- Rows, source
- 46,273
- Rows, synthetic
- 46,273
- Broken foreign keys
- 0 42 foreign keys checked on the data
The profile
Lyrebird read the source once and wrote this profile. The synthetic database was generated from the profile alone, with no connection to the source.
- Profile file
- 228 KB
- Relationships measured
- 42
- Rules tested / kept
- 716 / 9
- Personal columns found
- 15
- Tables with reference data
- 5
Generate it yourself
This is the same sealed profile that produced the copy on these pages. It holds no connection details, and you need no database to use it.
Download lyrebird-sample-pagila.lyre- Install Lyrebird Community, open it and go to Generate.
- Choose the downloaded file as the profile, then choose an output folder.
- Generate the SQL files, and load them into an empty PostgreSQL database or let Lyrebird load them into Docker.
Community generates up to 5,000 rows per table and keeps complete reference data as it is. 3 tables of this sample have more rows, so your copy will be smaller there than the one shown here.
Lyrebird Community 0.4.0
This release on GitHub228 KB · SHA-256 0508c016f1951770cf690f6aa87bd77673651a1020a156fbb49c389c436015c8
Tables
| Table | Columns | Source rows | Synthetic rows | Equal to a source row |
|---|---|---|---|---|
| actor | 4 | 200 | 200 | 0% |
| address | 8 | 603 | 603 | 0% |
| category | 3 | 16 | 16 | 100% |
| city | 4 | 600 | 600 | 97.8% |
| country | 3 | 109 | 109 | 100% |
| customer | 10 | 599 | 599 | 0% |
| film | 14 | 1,000 | 1,000 | 0% |
| film_actor | 3 | 5,462 | 5,462 | Keys only |
| film_category | 3 | 1,000 | 1,000 | Keys only |
| inventory | 4 | 4,581 | 4,581 | Keys only |
| language | 3 | 6 | 6 | 100% |
| payment | 6 | 16,049 | 16,049 | 0% |
| payment_p2022_01 | 6 | 723 | 723 | 0% |
| payment_p2022_02 | 6 | 2,401 | 2,401 | 0% |
| payment_p2022_03 | 6 | 2,713 | 2,713 | 0% |
| payment_p2022_04 | 6 | 2,547 | 2,547 | 0% |
| payment_p2022_05 | 6 | 2,677 | 2,677 | 0% |
| payment_p2022_06 | 6 | 2,654 | 2,654 | 0% |
| payment_p2022_07 | 6 | 2,334 | 2,334 | 0% |
| rental | 7 | 16,044 | 16,044 | 0% |
| staff | 11 | 2 | 2 | 0% |
| store | 4 | 2 | 2 | 100% |
About this data
Pagila, by Devrim Gündüz, a PostgreSQL port of the MySQL Sakila sample database. Source: Pagila, PostgreSQL License license. Subsetra is not affiliated with its authors.
Generated with Lyrebird 0.4.0 (af70e35), model v2.3, seed 20261101, at the size of the source. Profile hash: 3b670efef0011a58.