21.12.2022, 09:28
Table can be created like this. You will need some clean-up procedure otherwise the database size will keep increasing until it hits a hard limit and some parts of the system won't function properly anymore. For other SQL commands check this: https://sqlite.org/lang.html
Code:
db:query([[
CREATE TABLE IF NOT EXISTS my_config (
key TEXT PRIMARY KEY,
value TEXT
)
]])