5 ms·

hey, I just tested and `NORMAL` is default: $ sqlite3 test.db SQLite version 3.43.2 2023-10-10 13:08:14 Enter ".help" for usage hints. sql

hey, I just tested and `NORMAL` is default: $ sqlite3 test.db SQLite version 3.43.2 2023-10-10 13:08:14 Enter ".help" for usage hints. sqlite> PRAGMA journal_mode=wal; wal sqlite> PRAGMA synchronous; 1 sqlite> edit: fresh installation from homebrew shows default as FULL: /opt/homebrew/opt/sqlite/bin/sqlite3 test.db SQLite version 3.50.4 2025-07-30 19:33:53 Enter ".help" for usage hints. sqlite> PRAGMA journal_mode=wal; wal sqlite> PRAGMA synchronous; 2 sqlite> I will update the post, thanks!

eatonphil 1y ago
Is this sqlite built from source or a distro sqlite? It's possible the defaults differ with build settings.
- supriyo-biswas 1y ago
  The one which avinassh shows is MacOS's SQLite under /usr/bin/sqlite3. In general it also has some other weird settings, like not having concat() method, last I checked.
  - ncruces 1y ago
    The Apple built macOS SQLite is something. Another oddity: misteriously reserving 12 bytes per page for whatever reason, making databases created with it forever incompatible with the checksum VFS. Other: having 3 different layers of fsync to avoid actually doing any F_FULLFSYNC ever, even when you ask it for a fullfsync (read up on F_BARRIERFSYNC).
  - zimpenfish 1y ago
    > it also has some other weird settings You also can't load extensions with `.load` (presumably security but a pain in the arse.) user ~ $ echo | /opt/homebrew/opt/sqlite3/bin/sqlite3 '.load' [2025-08-25T09:27:54Z INFO sqlite_zstd::create_extension] [sqlite-zstd] initialized user ~ $ echo | /usr/bin/sqlite3 '.load' Error: unknown command or invalid arguments: "load". Enter ".help" for help
larschdk 1y ago
Just checked debian/ubuntu/alpine/fedora/arch docker images. All are FULL by default.
mediumsmart 1y ago
Same with macports here - 2 (opt/local/bin/sqlite3) and /usr/bin/sqlite3 is 1

eatonphil 1y ago

Is this sqlite built from source or a distro sqlite? It's possible the defaults differ with build settings.

supriyo-biswas 1y ago
The one which avinassh shows is MacOS's SQLite under /usr/bin/sqlite3. In general it also has some other weird settings, like not having concat() method, last I checked.
- ncruces 1y ago
  The Apple built macOS SQLite is something. Another oddity: misteriously reserving 12 bytes per page for whatever reason, making databases created with it forever incompatible with the checksum VFS. Other: having 3 different layers of fsync to avoid actually doing any F_FULLFSYNC ever, even when you ask it for a fullfsync (read up on F_BARRIERFSYNC).
- zimpenfish 1y ago
  > it also has some other weird settings You also can't load extensions with `.load` (presumably security but a pain in the arse.) user ~ $ echo | /opt/homebrew/opt/sqlite3/bin/sqlite3 '.load' [2025-08-25T09:27:54Z INFO sqlite_zstd::create_extension] [sqlite-zstd] initialized user ~ $ echo | /usr/bin/sqlite3 '.load' Error: unknown command or invalid arguments: "load". Enter ".help" for help

larschdk 1y ago

Just checked debian/ubuntu/alpine/fedora/arch docker images. All are FULL by default.

mediumsmart 1y ago

Same with macports here - 2 (opt/local/bin/sqlite3) and /usr/bin/sqlite3 is 1