When and how to JOIN a table with itself
Relational databases make it very easy to join data from different tables, but did you know you can also JOIN data within the same table?
“Heap, Heap, Array!”
Articles about web development and computer programming
How do you number SELECT query results using SQL?
Want to let number or rank your query results? Let your database do the hard work for you.
MDX: The good, the bad, and the ugly
If you have your own blog and like the simplicity of Markdown, but don’t want to give up JSX, you may want to give MDX a try.
Allonsay’s language classification algorithm
How you can detect the language of texts, without using the “ML” word.
Finding the most common words in a set of texts for a word cloud
Alternatively: why word counting is nothing like bean counting.
(Not) looping over lists in PHP
This post discusses three common array functions: map, reduce, and filter.
Datetime formatting in Go
Go’s time package takes a novel approach to defining datetime serialisation formats. Is it an improvement over existing alternatives?