diff options
| author | EuAndreh <eu@euandre.org> | 2023-11-16 15:48:12 -0300 |
|---|---|---|
| committer | EuAndreh <eu@euandre.org> | 2023-11-16 15:51:57 -0300 |
| commit | b2b5ba67c25705ddabb7f59baf725604eaf67c04 (patch) | |
| tree | 96ffbd2b9455965a814cc55ec47b50fbbd213b68 /src/sql | |
| parent | Makefile, mkdeps.sh: Enforce JS->native dependency (diff) | |
| download | papod-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.sql | 34 | ||||
| -rw-r--r-- | src/sql/migrations/2023-11-16T15:46:27-03:00-init-auth-data.sql | 0 |
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 |
