SQLite Capabilities Report

Generated by testsqlite.php (c)2025 Scott G. Williams

SQLite Version

sqlite_version()3.45.2
sqlite_source_id()2024-03-12 11:06:23 d8cd6d49b46a395b13955387d05e9e1a2a47e54fb99f3c9b59835bbefad6alt1
THREADSAFE1

PHP Extensions

sqlite33.45.2
pdo_sqliteenabled

Key Pragmas

page_size4096
cache_size-2000
encodingUTF-8
foreign_keys0

SearchKit Crawl Mode Fall Back Test

CLI PHP Path/usr/local/bin/php
CLI PDO_SQLITE Test Cmd/usr/local/bin/php -r "try { new PDO('sqlite::memory:'); echo 'OK'; } catch (Exception $e) { echo 'FAIL'; }"
CLI PDO_SQLITEYES
Recommended ModeAsync CLI: Default (recommended for large sites)
CLI Test ResultOK
CLI Test Notesunknown

Full-Text Search & Modules

FTS5 available?YES
FTS4 available?YES
FTS3 available?YES
R*Tree available?YES
R*Tree (i32) available?YES
JSON1 available?YES sample: {"a":1}
ICU extension?Not detected
SQLCipher?Not detected

Registered Virtual Table Modules

Compile Options