[serendipity-cvs] [s9y/Serendipity] 712681: Support SQLite PRAGMA execution after aquiring a n...

  Branch: refs/heads/master
  Home:   https://github.com/s9y/Serendipity
  Commit: 712681811ff9be17977769e69f0319291ad34a91
      https://github.com/s9y/Serendipity/commit/712681811ff9be17977769e69f0319291ad34a91
  Author: Christian Garbs <[email protected]>
  Date:   2026-08-13 (Thu, 13 Aug 2026)

  Changed paths:
    M include/db/pdo-sqlite.inc.php
    M include/db/sqlite.inc.php
    M include/db/sqlite3.inc.php
    M include/db/sqlite3oo.inc.php

  Log Message:
  -----------
  Support SQLite PRAGMA execution after aquiring a new database connection (#975)

If you want to tune your SQLite database, you have to send some PRAGMA
commands after aquiring a new database connection.

This change introduces a new configuration variable `sqlitePragmas`
that contains multiple SQL commands (an Array of Strings) that are
automatically executed whenever a new SQLite database connection is
aquired.

So for SQLite you could now add something like this to your
`serendipity_config_local.inc.php` to tune your database access:

```php
        // tune SQLite connection parameters after connect
        $serendipity['sqlitePragmas'] = [
                'PRAGMA journal_mode = WAL;',
                'PRAGMA mmap_size    = 16777216;',
                'PRAGMA busy_timeout = 10000;',
        ];
```



To unsubscribe from these emails, change your notification settings at https://github.com/s9y/Serendipity/settings/notifications