sqlite-html
sqlite-html copied to clipboard
asg017
A SQLite extension for querying, manipulating, and creating HTML elements.
- [ ] `select class from html_class_each(doc, selector)` - [ ] `html_class_has(doc, selector, class)` -> 0 or 1
Similar to the `fullkey` / `path` columns in `json_each`/`json_tree`. ```sql sqlite> select fullkey, path, key, value from json_tree('{"sub": {"name": "alex"}}'); ┌────────────┬───────┬──────┬─────────────────────────┐ │ fullkey │ path │ key │ value │...
- [ ] `html_element(tag, attributes, child1, child2, ....)` - [ ] `html_attributes(attr1, attr2, ...)` (or `html_attrs`) - [ ] `html_attribute(name, value, namespace)` (or `html_attr()` ```sql -- https://developer.mozilla.org/en-US/docs/Learn/Getting_started_with_the_web/HTML_basics select html_element('html', null,...
UDFs to manipulate html documents: classes, attributes, children, text content, etc. - [ ] Attributes - [ ] `html_attr_set(doc, selector, name, value)` - [ ] `html_attr_remove(doc, selector, name)` - [...
- [ ] Small selector on large (1M) amount of records - [ ] Big selector on large documents - [ ] `html_each` on large document - [ ] "Real...
`select rank() over (order by rowid) from html_each('', '*');`
html0.dll and http0.dll will not load (win11). ``` SQLite version 3.45.0 2024-01-15 17:01:13 (UTF-16 console I/O) Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME"...
having used this clever extension previously, I run into the following problem using a recent sqlite-cli: ~~~ sqlite> select html('Google'); Runtime error: misuse of sqlite3_result_subtype() by html() ~~~ According to...
