At carwow, we load all our production Postgres databases into a data warehouse daily; the process is pretty much:

1. Use COPY FROM to extract the data as a CSV
2. Split the CSV into roughly evenly-sized, gzipped chunks

Most Rails apps start life with a single relational database (generally PostgreSQL or MySQL), which are great for many purposes, but can get pretty slow when doing unstructured searches over huge datasets. When you hit this kind of problem, it’s time…

One of the cool things about Redshift is that it’s kinda like PostgreSQL, but can…

Image resizing is often a pretty important (but not often thought about) feature for many websites. We all want to make pages load fast and look good, and that means sending images at the size they’re going to be displayed, and hopefully…