Database

Creating a Massively Scalable Blog with Ghost, MySQL and…

Continuing my little series on “deploying things to Azure with shell scripts” I decided to convert my WordPress script to one for Ghost. It...
Rob Conery
2 min read

Transactional Data Operations in PostgreSQL Using Common Table Expressions

Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within...
Rob Conery
5 min read

Simple Monthly Reports in PostgreSQL Using generate_series

Working with dates and series of dates is easy in PostgreSQL, especially using generate_series.
Rob Conery
3 min read

Setting Up a Fast, Comprehensive Search Routine With PostgreSQL

One of the joys of working with PostgreSQL is the ability to run full-text searches right out of the box. But how do you...
Rob Conery
5 min read

Optimizing a Big RethinkDB Query, and a Correction

Yesterday I wrote a post about how much I liked RethinkDB and people seemed to like it a lot. Particularly the claim I made...
Rob Conery
4 min read

RethinkDB 2.0 Is Amazing

I just turned in my next course for Pluralsight: RethinkDB Fundamentals – almost in time for their announcement that 2.0 has been released. This...
Rob Conery
7 min read
>