{"repo":"bocaletto-luca/Movies-Database","free":true,"listed":false,"github":"https://github.com/bocaletto-luca/Movies-Database","clone":"git clone https://github.com/bocaletto-luca/Movies-Database.git","description":"Movies-Database is a structured SQL collection of movie data, including titles, directors, genres, release years, and ratings. Ideal for film-related research or database projects.","language":"HTML","stars":10,"topics":["data-management","database","dates","films","movie-data","movies","open-data","research","sql"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"Movies-Database Author: Bocaletto Luca Description: Structured SQL collection of 10,000 films, ideal for testing, exercises, applications, and analytics Files Type: SQL Total Tables: 1 Total Records: 10,000 Range Year: N/A Movies-Database delivers a unified moviedb table with rich attributes—title, overview, genre, release date, original language, poster URL and vote average—covering 10,000 films. Perfect for film-related research, prototype APIs, data science exercises, or demo applications. --- Table of Contents - Features - Schema - Repository Structure - Quick Start - Example Queries - Contributing - License --- Features - Single moviedb table with 10,000 entries - Consistent schema for seamless querying - SQL dump generated via phpMyAdmin (MySQL 8.0+ compatible) - Supplementary dates.sql for date-dimension use cases - Ready to import via MySQL CLI or phpMyAdmin --- Schema Column Type Description ------------------ ------------ ----------------------------------------- id INT Auto-increment primary key title VARCHAR(70) Movie title overview VARCHAR(350) Brief synopsis genre VARCHAR(100) Comma-separated genres (e.g., Action) release date DATE Release date (YYYY-MM-DD) original language VARCHAR(3) ISO language code (e.g., en, ja) poster url VARCHAR(150) URL to poster image vote average FLOAT Average user rating --- Repository Structure - database.sql : Schema setup and transaction settings - dates.sql : Date-dimension table for advanced time analytics - moviedb.sql : Dump o","default_branch":null,"files":null,"tree":[],"storefront":"/r/bocaletto-luca","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/bocaletto-luca/Movies-Database/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."}