summaryrefslogtreecommitdiff
path: root/etc/init.sql
diff options
context:
space:
mode:
authorEuAndreh <eu@euandre.org>2025-12-01 16:45:28 -0300
committerEuAndreh <eu@euandre.org>2025-12-01 16:45:28 -0300
commit4078b4fe2d46f3b5e58a8fdcf218550d446d9691 (patch)
tree71fc654ceaaf593c7e21531a70e85228b0b2dfd2 /etc/init.sql
parentm (diff)
downloaddatomic-4078b4fe2d46f3b5e58a8fdcf218550d446d9691.tar.gz
datomic-4078b4fe2d46f3b5e58a8fdcf218550d446d9691.tar.xz
m
Diffstat (limited to 'etc/init.sql')
-rw-r--r--etc/init.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/etc/init.sql b/etc/init.sql
new file mode 100644
index 0000000..5c5ef49
--- /dev/null
+++ b/etc/init.sql
@@ -0,0 +1,15 @@
+PRAGMA foreign_keys = ON;
+PRAGMA journal_mode = WAL;
+PRAGMA synchronous = NORMAL;
+PRAGMA mmap_size = 134217728; -- 128 megabytes
+PRAGMA journal_size_limit = 67108864; -- 64 megabytes
+PRAGMA cache_size = 2000;
+
+-- datomic schema
+CREATE TABLE IF NOT EXISTS datomic_kvs (
+ id TEXT NOT NULL,
+ rev INTEGER,
+ map TEXT,
+ val BYTEA,
+ CONSTRAINT pk_id PRIMARY KEY (id)
+);