---
title: "#212: DynamoDB to Postgres: Why and How"
publication: "Postgres Weekly"
issue: 212
published_at: "2017-06-21"
canonical_url: "https://postgresweekly.com/issues/212"
---

Postgres Weekly 212   . 

[Read this on the Web](http://postgresweekly.com/issues/212) 

[Postgres Weekly](http://postgresweekly.com) Issue 212 — June 21, 2017     

[DynamoDB to Postgres: Why and How](https://containership.engineering/dynamodb-to-postgres-why-and-how-aa891681af4d?utm_source=postgresweekly&utm_medium=email)We’ve seen a number of migrations from MySQL to Postgres and Oracle to Postgres, but this is a newer trend of replacing the popular NoSQL DynamoDB for Postgres. Michael Stoltz [The Future of Querying JSON in Postgres](http://gmile.me/jsonpath/?utm_source=postgresweekly&utm_medium=email)As powerful as JSONB is, when it comes to JSON-focused queries, Postgres could still do with improvements. Here’s a look at some of the user experience around querying JSON and what might be coming. Eugene Pirogov [Because Your Data Is Your Business](http://www.PGExperts.com)PGX's open source experts provide the database and application skills necessary to solve database problems, accelerate existing applications, refactor infrastructure, and develop new applications. PostgreSQL Experts, Inc.​ #sponsored[![\](https://copm.s3.amazonaws.com/bf274a23.png)](http://www.PGExperts.com) [Syncing Redshift and Postgres in Real-Time with Kafka Connect](https://blog.insightdatascience.com/from-postgresql-to-redshift-with-kafka-connect-111c44954a6a?utm_source=postgresweekly&utm_medium=email)Postgres is great as a transactional database, but you may want a data warehouse for reporting. Here Kafka connect helps in connecting the two. Ronak Nathani [Postgres in Production: Lessons Learned the Hard Way:](https://pgconf.us/conferences/2017/program/proposals/lessons-learned-the-hard-way-postgres-in-production-at-gocardless?utm_source=postgresweekly&utm_medium=email)Postgres is the primary store behind GoCardless’s payments API. Here’s a 45 minute talk from PGConf covering some of their ‘war stories’. PostgreSQL Conference#video [Tuning Postgres Queries](https://www.kaoruk.com/posts/06-18-2017-tuning-postgresql-queries?utm_source=postgresweekly&utm_medium=email)A practical walkthrough of going from an ‘EXPLAIN’ plan to improving performance of specific queries within your database. Kaoru Kohashigawa [Real-time monitoring for Postgres (and everything else)](https://www.datadoghq.com/lpgpts2/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyS)Monitor Postgres databases and 200+ other technologies. See metrics and traces from every part of your stack. Datadog#sponsored [Postgres Transactions Aren’t Fully Isolated](http://malisper.me/postgres-transactions-arent-fully-isolated/?utm_source=postgresweekly&utm_medium=email)This first in a series starts to dig into the semantics of isolation levels and how you can reason about them as a developer. Michael Malis [PostgreSQL Cheat Sheet: The Basics](https://blog.knoldus.com/2017/04/30/postgresql-cheat-sheet-basics/?utm_source=postgresweekly&utm_medium=email) Sahil Sawhney    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/212) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK