← writing

Payments, Software, Technology on September 22, 2010

2010-09-22

Archived from the old tylerhannan.com blog. Originally published 2010-09-22.

:) WITH (SELECT embedding FROM posts WHERE path = '/2010/09/payments-software-technology-on-september-22-2010/') AS this_post SELECT round(1 - cosineDistance(embedding, this_post), 2) AS similarity, title, path FROM posts WHERE path != '/2010/09/payments-software-technology-on-september-22-2010/' ORDER BY similarity DESC, path LIMIT 5;
similaritytitlepath
0.86Payments, Software, Technology on September 29, 2010/2010/09/payments-software-technology-on-september-29-2010/
0.85Payments, Software, Technology on December 22, 2010/2010/12/payments-software-technology-on-december-22-2010/
0.81Payments, Software, Technology on November 19, 2010/2010/11/payments-software-technology-on-november-19-2010/
0.80Payments, Software, Technology on July 30, 2010/2010/07/payments-software-technology-on-july-30-2010/
0.79Payments, Software, Technology - February 28, 2010/2010/02/payments-software-technology-february-28-2010/

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

Contact

tyler@tylerhannan.com linkedin x / twitter