Skip to content

Instantly share code, notes, and snippets.

@patrickwolf
patrickwolf / sqlite3_wan_concurrent_use_sample.py
Created May 31, 2025 22:56
SQLite3's Write-Ahead Logging (WAL) mode - multi thread read/write example
import sqlite3
import threading
import time
import os
import logging
# Configure basic logging
logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(threadName)s - %(message)s')
DB_NAME = "production_wal_app.db"