---
title: "#150: DB Fiddle - A Web based SQL database playground"
publication: "DB Weekly"
issue: 150
published_at: "2017-04-14"
canonical_url: "https://dbweekly.com/issues/150"
---

Database Weekly 150   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/150) 

[Database Weekly](http://dbweekly.com) Issue 150 — April 14, 2017     

Featured [DB Fiddle: A Web-Based SQL Database Playground](https://www.db-fiddle.com/?utm_source=dbweekly&utm_medium=email) — Think of [JS Fiddle](https://jsfiddle.net/) but for playing with SQL in the browser. It offers MySQL 5.5-5.7 and Postgres 9.5-9.6 backends. Status200tools [Writing a Time Series Database from Scratch](https://fabxc.org/blog/2017-04-10-writing-a-tsdb/?utm_source=dbweekly&utm_medium=email) — [Prometheus](https://prometheus.io/) 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 Reinartztutorial [New Features Coming to PostgreSQL 10](http://rhaas.blogspot.com/2017/04/new-features-coming-in-postgresql-10.html?utm_source=dbweekly&utm_medium=email) — 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 Haasnews [Webinar: Better Azure SQL Performance](https://www.brighttalk.com/webcast/15241/255205?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=255205) — Learn how to reduce development times by getting a better understanding of how your Azure SQL workloads are really performing. [Register now](https://www.brighttalk.com/webcast/15241/255205?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=255205). SelectStarsponsored [![\](https://copm.s3.amazonaws.com/039b7b86.png)](https://www.brighttalk.com/webcast/15241/255205?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=255205) [Databazel: Open Source Analytics and Reports for MongoDB](https://github.com/JSSolutions/Databazel?utm_source=dbweekly&utm_medium=email) — Directly connects to MongoDB (no ETL necessary) and presents results in a visual dashboard reporting interface. JS Solutionstools [QuickDBD: Draw Database Diagrams Simply By Typing](https://www.quickdatabasediagrams.com/?utm_source=dbweekly&utm_medium=email) — 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 Technologiestools [How Reddit Built A High Traffic Pixel Art Gallery](https://redditblog.com/2017/04/13/how-we-built-rplace/?utm_source=dbweekly&utm_medium=email) — 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. Redditstory [Elasticsearch Cluster Lifecycle at eBay](http://www.ebaytechblog.com/2017/04/12/elasticsearch-cluster-lifecycle-at-ebay/?utm_source=dbweekly&utm_medium=email) — A look at some of what’s involved with streamlining the rollout and management of Elasticsearch clusters. Sudeep Kumarstory In brief [Announcing MySQL Server 5.7.18, 5.6.36, and 5.5.55](http://mysqlrelease.com/2017/04/announcing-mysql-server-5-7-18-5-6-36-and-5-5-55/?utm_source=dbweekly&utm_medium=email) MySQLnews [Explore the Future of Open Source Data Management](http://www.postgresvision.com?utm_source=dbweekly&utm_medium=email) — Join IAG, MasterCard, TripAdvisor, and more at Postgres Vision June 26-28. $200 off with code DBWEEK by May 19. Postgres Vision 2017news sponsored [Analyzing Changing Workloads with the Universal Scalability Law](https://www.xaprb.com/blog/analyzing-changing-workloads-usl/?utm_source=dbweekly&utm_medium=email) Baron Schwartztutorial [Real World Full-Text Search using MongoDB](https://steamlayers.com/full-text-search-using-mongodb/?utm_source=dbweekly&utm_medium=email) SteamLayerstutorial [A Few Quick MySQL Tips for Developers](https://scene-si.org/2017/04/10/mysql-tips-for-developers/?utm_source=dbweekly&utm_medium=email) Tit Petrictutorial [How PostgreSQL's Advisory Locks Work](https://vladmihalcea.com/2017/04/12/how-do-postgresql-advisory-locks-work/?utm_source=dbweekly&utm_medium=email) Vlad Mihalceatutorial [AWS DynamoDB Overview](https://medium.com/@lewisdgavin/aws-dynamodb-overview-184e53aedcd6?utm_source=dbweekly&utm_medium=email) — What I’ve learned about Amazon’s NoSQL database offering, DynamoDB. Lewis Gavintutorial [Enabling Successful Spread Betting with In-Memory Computing (IMC)](https://www.datanami.com/2017/04/12/enabling-successful-spread-betting-memory-computing/?utm_source=dbweekly&utm_medium=email) — Speed is of the essence in any trading environment. Datanamistory [Is DBA Job Growth Slowing?](https://www.reddit.com/r/Database/comments/64yjpm/is_dba_job_growth_slowing/?utm_source=dbweekly&utm_medium=email) Redditopinion [Apache Kafka vs Amazon Kinesis to Build a High Perf Distributed System](https://blog.keen.io/apache-kafka-vs-amazon-kinesis-to-build-a-high-performance-distributed-system-2f0e40249a5c?utm_source=dbweekly&utm_medium=email) Kyle Wildopinion [Surveying the Go(lang) Database Landscape](https://www.activestate.com/blog/2017/04/surveying-go-database-landscape?utm_source=dbweekly&utm_medium=email) Pete Garcinopinion [SQL Source Control: track each change to your SQL Server database](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=email&utm_content=track_every_change_v2&utm_campaign=sqlsourcecontrol&utm_term=email-25726) — Get a full history in your source control system. See who made changes, what they did & why. [See how](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change_v2&utm_campaign=sqlsourcecontrol&utm_term=email-25726). Red Gatetools sponsored [MySQL InnoDB Cluster GA Now Available](http://mysqlserverteam.com/mysql-innodb-cluster-ga/?utm_source=dbweekly&utm_medium=email) — An integrated, native, full-stack HA solution for MySQL from the MySQL Server team. Mike Zinnertools [NStack: Type-Safe, Composable Microservices for Data Analytics](https://github.com/nstack/nstack?utm_source=dbweekly&utm_medium=email) — A compute platform for processing streams. NStacktools [PgComment: A Postgres Schema Commenting Tool for Windows](https://www.postgresql.org/about/news/1740/?utm_source=dbweekly&utm_medium=email) Yohz Softwaretools    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/150) [See our archives](http://dbweekly.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