skycatminepokie / autocut

Cut videos based on your gameplay!
MIT License
1 stars 0 forks source link

Create database format #1

Closed skycatminepokie closed 1 month ago

skycatminepokie commented 1 month ago

When and how databases are going to be accessed

skycatminepokie commented 1 month ago

Databases will be stored as .minecraft/autocut/recordings/StartDate_Time.sqlite Databases will be accessed via a RecordingManager (rename from Recording) Databases will have two tables:

CREATE TABLE clips (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    start_timestamp INTEGER,
    end_timestamp INTEGER,
    type TEXT,-- expected to be an Identifier
    description TEXT
);
CREATE TABLE events (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp INTEGER,
    type TEXT,-- expected to be an Identifier
    meta TEXT
);
skycatminepokie commented 1 month ago

We'll start without the meta for now.