tursodatabase/libsql

Switch to locking_mode EXCLUSIVE in libSQL server?

Open

#1,630 opened on Aug 3, 2024

View on GitHub
 (2 comments) (1 reaction) (0 assignees)C (16,744 stars) (490 forks)batch import
enhancementhelp wantedquestion

Description

SQLite acquires a POSIX advisory lock by default for every read transaction. Let's consider switching to PRAGMA locking_mode=EXCLUSIVE to make SQLite acquire the POSIX advisory lock when a database file is opened, which improves read performance.

Contributor guide

Tech stack
c
Domain
backenddatabaseperformance
Issue type
performance
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
C programmingSQLite internalsPOSIX advisory locks
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
45
Research direction
Investigate where the SQLite database connection is opened in libSQL server code (likely in files handling database initialization). Evaluate the impact of switching to PRAGMA locking mode=EXCLUSIVE on read performance and compatibility with concurrent writes. Consider any trade offs and test with existing benchmarks.