max/YouTube-Manager
1
0
Fork 0
Code Issues 4 Pull Requests Actions Packages Projects 1 Releases Wiki Activity

[Data] Setup database #2

New Issue
Closed
opened 2025-08-04 19:45:03 +02:00 by max · 0 comments
max commented 2025-08-04 19:45:03 +02:00
Owner
Copy Link

The database is SQLite, this is to keep the library and db close to each other.
Initial setup for entities and contexts.

  • Setup EF Core
  • Setup SQLite package

Application db

- [ ] Jobs of app that are running or executed

  • Settings/config

Library db entities

  • YouTube clients (accounts)

    • Id
    • Cookies (table)
    • Name
    • Added date
    • Modified date
    • Playlists

  • Http cookies

    • Name
    • Value
    • Domain
    • Path
    • Expires
    • Secure
    • HttpOnly
    • SameSite
    • AddedDate
    • ModifiedDate
    • Client id

  • Playlists

    • Id
    • Name
    • Description
    • Added date
    • Modified date
    • CreatedDate
    • ChannelId

  • Channels

    • Id
    • Name
    • Picture -> Disk
    • Description
    • Joined date
    • Added date
    • Modified date

  • Media info/metadata

    • Id
    • Title
    • Description
    • Upload date
    • ChannelId (Link to Channels table)
    • Added date
    • Modified date
    • State - Video online, removed, hidden, etc.
    • Localized - Media is downloaded to disk
    • LocalizedResolution
    • Formats (media format table)

  • Media format

    • Quality
    • IsAdaptive
    • MimeType - Audio/Video mp4/webm codecs
    • Bitrate
    • AverageBitrate
    • LastModified
    • ContentLenght
    • ApproxDurationMs
    • Width
    • Height
    • Fps
    • QualityLabel
    • ProjectType
    • AudioChannels
    • AudioSampleRate
    • LoudnessDb
    • Audio track info - (name, id, isDefault, autoDubbed)

  • Media captions

    • MediaId
    • Name
    • CaptionPath
    • LanguageCode
The database is SQLite, this is to keep the library and db close to each other. Initial setup for entities and contexts. - [X] Setup EF Core - [X] Setup SQLite package ### Application db ~~- [ ] Jobs of app that are running or executed~~ - [X] Settings/config ### Library db entities - [X] YouTube clients (accounts) - Id - Cookies (table) - Name - Added date - Modified date - Playlists - [X] Http cookies - Name - Value - Domain - Path - Expires - Secure - HttpOnly - SameSite - AddedDate - ModifiedDate - Client id - [X] Playlists - Id - Name - Description - Added date - Modified date - CreatedDate - ChannelId - [X] Channels - Id - Name - Picture -> Disk - Description - Joined date - Added date - Modified date - [X] Media info/metadata - Id - Title - Description - Upload date - ChannelId (Link to Channels table) - Added date - Modified date - State - Video online, removed, hidden, etc. - Localized - Media is downloaded to disk - LocalizedResolution - Formats (media format table) - [X] Media format - Quality - IsAdaptive - MimeType - Audio/Video mp4/webm codecs - Bitrate - AverageBitrate - LastModified - ContentLenght - ApproxDurationMs - Width - Height - Fps - QualityLabel - ProjectType - AudioChannels - AudioSampleRate - LoudnessDb - Audio track info - (name, id, isDefault, autoDubbed) - [X] Media captions - MediaId - Name - CaptionPath - LanguageCode
max added the
Priority
High
2
Kind/Enhancement
Compat/Breaking
 labels 2025-08-04 19:45:03 +02:00
max added this to the YouTube Manager project 2025-08-04 19:45:03 +02:00
max moved this to Backlog in YouTube Manager on 2025-08-04 19:45:05 +02:00
max self-assigned this 2025-08-04 20:00:57 +02:00
max changed title from Setup database to [YtMiner] Setup database 2025-08-04 20:02:03 +02:00
max added this to the Initial setup milestone 2025-08-04 20:03:10 +02:00
max added
Priority
Critical
1
 and removed
Priority
High
2
 labels 2025-08-10 21:28:49 +02:00
max changed title from [YtMiner] Setup database to [Data] Setup database 2025-08-10 22:45:06 +02:00
max moved this to In progress in YouTube Manager on 2025-08-11 00:44:59 +02:00
max closed this issue 2025-08-17 18:55:07 +02:00
max moved this to Done in YouTube Manager on 2025-08-17 18:55:13 +02:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
Kind/Bug
Something is not working
Kind/Documentation
Documentation changes
Kind/Enhancement
Improve existing functionality
Kind/Feature
New functionality
Kind/Security
This is security issue
Kind/Testing
Issue or pull request related to testing
Priority
Critical
1
The priority is critical
Priority
High
2
The priority is high
Priority
Low
4
The priority is low
Priority
Medium
3
The priority is medium
Reviewed
Confirmed
1
Issue has been confirmed
Reviewed
Duplicate
2
This issue or pull request already exists
Reviewed
Invalid
3
Invalid issue
Reviewed
Won't Fix
3
This issue won't be fixed
Status
Abandoned
3
Somebody has started to work on this but abandoned work
Status
Blocked
1
Something is blocking this issue or pull request
Status
Need More Info
2
Feedback is required to reproduce issue or to continue work
No Label
Compat/Breaking
Kind/Enhancement
Priority
Critical
1
Milestone
No items
No Milestone Initial setup
Projects
Clear projects
No project YouTube Manager
Assignees
Clear assignees
max
No Assignees max
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: max/YouTube-Manager#2
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?