← writing

Shared Items - September 12, 2009

2009-09-13

Archived from the old tylerhannan.com blog. Originally published 2009-09-13.

:) WITH (SELECT embedding FROM posts WHERE path = '/2009/09/shared-items-september-12-2009/') AS this_post SELECT round(1 - cosineDistance(embedding, this_post), 2) AS similarity, title, path FROM posts WHERE path != '/2009/09/shared-items-september-12-2009/' ORDER BY similarity DESC, path LIMIT 5;
similaritytitlepath
0.80Shared Items - September 13, 2009/2009/09/shared-items-september-13-2009/
0.80Payments, Software & Technology - November 18, 2009/2009/11/payments-software-technology-november-18-2009/
0.79PCI-DSS: a Podcast Overview/2007/11/pci-dss-a-podcast-overview/
0.79Payment Processing Made Easy: an article/2008/06/payment-processing-made-easy-an-article/
0.79Payments Basics: Commerce Security Fundamentals/2008/07/payments-basics-commerce-security-fundamentals/

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

Contact

tyler@tylerhannan.com linkedin x / twitter