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 (490 forks)batch import
enhancementhelp wantedquestion

Repository metrics

Stars
 (16,744 stars)
PR merge metrics
 (Avg merge 23h 19m) (1 merged PR in 30d)

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

Research direction
Locate the database initialization code in libsql and add PRAGMA locking mode=EXCLUSIVE after opening the database file, then test read performance.
Tech stack
c
Domain
database
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.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
CSQLite internals
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40