sqlite-http
sqlite-http copied to clipboard
asg017
A SQLite extension for making HTTP requests purely in SQL
```sql .load http0 insert into http_clients(name, headers, rate_limit) select 'github_api', http_headers('User-Agent', 'xxx/1.0.0', 'X-Api-Key', '...'), 100; select http_get( 'https://api.github.com/....', null, null, null, json_object('client', 'github_api') ); ```
to parse common headers date formated as `Tue, 26 Oct 2021 05:15:58 GMT` sqlite datetime can't parse this on it's own, so it's annoying. this func would format it for...
new `redirect_info` column in do table? JSON of url, response status code? Oh, maybe have a setting that makes the table function return > 1 row, each with every redirect?...
`net/http` [Response](https://pkg.go.dev/net/http#Response) has [TLS info](https://pkg.go.dev/crypto/tls#ConnectionState), which points to [x509 cert](https://pkg.go.dev/crypto/x509#Certificate) Open questions: - [ ] Are there security risks with the cert itself? - [ ] would metadata be needed,...
https://stackoverflow.com/questions/54930751/how-to-get-x509-certificate-from-http-client-in-go `response_certificate` ? are there security risks in doing this? are certificates really large? does HAR files do this as well? Is there any point in including it? would probably...
Should a failed request cause a `SQLITE_ERROR`, or should a user be able to specify what to do on failure? Can set all `request_*` columns to `NULL`. - [ ]...
- [ ] Export a do table to HAR blob - [ ] Import a HAR file to a do table - [ ] Create HAR in scalar function. ```sql...
- [ ] `http_cookies_each` - [ ] `http_cookies_set` - [ ] `http_cookies_replace` - [ ] `http_cookies_remove` - [ ] `http_cookies_name` - [ ] `http_cookies_value` - [ ] `http_cookies_expires` - [...
- [ ] `http_headers_set` - [ ] `http_headers_replace` - [ ] `http_headers_remove`