Skip to content
Script to import youtube-dl metadata to PostgreSQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE
README.md
import.py
requirements.txt
schema.sql

README.md

yt-metadata

Script to import youtube-dl metadata to PostgreSQL.
The actual .jpg files for the thumbnails are saved into the database as byte arrays (Only the default thumbnail saved by youtube-dl)

Scraping metadata using youtube-dl

This tool expects the files to be in the format that this bash script will output:

id="$1"
mkdir "$id"; cd "$id"
youtube-dl -v --print-traffic --restrict-filename --write-description --write-info-json --write-annotations --write-thumbnail --all-subs --write-sub --skip-download --ignore-config --ignore-errors --geo-bypass --youtube-skip-dash-manifest https://www.youtube.com/watch?v=$id

Setup instructions:

  • Make sure you have PostgreSQL version >=9.5 installed
  • Create the database and schema with the tool of your choice using schema.sql
  • Change the directory in import.py so it points to the location of your youtube metadata
  • Run import.py

Schema:

schema

You can’t perform that action at this time.