From 7cbd8fd326339fc7dcc313ba5781534984c299c2 Mon Sep 17 00:00:00 2001 From: Roland Reichwein Date: Fri, 10 Feb 2023 18:22:35 +0100 Subject: Document SQLite handling VARCHAR size --- storage.cpp | 1 + 1 file changed, 1 insertion(+) (limited to 'storage.cpp') diff --git a/storage.cpp b/storage.cpp index f7b8b5d..c5caa79 100644 --- a/storage.cpp +++ b/storage.cpp @@ -14,6 +14,7 @@ Storage::Storage(const Config& config): m_db(config.getDataPath() + "/whiteboard.db3", SQLite::OPEN_READWRITE | SQLite::OPEN_CREATE), m_maxage(config.getMaxage()), + // Note about VARCHAR(N): "SQLite does not impose any length restrictions" m_stmt_create(m_db, "CREATE TABLE IF NOT EXISTS documents (id VARCHAR(16) PRIMARY KEY, value BLOB, rev INTEGER, cursorpos INTEGER, timestamp BIGINT)"), m_stmt_getNumberOfDocuments(m_db, "SELECT COUNT(*) FROM documents"), m_stmt_cleanup(m_db, "DELETE FROM documents WHERE timestamp + ? < ?"), -- cgit v1.2.3