Music DB

From bibbleWiki
Revision as of 21:05, 22 January 2026 by Iwiseman (talk | contribs) (Created page with "=Introduction= Just putting my music in a DB =Database Setup= - Create User - Create DB - Grant Privileges - Create Schema <syntaxhighlight lang="sql"> CREATE TABLE music_metadata ( path TEXT PRIMARY KEY, extension TEXT, song TEXT, artist TEXT, album TEXT, year TEXT, genre TEXT, format TEXT, duration TEXT, size BIGINT, bitrate TEXT, writing_library TEXT, has_cover BOOLEAN, mtime BIGINT, ctime BIGINT, btime B...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Introduction

Just putting my music in a DB

Database Setup

- Create User - Create DB - Grant Privileges - Create Schema

CREATE TABLE music_metadata (
    path TEXT PRIMARY KEY,
    extension TEXT,
    song TEXT,
    artist TEXT,
    album TEXT,
    year TEXT,
    genre TEXT,
    format TEXT,
    duration TEXT,
    size BIGINT,
    bitrate TEXT,
    writing_library TEXT,
    has_cover BOOLEAN,
    mtime BIGINT,
    ctime BIGINT,
    btime BIGINT,
    mediainfo_empty BOOLEAN
);