pagila
PostgreSQL Sample Database (by devrimgunduz)
pagila-data-generation
A set of SQL scripts for random data generation for the Pagila database (by synthesized-io)
pagila | pagila-data-generation | |
---|---|---|
7 | 2 | |
786 | 6 | |
- | - | |
0.0 | 2.3 | |
3 months ago | about 1 year ago | |
PLpgSQL | SQL | |
GNU General Public License v3.0 or later | BSD 3-clause "New" or "Revised" License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pagila
Posts with mentions or reviews of pagila.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-15.
-
GROUP_CONTACT() documentation
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.
-
Populate databases with random data using SQL scripts
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.
- Onde encontrar um DB de SQL para praticar queries?
- Total beginner stuck at importing sakila database...
-
Lack Imagination to build own projects
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.
-
database student needing some help
You can get interesting sample db here: https://github.com/devrimgunduz/pagila - it uses quite a lot of different features of pg, including fkeys.
-
Any publicly hosted sample databases?
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.
pagila-data-generation
Posts with mentions or reviews of pagila-data-generation.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-15.
-
Where to practice SQL?
We have a training project where we generate data for Pagila db via pure SQL - https://github.com/synthesized-io/pagila-data-generation You could add some new queries or update some existed ones, just create a PR
-
Populate databases with random data using SQL scripts
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.
What are some alternatives?
When comparing pagila and pagila-data-generation you can also consider the following projects:
sakila - The Sakila Database
TX-2-simulator - Simulator for the pioneering TX-2 computer
AdventureWorks-for-Postgres - Set up the AdventureWorks sample database for use with Postgres
chinook-database - Sample database for SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DB2
Projects - :page_with_curl: A list of practical projects that anyone can solve in any programming language.
Exercism - website - The codebase for Exercism's website.
adventofcode - Advent of Code solutions of 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022 and 2023 in Scala