Issue 150 — April 14, 2017
Featured
DB Fiddle: A Web-Based SQL Database Playground — Think of JS Fiddle but for playing with SQL in the browser. It offers MySQL 5.5-5.7 and Postgres 9.5-9.6 backends.
Status200 tools
Writing a Time Series Database from Scratch — Prometheus is an open source monitoring tool that includes a custom time series database. This is a deep dive into fleshing out a new architecture to address the existing database engine’s shortcomings.
Fabian Reinartz tutorial
New Features Coming to PostgreSQL 10 — Brief summaries on the key features coming to Postgres soon, including declarative partitioning and durable hash indexes. It’s going to be a huge release.
Robert Haas news
Webinar: Better Azure SQL Performance — Learn how to reduce development times by getting a better understanding of how your Azure SQL workloads are really performing. Register now.
SelectStar sponsored
Databazel: Open Source Analytics and Reports for MongoDB — Directly connects to MongoDB (no ETL necessary) and presents results in a visual dashboard reporting interface.
JS Solutions tools
QuickDBD: Draw Database Diagrams Simply By Typing — You write out a schema in a simplified text format (almost like SQL’s answer to Markdown) and it produces good looking diagrams. No signup needed.
Dovetail Technologies tools
How Reddit Built A High Traffic Pixel Art Gallery — Reddit built an interactive pixel art system (called /r/place) that had to work with 100,000s of users from day one. This fascinating post goes into the details including why Cassandra was rejected as a data store, and how Redis was used.
Reddit story
Elasticsearch Cluster Lifecycle at eBay — A look at some of what’s involved with streamlining the rollout and management of Elasticsearch clusters.
Sudeep Kumar story
In brief
Explore the Future of Open Source Data Management — Join IAG, MasterCard, TripAdvisor, and more at Postgres Vision June 26-28. 200ドル off with code DBWEEK by May 19.
Postgres Vision 2017 news sponsored
Baron Schwartz tutorial
SteamLayers tutorial
Tit Petric tutorial
Vlad Mihalcea tutorial
AWS DynamoDB Overview — What I’ve learned about Amazon’s NoSQL database offering, DynamoDB.
Lewis Gavin tutorial
Enabling Successful Spread Betting with In-Memory Computing (IMC) — Speed is of the essence in any trading environment.
Datanami story
Reddit opinion
Kyle Wild opinion
Pete Garcin opinion
SQL Source Control: track each change to your SQL Server database — Get a full history in your source control system. See who made changes, what they did & why. See how.
Red Gate tools sponsored
MySQL InnoDB Cluster GA Now Available — An integrated, native, full-stack HA solution for MySQL from the MySQL Server team.
Mike Zinner tools
NStack: Type-Safe, Composable Microservices for Data Analytics — A compute platform for processing streams.
NStack tools
Yohz Software tools