TIL

My New Reality of Software Engineering Software engineering as a profession is going through an unprecedented phase shift, not just another tool cycle.

motivation At my job recently we had a need to bulk insert lots of records quickly and efficiently, but we had some limitations we needed to work around.

Motivation One of my larger projects at Vendr in the last couple years has been a document extraction system.

Recently, I encountered a situation where I built a search interface for a backend process.

I love using JSON in relational databases.

Recently I had a situation where I needed to process quite a few records, lets say around 100k, and the processing of each record was around 2 seconds.

Lets say you have a table of events, each representing a point in time when an event occurred.

If you know me you’re aware that I love SQL and relational databases.

One thing you’ll want to learn if you use PostgreSQL for any length of time is how to use EXPLAIN.

Something I have a need to do often but can be difficult to do at times in SQL is to create a pivot table.