alexgarcia-xyz

8 ms·

61.
by alexgarcia-xyz 4y ago
I think you're right, tho not an expert with multiple connections. I think if the DB is in WAL mode and you're only issuing read-only requests, then there will be no lock and long HTTP requests won't lock anything up. But if
62.
by alexgarcia-xyz 4y ago
Yup, if it hits https://httpbin.org/delay/10 then the entire script will delay for 10 seconds (unless you have a custom lower timeout setting). Which means you can only make HTTP requests in serial requests, which suck
63.
by alexgarcia-xyz 4y ago
Hey thanks for sharing! Re infering schema of input JSON: That would be slick! Though SQLite does have some limitations here with table-valued functions vs virtual table. I won't go into the specifics, but something like this isn'
64.
by alexgarcia-xyz 4y ago
This has been done by other people already! - https://github.com/jvail/spl.js - https://observablehq.com/@visionscarto/hello-spl-js
65.
by alexgarcia-xyz 4y ago
Hmm, so you have lines that have fields in fixed indexed positions? Maybe something line this: $ cat hn.txt 11alex a 12brian b 12craig c $ cat test.sql .header on .mode box .load dist/lines0 select subst
66.
by alexgarcia-xyz 4y ago
Hey, author here, happy to answer any questions! Also checkout this notebook for a deeper dive into sqlite-lines, along with a slick WASM demonstration and more thoughts on the codebase itself https://observablehq.com/@asg01
67.
by alexgarcia-xyz 5y ago
hey author here, you're right, completely missed adding a permissive license. Just added an explicit MIT license with the latest version, thanks for bringing it up!