Expanding JSON arrays to rows with SQL on RedShift

12 December 2013  —  Torsten Becker

Amazon's RedShift is a really neat product that solves a lot of our problems at work. However, its SQL dialect has some limitations when compared to Hive or PostgresSQL. I hit a limit when I needed table-generating functions but found a work-around. Learn how…

Patching PgBouncer to Drop Slow Queries

17 September 2013  —  Hans Hasselberg & Torsten Becker

The other day my friend and colleague Hans was troubleshooting problems with one of our production PostgreSQL databases at 6Wunderkinder. The master was under high load and slowed down the whole system. So we needed to figure out why this happened and fix the problem. Read more…