Databases

Postgres, MongoDB, DynamoDB and the queries worth keeping.

MongoDB to DynamoDB

8 June, 2016 1 min read 132 words
Moving a large MongoDB dump into DynamoDB with dyngodb2, including the sed passes and file splitting needed to survive the JSON format.

Query of the century

5 February, 2015 1 min read 38 words
One Postgres transaction that swaps a table for a freshly loaded copy: CREATE TABLE LIKE, COPY, two renames and a drop.

Atlassian crowd authentication directory address force update

28 December, 2011 1 min read 54 words
Crowd keeps its directory config in the database, so a migrated Jira or Confluence needs a SQL update to point at the new Crowd URL.