Archive for October, 2019

Home » October 2019

Rarely Used But Useful PostgreSQL Features

I'm an avid user of SQL and the variety of - frequently overlooked - features it provides. However, unfortunately the possibilities of SQL and modern, advanced open source incarnations of RDBMS such as PostgreSQL aren't utilised to the extent they could be when developing web or enterprise applications today. More often than not SQL database are perceived as a mere data store for persisting object-oriented data, which can give rise to the famous object-relational impedance mismatch. SQL servers, PostgreSQL in particular, are capable ... Read more

Imagination, Desire and the Call of the Future – David Delgado @ beyond tellerrand 2019

Imagination, Desire and the Call of the Future - David Delgado from beyond tellerrand on Vimeo. Read more

Boring Solutions Revisited: Choose Boring Technology by Dan McKinley

Dan McKinley's article on choosing boring solutions, although not exactly new anymore, has been a welcome reminder for me to revisit the topic of of using boring solutions and keeping things simple. Dan makes the point that "adding technology to your company comes with a cost" or as I stated in my own article on this subject: "The elephant in the room is: There’s an opportunity cost to everything." Most choices come with a trade-off. If you decide to use a technology for the ... Read more

Jess Frazelle: “For the Love of Pipes”

Somewhat recently, Jess Frazelle wrote about her love of UNIX pipes, a sentiment I wholeheartedly share, to the extent that I think web apps should behave more like Unix programs by making data readily available via APIs so other applications can easily process that data. This, in a nutshell, is the Unix philosophy as stated by Doug McIlroy: Make each program do one thing well. To do a new job, build afresh rather than complicate old programs by adding new "features". Expect the output ... Read more