summaryrefslogtreecommitdiff
path: root/src/sql
diff options
context:
space:
mode:
authorEuAndreh <eu@euandre.org>2023-11-16 15:48:12 -0300
committerEuAndreh <eu@euandre.org>2023-11-16 15:51:57 -0300
commitb2b5ba67c25705ddabb7f59baf725604eaf67c04 (patch)
tree96ffbd2b9455965a814cc55ec47b50fbbd213b68 /src/sql
parentMakefile, mkdeps.sh: Enforce JS->native dependency (diff)
downloadpapod-b2b5ba67c25705ddabb7f59baf725604eaf67c04.tar.gz
papod-b2b5ba67c25705ddabb7f59baf725604eaf67c04.tar.xz
Add WIP non-async functions to napi-sqlite.c
Diffstat (limited to 'src/sql')
-rw-r--r--src/sql/config.sql34
-rw-r--r--src/sql/migrations/2023-11-16T15:46:27-03:00-init-auth-data.sql0
2 files changed, 0 insertions, 34 deletions
diff --git a/src/sql/config.sql b/src/sql/config.sql
deleted file mode 100644
index 53eb279..0000000
--- a/src/sql/config.sql
+++ /dev/null
@@ -1,34 +0,0 @@
-; "Litestream requires periodic but short write locks on the database when
-; checkpointing occurs":
-; https://litestream.io/tips/#busy-timeout
-PRAGMA busy_timeout = 5000;
-
-; "Litestream only works with the SQLite WAL journaling mode":
-; https://litestream.io/tips/#wal-journal-mode
-PRAGMA journal_mode = WAL;
-
-; "(...) change the synchronous mode to NORMAL (it typically defaults to FULL)":
-; https://litestream.io/tips/#synchronous-pragma
-; "WAL mode is safe from corruption with synchronous=NORMAL":
-; https://www.sqlite.org/pragma.html#pragma_synchronous
-PRAGMA synchronous = NORMAL;
-
-; "(...) can perform a checkpoint in between Litestream-initiated checkpoints
-; and cause Litestream to miss a WAL file":
-; https://litestream.io/tips/#disable-autocheckpoints-for-high-write-load-servers
-PRAGMA wal_autocheckpoint = 0;
-
-; "This pragma does a low-level formatting and consistency check of the
-; database":
-; https://www.sqlite.org/pragma.html#pragma_integrity_check
-PRAGMA integrity_check;
-
-; "The foreign_key_check pragma checks the database, or the table called
- \"table-name\", for foreign key constraints that are violated":
-; https://www.sqlite.org/pragma.html#pragma_foreign_key_check
-PRAGMA foreign_key_check;
-
-
-CREATE TABLE IF NO EXISTS migrations (
- name TEXT PRIMARY KEY
-);
diff --git a/src/sql/migrations/2023-11-16T15:46:27-03:00-init-auth-data.sql b/src/sql/migrations/2023-11-16T15:46:27-03:00-init-auth-data.sql
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/src/sql/migrations/2023-11-16T15:46:27-03:00-init-auth-data.sql