← writing

Payments, Software & Technology - October 14, 2009

2009-10-14

Archived from the old tylerhannan.com blog. Originally published 2009-10-14.

:) WITH (SELECT embedding FROM posts WHERE path = '/2009/10/payments-software-technology-october-14-2009/') AS this_post SELECT round(1 - cosineDistance(embedding, this_post), 2) AS similarity, title, path FROM posts WHERE path != '/2009/10/payments-software-technology-october-14-2009/' ORDER BY similarity DESC, path LIMIT 5;
similaritytitlepath
0.83Payments, Software & Technology - January 7, 2010/2010/01/payments-software-technology-january-7-2010/
0.82Payments, Software & Technology - November 18, 2009/2009/11/payments-software-technology-november-18-2009/
0.81Payments, Software, Technology - February 24, 2010/2010/02/payments-software-technology-february-24-2010/
0.80Payments, Software, Technology on March 14, 2010/2010/03/payments-software-technology-on-march-14-2010/
0.80Payments, Software, Technology on September 29, 2010/2010/09/payments-software-technology-on-september-29-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