Blog
-
Turning PostgreSQL rows into arrays
So far in this series, I have described how you can create arrays and retrieve information from them — both the actual data stored in the array, and information about
-
Looking in PostgreSQL arrays with ANY
So far, this series has looked at how to create PostgreSQL arrays, how to retrieve data from them, and how to get the length of an array’s outer and inner
-
The real questions to ask offshore developers
Friends of mine, who are not software developers, have a small, retail Internet business. The original developers created the application in Python, and my friends are looking for a full-stack Web/Python
-
PostgreSQL array indexes and length
In my last blog post, I introduced the idea of a PostgreSQL array, and showed how we can insert data into a table using either the curly-brace {} syntax, or
-
Learning to love PostgreSQL arrays
I’ll admit it: When arrays were added to PostgreSQL a number of years ago, I thought that this was a really bad idea. I’m a firm believer in normalization when
-
Control-R, my favorite Unix shell command
If you use a modern, open-source Unix shell — and by that, I basically mean either bash or zsh — then you really should know this shortcut. Control-R is probably
-
Starting a new software project? Don’t start coding right away.
It’s always fun to start a new project. I should know; I’ve been a consultant since 1995, and have started hundreds of projects of various shapes and sizes. It’s tempting,
-
Summary of my “reduce” series
I teach Ruby and Python to a lot of people — in formal courses, and in one-on-one pairing sessions, both online and in person. I’ve found that for many people,
-
Implementing “filter” with “reduce”, in Ruby and Python
We’re nearly at the end of my tour of the “reduce” function in Ruby and Python. Just as I showed in the previous installment how we can implement the “map”
-
Implementing “map” with “reduce”, in Ruby and Python
This is another installment in my “reduce” series of posts, aimed at helping programmers understand this function, with examples in both Ruby and Python. So far, we have seen how