Writing
:) WITH
(SELECT embedding FROM request) AS words
SELECT round(1 - cosineDistance(embedding, words), 2) AS similarity, title, date
FROM posts
ORDER BY similarity DESC, path
LIMIT 10;
:) -- not exhaustive. I forget things I've written, sometimes while writing them
SELECT date, title, venue
FROM (
SELECT date, title, 'tylerhannan.com' AS venue FROM posts
UNION ALL
SELECT date, title, venue FROM writing
)
ORDER BY date DESC;
Older posts from the WordPress years, kept so the links still work, plus posts I wrote for other sites (marked ↗). Some of it has aged better than the rest.