Elf Sternberg

That horrible SQL statement I posted a few days ago? Ignore it completely. A little learning is a dangerous thing, as evidenced here by the realization that I didn’t need to mix in the narrator_children query except to exclude those things that had parents, giving me a perfect query to find parentless (root) objects. My […]

I’ve updated my templating language, tumble. It’s not quite ready for NPM, but it’s getting close. It now handles this case (see if you can guess why I care about this case), in which micro-templates are embeddable and recursable; I’ve put limiters on recursions, both in the database side of the business and on the […]

Seriously, I’m only half-kidding here. This has to be pretty much the most complex SQL command of my career. No, wait, I take that back, I did one even more bizarre for Scilla at IndieFlix once. This is for Narrator 4.0. It’s for Postgres, which supports all sorts of nifty things you won’t find in […]