Support for read-only databases in the Rust crate

Description

This issue does not include a description.

Contributor guide

Tech stack

rustsql

Domain

databasebackend

Issue type

feature

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.

fresh

ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.

unclear

Prerequisites

Rust knowledgeFamiliarity with libsql crate

Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.

40

Research direction

The issue lacks a description and comments are not provided. To implement read only database support, first examine the existing Rust crate source code at `libsql/src/` and the underlying C API for SQLite's `sqlite3 open v2` with `SQLITE OPEN READONLY`. Look for any existing discussions in the comments on the issue (if available) for specific requirements. A starting point would be to create a new method or modify the `Database::open` to accept a read only flag. The PR should include tests for read only operations and ensure that write operations fail gracefully.