Page 23 of 178

Avoid “VARCHAR” columns in PostgreSQL [PGSQL Phriday #006]

This is a response to Grant. This is one thing I wish I knew while learning PostgreSQL: Don’t ever use the VARCHAR column type. I have never encountered a situation where that would have been superior to using TEXT. The problem with VARCHAR column type is that it can be a fixed-width column that doesn’t […]

Continue reading →

Two-flat journal 8: Adding a third unit

Over the years I waffled once or twice about adding a third unit, in the basement. I hired a structural engineer to draw up plans for the replacement center beam in the basement’s ceiling. To “future proof” the plans, I also asked him to draw a plan and create specifications for a floor excavation in […]

Continue reading →

A short list of features of the Netherlands that I still try to wrap my head around

The Netherlands is the country I’ve visited the most, going there eight times between 2011 and 2022. I’ve obsessively visited 31 cities, the Hoge Veluwe national park, and plenty of other places outside cities. Here are three land use and infrastructure characteristics that continue to fascinate me. Transportation systems, obviously Learning about how the Dutch […]

Continue reading →

Chicago’s massive parking footprint – as measured on December 30, 2022

It’s been three years since I last measured how much of Chicago’s land area is occupied by parking lots and parking garages. On December 25, 2019, using data drawn into OpenStreetMap by volunteers including myself, 2.5 percent of Chicago was for car parking. Based on additional data since then, the land area of Chicago occupied […]

Continue reading →

Automatically post your Flickr photos to your Mastodon account

One process I’ve relied on in the past to keep my Twitter postings fresh is automatically cross-posting photos that I upload to Flickr to Twitter. This is done through Zapier and inspired by this answer in their forums. Zapier currently doesn’t have any Mastodon integrations, but it’s possible to use Mastodon’s API and Zapier’s webhook […]

Continue reading →