Simply Jonathan

User-defined Order in SQL 

Permanent location of 'User-defined Order in SQL'

This is the sort of problem which on the surface seems so simple, but where the immediate solution is so wasteful, and can indeed be hard to pull off; my side project Oversigter has been doing this incorrectly for years.

The solution is elegant, although it can be difficult to pull off in practice if you don’t have a lot of control over your hosting environment, as I don’t where Oversigter is hosted.

Via [Simon Willison][simonw]

People vs. persons 

Permanent location of 'People vs. persons'

From the department of language, here is a guide on when to use “persons” and when to use “people”. (Brief version: use “persons” if you want to seem formal, but “people” in most other cases.)

This is Simply Jonathan, a blog written by Jonathan Holst. It's mostly about technical topics (and mainly the Web at that), but an occasional post on clothing, sports, and general personal life topics can be found.

Jonathan Holst is a programmer, language enthusiast, sports fan, and appreciator of good design, living in Copenhagen, Denmark, Europe. He is also someone pretentious enough to call himself the 'author' of a blog. And talk about himself in the third person.