Top all-time · #10059
Jan Kneschke
Personal blog · jan.kneschke.deprogrammingdata
Jan Kneschke writes ~jk, a personal blog at jan.kneschke.de about programming and data. Since 2008, 8 different Hacker News readers have linked it 8 times, most often “ORDER BY RAND()”. The last post was in 2016, but the archive is still widely read.
Too few sampled comments (2) to say how often HN recommends it.?
Why HN links it
HN commenters link Jan Kneschke's posts on asynchronous MySQL queries in C and on PHP tooling, citing them as background for their own points. No comment praises or criticises the writing.
Summarised by Claude from a sample of 2 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
~jk
Most-linked posts?
- ORDER BY RAND()4 people · 4 mentions · first linked 2008-07-31
What Hacker News says?
That looks good, although one may wonder at the long term support prospects (the author says "I'm in the process of transitioning away from PHP to Ruby."). For your delectation, other PHP repls include : - The basic built-in repl "php -a" - Facebooks phpsh : http://phpsh.org/ - PHP Shell : http://jan.kneschke.de/projects/php-shell - php-repl : https://github.com/tailrecursion/wigwam If you want something more custom…
Comment linking /projects/php-shell
on “Boris: A tiny but robust REPL for PHP”Submitted Async MySQL Queries with C-API as a story · 3 points
HN discussionA quick search reveals this post: http://jan.kneschke.de/2008/9/9/async-mysql-queries-with-c-a... with a little more in-depth exploration of the MySQL async API. The problem seems to be that that (undocumented) API does not handle EAGAIN and that there's no way to connect asynchronously (mysql_connnect always blocks). Compare with PostgreSQL, which has had an async API for a long time: http://developer.postgresql.or…
Comment linking /2008/9/9/async-mysql-queries-with-c-api/
on “Chartio develops non-blocking MySQL queries using Tornado”Submitted Don't ORDER BY RAND() as a story · 2 points
HN discussionSubmitted ORDER BY RAND() as a story · 2 points
HN discussion- bd · 2008-07-31
Submitted Efficient random row selection in MySQL as a story · 2 points
HN discussion Submitted SQL Parsing with Parsing Expression Grammars in Lua as a story · 2 points
HN discussionSubmitted ORDER BY RAND() as a story · 1 points
HN discussion