tursodatabase / tursodatabase/libsql

query parameter support?

Open
#864 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C
Stars
17.2k
Forks
531
Avg merge
1h 12m
Merged PRs (30d)
1

Description

hello, I tried using libsql as a drop-in to sqlite

the following suffix caused errors

"?_pragma=busy_timeout(5000)&_pragma=foreign_keys(1)"

now i expect i can just remove the suffix, but i was surprised when it errored.

i don't actually whether they are needed

2024/01/05 21:41:28 INFO Opening SQLite db path="data%5Cdb%5Ccharm_sqlite.db?_pragma=busy_timeout%285000%29&_pragma=foreign_keys%281%29" driver=libsql
panic: unknown query parameter "_pragma"

goroutine 1 [running]:

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files or tests are named. Reproduce the panic with the libsql connection URL containing repeated _pragma parameters, then trace where query parameters are validated during database opening. Done means the reported SQLite-compatible suffix has a defined, tested behavior rather than producing the shown unknown-parameter error.

Written by the indexing model from the issue text.

Assessment

Tech stack
sqlite
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.