Storing trees in a database table
Relational databases are very good at storing tabular data, but what if you need to store arbitrarily-sized trees?
“Heap, Heap, Array!”
How to deal with Dutch compound words when processing text
The Dutch have a lot of long words that aren’t in dictionaries. But that doesn’t necessarily mean they’re difficult (if you’re Dutch).
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?
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?