--- title: "This week's database news, issue 158" publication: "DB Weekly" issue: 158 published_at: "2017-06-09" canonical_url: "https://dbweekly.com/issues/158" --- Database Weekly 158 This week's database news -[Read this on the Web](http://dbweekly.com/issues/158) [Database Weekly](http://dbweekly.com) Issue 158 — June 9, 2017 [Benchmarking Elasticsearch at 1 Million Writes per Second](https://medium.appbase.io/benchmarking-elasticsearch-1-million-writes-per-sec-bf37e7ca8a4c?utm_source=dbweekly&utm_medium=email) — Elasticsearch is now one of the most widely used document databases, but what does it take to get to 1 million writes per second? 15 AWS m4.2xlarge nodes, it seems. Siddharth Kotharistory [Citus 6.2: A Multi-Tenant Database Built on Postgres](https://www.citusdata.com/blog/2017/06/07/announcing-citus62-multi-tenant-database/?utm_source=dbweekly&utm_medium=email) — Citus is an open source database built on top of Postgres, ideal for app devs building multi-tenant B2B applications & real-time analytics. citusdatatools [Monitoring Databases: A Product Comparison](https://www.percona.com/blog/2017/03/16/monitoring-databases-a-product-comparison/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Percona_Blog) — Percona’s Manjot Singh reviews five of the top database monitoring solutions on the market. Get his breakdown in this blog. SelectStarsponsored [![\](https://copm.s3.amazonaws.com/8e1dcac9.png)](https://www.percona.com/blog/2017/03/16/monitoring-databases-a-product-comparison/?utm_source=DBTA&utm_medium=Newsletter&utm_campaign=Percona_Blog) [Spark's New Deep Learning Tricks](https://www.datanami.com/2017/06/07/sparks-new-deep-learning-tricks/?utm_source=dbweekly&utm_medium=email) — [Deep Learning Pipelines](https://github.com/databricks/spark-deep-learning) is a library for using Apache Spark to run deep learning workflows for image or other unstructured data analysis. Datanamitools [First Beta of RavenDB 4.0 Released](https://ayende.com/blog/178465/ravendb-4-0-beta1-is-now-available?utm_source=dbweekly&utm_medium=email) — RavenDB is an open source (AGPL) NoSQL database for .NET. [Licensing and pricing](https://ayende.com/blog/178434/ravendb-4-0-licensing-pricing) for the commercial version has also been announced. Ayende Rahientools [An Example of Handling 100GB+ of Data with Node and MySQL](https://blog.risingstack.com/node-js-mysql-example-handling-hundred-gigabytes-of-data/?utm_source=dbweekly&utm_medium=email) — RisingStack uses MySQL to store data for its _Trace_ monitoring tool. Here they show how MySQL’s table partitioning helps keep things scaling. Tamas Kadlecsiktutorial [Dates for MongoDB Europe 2017 announced](https://www.mongodb.com/europe17?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=sponsored &utm_medium=display&utm_source=dbweekly0609) — Introducing Shard N: a super-charged technical track for a very deep dive into MongoDB (wizard level only). Mongo DBsponsored news [PG-Strom: SSD-To-GPU Direct SQL Execution for Postgres](https://github.com/pg-strom/devel?utm_source=dbweekly&utm_medium=email) — Use GPUs to accelarate sequential scan and join/aggregate functions in Postgres. [Slidedeck with more info.](https://www.slideshare.net/kaigai/20170602ossummitanintelligentstorage) PG-Strom Projectcode [Making Apache Spark the Fastest Open Source Streaming Engine](https://databricks.com/blog/2017/06/06/simple-super-fast-streaming-engine-apache-spark.html?utm_source=dbweekly&utm_medium=email) Michael Armbrustnews [MongoDB Aggregations in 5 Minutes](https://engineering.universe.com/mongo-aggregations-in-5-minutes-b8e1d9c274bb?utm_source=dbweekly&utm_medium=email) Joshua Kellytutorial [Measuring A/B Tests: SQL for P-value Graphs in Redshift](https://engineering.ezcater.com/measuring-ab-tests-sql-for-pvalue-graphs-in-redshift?utm_source=dbweekly&utm_medium=email) Jeff Dwyertutorial [SQL Server 2016: What's New With TSQL](https://gavindraper.com/2017/06/06/sql-server-2016-tsql-whats-new/?utm_source=dbweekly&utm_medium=email) Gavin Drapertutorial [Migrating Procedural SQL Code with the AWS Schema Conversion Tool](https://aws.amazon.com/blogs/database/migrate-your-procedural-sql-code-with-the-aws-schema-conversion-tool/?utm_source=dbweekly&utm_medium=email) — See how easy it is to migrate procedural code from Oracle to PostgreSQL using AWS SCT. Amazon Web Servicestutorial [Top 7 SQL Interview Questions for Tech Professionals](http://blog.yhat.com/posts/SQL-interview-questions.html?utm_source=dbweekly&utm_medium=email) Rebecca Lewistutorial [Scaling Out Complex SQL Transactions in Multi-Tenant Apps on Postgres](https://www.citusdata.com/blog/2017/06/02/scaling-complex-sql-transactions/?utm_source=dbweekly&utm_medium=email) citusdatatutorial [Accidentally Destroyed Production Database on First Day of a Job...](https://www.reddit.com/r/cscareerquestions/comments/6ez8ag/accidentally_destroyed_production_database_on/?utm_source=dbweekly&utm_medium=email) Redditstory [How to find and fix the slowest code in your .NET application](http://www.red-gate.com/products/dotnet-development/ants-performance-profiler/?utm_source=dbweekly&utm_medium=displayemail&utm_content=slowest_code&utm_campaign=antsperformanceprofiler&utm_term=email-25728) — Find bottlenecks in your code or database & boost performance with ANTS Performance Profiler. [Try it free now](http://www.red-gate.com/products/dotnet-development/ants-performance-profiler/?utm_source=dbweekly&utm_medium=displayemail&utm_content=slowest_code&utm_campaign=antsperformanceprofiler&utm_term=email-25728). Red Gatetools sponsored [Redis Dashboard: A Sinatra (Ruby) App to Monitor Redis Servers](https://github.com/BaseSecrete/redis_dashboard?utm_source=dbweekly&utm_medium=email) Base Secrètecode [ora2pg: Migrate An Oracle Database to A PostgreSQL Compatible Schema](https://github.com/darold/ora2pg?utm_source=dbweekly&utm_medium=email) Daroldcode [Daisy: A Private Blockchain Where Blocks Are SQLite Databases](https://github.com/ivoras/daisy?utm_source=dbweekly&utm_medium=email) Ivan Vorascode [SQueaLy: A SQL-Based BI and Analytics Microservice](https://github.com/hashedin/squealy?utm_source=dbweekly&utm_medium=email) HashedIn Technologies Pvt.​ Ltd.​ code Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/158) [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