Tag: sql

Uniquely Identify Me

I recently revisited the landscape for autonomous and uncoordinated identity generation. I came across a couple of criticisms on the use of UUID's and I wanted to explore and validate those criticisms.

More... | Comment

Dropwizard Database Migrations

Database migrations are a way to programmatically manage, apply and track changes to a databases schema.

More... | Comment

Calendar Tables in PostgreSQL

Hadoop and MapReduce has made data warehousing all the rage but, don't give up on the trusty old RDBMS. Learn how to populate a calendar table using only PostgreSQL built-in features.

More... | Comment

Dance and Pivot SQL Style

More... | Comment