We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
https://github.com/simonw/datasette/blob/0b4a28691468b5c758df74fa1d72a823813c96bf/datasette/filters.py#L313-L324 does json_each to test array membership.
json_each
This is, of course, the right way to do it.
...but probably we would get by just fine if we did column like '%"string-value"%, which seems to be 3x faster:
column like '%"string-value"%
json_each query
yolo everything is a string query
The text was updated successfully, but these errors were encountered:
ddfcba2
No branches or pull requests
https://github.com/simonw/datasette/blob/0b4a28691468b5c758df74fa1d72a823813c96bf/datasette/filters.py#L313-L324 does
json_each
to test array membership.This is, of course, the right way to do it.
...but probably we would get by just fine if we did
column like '%"string-value"%
, which seems to be 3x faster:json_each query
yolo everything is a string query
The text was updated successfully, but these errors were encountered: