Magic parameter mechanism for embedding text

[simonw]

To help us build SQL interfaces that embed text and then pass the result to the model.

Using this new feature in Datasette core:

• Async support for magic parameters simonw/datasette#2441

[simonw]

Put this in a queries.yml file:

databases:
  content:
    queries:
      embed:
        select :_openaiembeddefault_q

And then:

datasette content.db -c queries.yml -p 8003 -s plugins.datasette-embeddings.api_key "$(jq -r '.openai' "$(dirname "$(llm logs path)")/keys.json")"

And now: http://127.0.0.1:8003/content/embed?q=hello

[simonw]

I wish I could put extra underscores in the parameter names. This is a bit ugly.