← writing

Rest In Peace

2011-10-13

#include <stdio.h>

int main() {
    printf("RIP, dmr\n");
    return 0;
}

more information

Archived from the old tylerhannan.com blog. Originally published 2011-10-13.

:) WITH (SELECT embedding FROM posts WHERE path = '/2011/10/rest-in-peace/') AS this_post SELECT round(1 - cosineDistance(embedding, this_post), 2) AS similarity, title, path FROM posts WHERE path != '/2011/10/rest-in-peace/' ORDER BY similarity DESC, path LIMIT 5;
similaritytitlepath
0.75RIP, MCA/2012/05/rip-mca/
0.66Syntax Highlight: a test/2010/07/syntax-highlight-a-test/
0.64Demise of the ISV?/2007/12/demise-of-the-isv/
0.64Thank You For Your Service/2012/12/thank-you-for-your-service/
0.63Commerce in 2008: VeriFone's (PAY) stock plummet is only one part of their upcoming challenges/2008/01/commerce-in-2008-verifones-pay-stock-plummet-is-only-one-part-of-their-upcoming-challenges/

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

Contact

tyler@tylerhannan.com linkedin x / twitter