3 ms·
On SSRF: There is a "no network"[0] option for the extension, if you don't trust SQL input. This is what the example Datasette server[1] uses Also to note, thi
by alexgarcia-xyz 4y ago
On SSRF: There is a "no network"[0] option for the extension, if you don't trust SQL input. This is what the example Datasette server[1] uses
Also to note, this is mainly meant for use with local data processing, I doubt there's a need for sqlite-http in a SQLite DB used in regular applications. If you're just wrangling some data locally with SQLite with these extensions, I doubt there's much of a security risk
[0] https://github.com/asg017/sqlite-http/blob/main/docs.md#no-net https://github.com/asg017/sqlite-http/blob/main/docs.md#no-n...
[1] https://sqlite-extension-examples.fly.dev/data?sql=select+*+from+pragma_function_list%0D%0Awhere+name+like+%27http%25%27 https://sqlite-extension-examples.fly.dev/data?sql=select+*+...
- hsbauauvhabzb 4y agoSo your basing your security model on the assumption that developers won’t use it for things you never intended it to be used for?
- simonw 4y agoI think that's absolutely fine. The creators of Python still released Python, even though people could use it to build insecure software.