From 7cbd8fd326339fc7dcc313ba5781534984c299c2 Mon Sep 17 00:00:00 2001
From: Roland Reichwein <mail@reichwein.it>
Date: Fri, 10 Feb 2023 18:22:35 +0100
Subject: Document SQLite handling VARCHAR size

---
 storage.cpp | 1 +
 1 file changed, 1 insertion(+)

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