← writing

These girls...

2011-11-07

are loved.

Sistersmiles

Sistersreading

Archived from the old tylerhannan.com blog. Originally published 2011-11-07.

:) WITH (SELECT embedding FROM posts WHERE path = '/2011/11/these-girls/') AS this_post SELECT round(1 - cosineDistance(embedding, this_post), 2) AS similarity, title, path FROM posts WHERE path != '/2011/11/these-girls/' ORDER BY similarity DESC, path LIMIT 5;
similaritytitlepath
0.63RIP, MCA/2012/05/rip-mca/
0.62My Family (a bit of shameless pride)/2009/11/my-family-a-bit-of-shameless-pride/
0.62Aoife Liron Hannan: a surgical pictorial/2011/07/aoife-liron-hannan-a-surgical-pictorial/
0.62Thank You For Your Service/2012/12/thank-you-for-your-service/
0.60Brand Recognition: or kids say the darndest things/2009/06/brand-recognition-or-kids-say-the-darndest-things/

5 rows in set. Each post's embedding is from EmbeddingGemma 2, made with ClickHouse's aiEmbed.

Contact

tyler@tylerhannan.com linkedin x / twitter