I've been having a good time with this vs code plugin for viewing and editing sqlite db files: https://marketplace.visualstudio.com/items?itemName=yy0931.vscode

I've been having a good time with this vs code plugin for viewing and editing sqlite db files: https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor https://marketplace.visualstudio.com/items?itemName=yy0931.v... I have also found the CHECK constraint on an INTEGER column to serve well as an ENUM: https://stackoverflow.com/questions/5299267/how-to-create-enum-type-in-sqlite https://stackoverflow.com/questions/5299267/how-to-create-en... For dates I happily use unix epoch integers or iso8601 date strings.