{"repo":"lerocha/netflixdb","free":true,"listed":false,"github":"https://github.com/lerocha/netflixdb","clone":"git clone https://github.com/lerocha/netflixdb.git","description":"Sample database for MySQL, Oracle, PostgreSQL, SQLite, and SQL Server. Based on data from the Netflix Engagement Report and the Netflix Global Top 10 weekly list, it includes movies and TV shows for learning and practice purposes.","language":"Kotlin","stars":111,"topics":["database","mysql","oracle","postgres","postgresql","sql","sqlserver"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Netflix Sample Database Sample database based on the data from the Netflix Engagement Report and the Netflix Global Top 10 weekly list, it includes movies and TV shows for learning and practice purposes. Supported Database Servers MySQL Oracle PostgreSQL SQLite SQL Server Download Download the SQL scripts from the latest release assets. One or more SQL script files are provided for each database vendor supported. You can run these SQL scripts with your preferred database tool. Data Sources https://about.netflix.com/en/news/what-we-watched-the-first-half-of-2024 https://about.netflix.com/en/news/what-we-watched-the-second-half-of-2023 https://www.netflix.com/tudum/top10 Data Model Sample Queries - Postgres Development The application is a Spring Boot application that uses Spring Data JPA / Hibernate Object/Relational Mapping framework. The database schema is defined in these entity classes, and it gets auto-generated when the application starts up. After start-up, the application uses Spring Batch to run a batch job to populate the database based on the Netflix spreadsheet reports, and then exports the database schema and data to a SQL script. System Requirements JDK 21, for example: Amazon Corretto 21, Oracle OpenJDK 21, MS OpenJDK 21, etc. Docker Desktop Building and generating the SQL Scripts Start the database containers: Generate the SQL Scripts: The generated SQL scripts will be in the build/artifacts folder:","default_branch":null,"files":null,"tree":[],"storefront":"/r/lerocha","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/lerocha/netflixdb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}