Hello, sql.js-httpvfs | Max Bo | Observable
•ojs
•ojs
↯ database
↪︎ output
•sql
↯ database
↪︎ output
•sql
↯ database
↪︎ output
•sql
•ojs
•ojs
↯ database
↪︎ output
•sql
•ojs
•ojs
•ojs
Comments (4)
Max Bo
May 3, 2022
Ideally we'd be able to interpolate a list and have it expand out into a `(?, ?, ?)`, but Observable's `SQLiteDatabaseClient.sql` tag function [doesn't support](
https://github.com/observablehq/stdlib/blob/8c0110cd0d10ba46fd4bfb3ea723b7b9c6971a11/src/sqlite.js#L42
) this. Instead we have to use `instr` substring check rather than using the `in` set membership operator.
Reply
Simon Willison
Jan 2, 2023
It seems to be working for me right now in Mobile Safari on iOS 16.1.1.
Max Bo
Jan 2, 2023
Hmm curious `RuntimeError: A network error occurred.` is thrown on Safari iOS 15.6.1 and Chrime iOS. Might be fixed in 16.
Max Bo
Jan 3, 2023
Confirmed working on iOS 16! Notice updated.
Reply
Add comment
Subscribe to notifications
4
4
Hello, sql.js-httpvfs | Max Bo | Observable