Course list

Blog

  • Three Pythonic products: A (free) Webinar, a course, and an ebook

    I love developing software.  I also love helping people to learn how to develop better. That’s why I have been teaching programming classes for more than a decade, and why I write about programming. There is so much to learn; it’s a rare day on which I don’t learn something new, and it’s a rare…

    Read more

  • The easiest way to return to the last Git branch

    I don’t know about you, but it’s common for me to switch between branches in Git.  After all, that’s one of the main advantages of using Git — the incredible ease with which you can create and merge branches. Just a few minutes ago, I was in the “adwords” branch of an application I’m working…

    Read more

  • Remember: Don’t mix = and NULL

    I was recently performing an analysis on the database for my dissertation software, and wanted to look at one particular set of rows.  The table I was looking at is called Nodes, and because each node (represented by a row in the table) can optionally belong to a group, the group_id column allows for NULL…

    Read more

  • Book Review: The Undercover Economist Strikes Back

    In order to get an undergraduate degree from MIT, at least when I was there, you needed to take a certain number of humanities and social-science courses.  This was to stop you from coming out a complete one-dimensional student; the idea was that rounding out your education with knowledge from other fields was good for…

    Read more

  • Turning a PostgreSQL array to rows

    Bottom line: To turn a PostgreSQL array into rows, wrap the column in the UNNEST function: SELECT UNNEST(stuff) FROM foo. Each element of the array becomes its own row, which you can then join, filter, or feed into INTERSECT and UNION. Wrap the whole query in ARRAY(…) to pack the rows back into an array.…

    Read more

  • Turning PostgreSQL rows into arrays

    The short version: To turn a set of PostgreSQL rows into an array, wrap a subselect in the ARRAY function: SELECT ARRAY(SELECT description FROM Appointments). It returns one row with one array, holding one element per input row. Wrap that in array_to_string(…, ‘, ‘) to get a comma-separated string, and use AS to give the…

    Read more

  • 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 dimensions. But one of the most common actions that we’ll want to do with an array is look inside to see if a particular value…

    Read more

  • 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 developer to help them.  Frustrated with their inability to find someone who can commit to their project, my friends have decided to hire offshore developers, which…

    Read more

  • 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 the ARRAY construction syntax.  In this post, I want to talk about PostgreSQL indexes and length — what happens when we retrieve from indexes that exist (and…

    Read more

  • 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 it comes to database design and storage; and the idea of putting multiple values inside of a single column struck me as particularly foolish.  Besides,…

    Read more