8327 |
Interesting ideas in Observable Framework |
```js echo
const packageName = view(Inputs.select(packages, {
value: "sqlite-utils",
label: "Package"
}));
``` |
https://simonwillison.net/e/8327 |
8327 |
Interesting ideas in Observable Framework |
```js echo
const packages_sql = "select package from stats group by package order by max(downloads) desc"
```
```js echo
const packages = fetch(
`https://datasette.io/content.json?sql=${encodeURIComponent(
packages_sql
)}&_size=max&_shape=arrayfirst`
).then((r) => r.json());
``` |
https://simonwillison.net/e/8327 |
8326 |
Weeknotes: Getting ready for NICAR |
dclient query https://datasette.io/content \
"select * from news limit 3" |
https://simonwillison.net/e/8326 |
8296 |
Embeddings: What they are and why they matter |
select
id,
llm_embed_cosine(
embedding,
(
select
embedding
from
embeddings
where
id = 'sqlite_sqlite-tg.md'
)
) as score
from
embeddings
order by
score desc
limit 5 |
https://simonwillison.net/e/8296 |
8296 |
Embeddings: What they are and why they matter |
select id, hex(embedding) from embeddings |
https://simonwillison.net/e/8296 |
8296 |
Embeddings: What they are and why they matter |
select id, llm_embed_decode(embedding) from embeddings limit 10 |
https://simonwillison.net/e/8296 |
8296 |
Embeddings: What they are and why they matter |
with input as (
select
llm_embed(
'sentence-transformers/TaylorAI/gte-tiny',
:input
) as e
)
select
id,
content
from
embeddings,
input
where
collection_id = (
select id from collections where name = 'functions'
)
order by
llm_embed_cosine(embedding, input.e) desc
limit 5 |
https://simonwillison.net/e/8296 |
8287 |
LLM now provides tools for working with embeddings |
llm embed-multi notes \
-d notes.db \
--sql 'select id, title, body from notes' \
-m sentence-transformers/all-MiniLM-L6-v2 |
https://simonwillison.net/e/8287 |
8284 |
Datasette Cloud, Datasette 1.0a3, llm-mlc and more |
sqlite-utils install sqlite-utils-litecli
sqlite-utils litecli data.db
# ...
Version: 1.9.0
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
data.db> select jq('{"foo": "bar"}', '.foo')
+------------------------------+
| jq('{"foo": "bar"}', '.foo') |
+------------------------------+
| "bar" |
+------------------------------+
1 row in set
Time: 0.031s
|
https://simonwillison.net/e/8284 |
8284 |
Datasette Cloud, Datasette 1.0a3, llm-mlc and more |
sqlite-utils memory "select jq(:doc, :expr) as result" \
-p doc '{"foo": "bar"}' \
-p expr '.foo' |
https://simonwillison.net/e/8284 |