SQLite3 configuration missed WAL mode

[dukhovnyi]

Expected Behavior

No performance warnings appears.

Current Behavior

Xcode throws warning Reading or writing to a database not configured in WAL mode will perform excessive I/O and reduce the health of storage devices. when Amplitude uses sqlite3_step interface.

Possible Solution

I suppose the SQLString during sqlite3_exec in file should be extended with PRAGMA journal_mode=WAL; to turn on WAL mode.
Consequences of this change should be tracked and tested ...

Steps to Reproduce

1. Install 8.22.0 using Swift Package Manager into existed project.
2. Build project.
3. Observe warnings.

Environment

• SDK Version: 8.22
• Device: iPhone 12+
• OS Version: 18.x
• Xcode: 16.1