fun

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

A Pure PostgreSQL Document Database API

Another day, another database project in my repo! This time it's a pure PostgreSQL JSONB document storage API that you can drop in and...
Rob Conery
3 min read

The Modern Dev Team

The smallest comment from a good friend can lead to introspecting your life choices. This just happened to me!
Rob Conery
5 min read

How To Learn a New Programming Language While Maintaining…

I don’t typically write “lifehack” posts, but this question has come up repeatedly over the last few weeks: How did you find time to...
Rob Conery
10 min read

Using Recursion In Elixir To Break Your OO Brain

I have to start out each post this way: I have no idea what I’m doing, but dammit am I having fun. In the...
Rob Conery
3 min read

Hello Elixir. Wow.

I don’t know anything about elixir but I very much want to learn it. I like learning new things – I feel it’s required...
Rob Conery
7 min read

PostgreSQL Document API Part 4: Complex Queries

Storing documents in PostgreSQL is a little easier, now that we have some solid save routines, a way to run Full Text searches, and...
Rob Conery
4 min read

PostgreSQL Document API Part 3: Finding Things

In parts 1 and 2 of this little series I showed various ways to save a document and then update its search field. I...
Rob Conery
5 min read

PostgreSQL Document API Part 2: Full Text Search and…

In part 1 of this series I setup a nice save function, as well as another function to create an opinionated document storage table...
Rob Conery
4 min read

Designing a PostgreSQL Document API

PostgreSQL as many know, supports JSON as a storage type and with the release of 9.4, Postgres now supports storing JSON as jsonb –...
Rob Conery
4 min read
>