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 news
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 story
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 news
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 news
Migrating Oracle Databases to Postgres on Amazon RDS — See how to migrate to PostgreSQL on RDS in three steps.
SelectStar tutorial sponsored
Andy Geers tutorial
Gavin Draper tutorial
Searching Flight Data with Neo4j — A graph database is ideal for modelling data like this.
Max de Marzi tutorial
Vertabelo tutorial
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 opinion
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
github.com code