DB Weekly Issue 156: May 26, 2017

Issue 156 — May 26, 2017

MariaDB TX 2.0: Open Source Database with Enterprise Features — TX packages various MariaDB technology, tools and services into a unified offering, while remaining open source. More here.

Shane Johnson

How Basic Performance Analysis on a Postgres Cluster Saved Millions — A look at how some performance analysis using flame graphs and ensuring some efficient indexing, improved performance and saved serious money.

Michael Malis

Eventn - Data-driven Microservices — Build, deploy and scale HTTP microservices. Connect directly to a database or data warehouse and deploy RESTful services for ETL, SQL analytics or data processing with a single click.

Eventn sponsored

Squeezing Performance from SQLite: Insertions (with Room) — Google announced a new tool at I/O called ‘Room’ which makes working with SQLite databases a lot easier. Jason Feinstein asks “how well does it perform?”

Hacker Noon

GraphQL Meets Graph Database: A GraphQL + Neo4j Integration — Discover the newest integration between the Neo4j graph database and the GraphQL API query language that includes GraphQL-to-Cypher query translation.

Michael Hunger and William Lyon

82% of Databases Left Unencrypted in Public Cloud — Personal health information and other sensitive data is left exposed as businesses overlook encryption and network security.

Dark Reading

Migrating Oracle Databases to Postgres on Amazon RDS — See how to migrate to PostgreSQL on RDS in three steps.

SelectStar sponsored

How to Encrypt a Google Firebase Realtime Database

Andy Geers

SQL Server Window Functions in Action

Gavin Draper

Searching Flight Data with Neo4j — A graph database is ideal for modelling data like this.

Max de Marzi

A Data Model for an Electric Power Production System

Vertabelo

Dynamo, Citus, and Tradeoffs in Distributed Databases — Often there’s debate between relational databases and distributed ones (which are more typically NoSQL). Here’s some thoughts on the benefits of each from one of the creators of Dynamo.

Citus Data

Autoscaling for your Heroku dynos — Automatically scale up and down to handle increased workloads and avoid wasting money on idle resources.

HireFire tools sponsored

Scuttlebot: Open-Source Peer-to-Peer Log Store — For use as a database, identity provider, and messaging system. Features global replication and end-to-end encryption.

Secure Scuttlebutt Consortium tools

Ora2Pg: A Tool to Move Oracle Databases to PostgreSQL — A free tool used to migrate an Oracle or MySQL database to a Postgres-compatible schema.

Ora2Pg tools

M3DB: A Distributed Time Series Database Using M3TSZ Compression — Written in Go.

M3DB code

SQLiteProxy: A Simple HTTP JSON Proxy for SQLite

github.com code