libsql icon indicating copy to clipboard operation
libsql copied to clipboard

query parameter support?

Open dezren39 opened this issue 2 years ago • 2 comments

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]:

dezren39 avatar Jan 06 '24 03:01 dezren39

hey @dezren39, Can you share a minimal code sample that reproduces?

MarinPostma avatar Jan 08 '24 15:01 MarinPostma

I can try! For my purposes I had just replaced with an empty string and moved on. This is on my other laptop so I can't right now.

dezren39 avatar Jan 08 '24 17:01 dezren39