---
title: "This week's database news, issue 84"
publication: "DB Weekly"
issue: 84
published_at: "2015-12-18"
canonical_url: "https://dbweekly.com/issues/84"
---

Database Weekly 84   . 

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

[Database Weekly](http://dbweekly.com) Issue 84 — December 18, 2015     

Featured [DataGrip 1.0: A new IDE for Databases and SQL](http://blog.jetbrains.com/datagrip/2015/12/16/datagrip-1-0-formerly-0xdbe-a-new-ide-for-dbs-and-sql/?utm_source=dbweekly&utm_medium=email) — Formerly 0xDBE, DataGrip is a new database-focused IDE from JetBrains (the creators of IntelliJ and WebStorm). It supports Oracle, SQL Server, DB2, Sybase, MySQL, Postgres, SQLite, Derby, HyperSQL and H2 out of the box. JetBrainstools [Literate SQL](https://modern-sql.com/use-case/literate-sql?utm_source=dbweekly&utm_medium=email) — _Literate programming_ involves arranging source code in the order of human logic and thought, but SQL’s subqueries often make this tricky in SQL. SQL:1999s _WITH_ clause can help, as demonstrated here. Markus Winand [Gaffer: A Large-Scale Graph Database](https://github.com/GovernmentCommunicationsHeadquarters/Gaffer?utm_source=dbweekly&utm_medium=email) — A large-scale graph database oriented towards scenarios where the nodes and edges have associated statistics like counts and histograms. Unusual in that it comes from GCHQ, Britain’s official SIGINT organization. GCHQcode [Holiday Traffic Overloading Your Servers? Let VividCortex Help.](http://app.vividcortex.com/sign-up?utm_source=paid&utm_medium=dbw) — You want your site running smoothly for the mass of holiday shoppers, and so do we. VividCortex allows everyone on your team to see the affects of their code, so you can prevent problems before they happen, and fix them quickly when they do. [Sign up for a free trial today.](http://app.vividcortex.com/sign-up?utm_source=paid&utm_medium=dbw) Vivid Cortexsponsored [![\](https://copm.s3.amazonaws.com/48925912.png)](http://app.vividcortex.com/sign-up?utm_source=paid&utm_medium=dbw) [SqlPad: A Web App for Running SQL Queries and Visualizing The Results](http://rickbergfalk.github.io/sqlpad/?utm_source=dbweekly&utm_medium=email) — Run SQL in your browser, chart the results, supports MySQL, SQL Server and Vertica. Rick Bergfalkcode [Migrating Mountains of Big Data to AWS](https://www.youtube.com/watch?v=mZ2vPih03Lk&utm_source=dbweekly&utm_medium=email) — The developers of League of Legends have collected petabytes of metrics about their game and here they explain how they imported it into Amazon Web Services. Sean Maloneyvideo [MongoDB 3.2: Now 'Powered' by PostgreSQL](https://www.linkedin.com/pulse/mongodb-32-now-powered-postgresql-john-de-goes?utm_source=dbweekly&utm_medium=email) — An extensive writeup about how MongoDB 3.2 will use Postgres in its ‘legacy BI connector’ so that SQL-based BI systems can operate against it. John De Goes Jobs [Sit Back, Relax and Get Job Offers](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_campaign=q4_15-petercooperpress&utm_term=sponsored&utm_content=121815-relax) — For highly sought-after candidates, sifting through available job opportunities can be overwhelming. Forget applying and let interested companies reach out to you directly through Hired. Hired.​com In brief [Introducing Warehouses: Web and Mobile Data to SQL in Minutes](https://segment.com/blog/introducing-segment-warehouses-redshift-postgres/?utm_source=dbweekly&utm_medium=email) Segmentnews tools [Introducing The Official RethinkDB Java Client Driver](http://rethinkdb.com/blog/official-java-driver/?utm_source=dbweekly&utm_medium=email) RethinkDBnews tools [Top 11 Ways To Improve MySQL Security](https://www.scriptrock.com/articles/top-11-ways-to-improve-mysql-security?utm_source=dbweekly&utm_medium=email) ScriptRocktutorial [Spark-TS: A New Library for Analyzing Time-Series Data with Apache Spark](http://blog.cloudera.com/blog/2015/12/spark-ts-a-new-library-for-analyzing-time-series-data-with-apache-spark/?utm_source=dbweekly&utm_medium=email) Clouderatutorial code [One Dimensional Clustering in Postgres](https://www.periscopedata.com/blog/one-dimensional-clustering-in-postgres.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [Are Companies Really Using Apache Hadoop?](http://insights.dice.com/2015/12/14/are-companies-really-using-apache-hadoop/?utm_source=dbweekly&utm_medium=email) Nick Kolakowskiopinion [Couchbase 4.1 Delivers Greatly-Enhanced SQL Capabilities](http://www.zdnet.com/article/couchbase-4-1-delivers-greatly-enhanced-sql-capabilities/?utm_source=dbweekly&utm_medium=email) — Andrew Brust sings Couchbase’s praises and says it’s time to stop thinking of it as a ‘NoSQL database’ and instead simply as a ‘database’. ZDNetopinion [Open Source Hadoop Connectors for Solr](http://lucidworks.com/blog/2015/12/17/open-source-hadoop-for-solr/?utm_source=dbweekly&utm_medium=email) — Several connectors for indexing content from Hadoop to Solr are now open source. Lucidworkstools [Fieldbook: Create A Database, As Easily As A Spreadsheet](https://fieldbook.com/developers?utm_source=dbweekly&utm_medium=email) — Create a lightweight database you can view and edit as easily as a spreadsheet and access via a REST API—in minutes, with nothing to code or deploy. Fieldbooktools [bodybuilder: An Elasticsearch Query Body Builder for Node](https://github.com/danpaz/bodybuilder?utm_source=dbweekly&utm_medium=email) Daniel Paz-Soldancode [Anthelion: A Nutch Plugin to Crawl Semantic Annotations in HTML Pages](https://github.com/yahoo/anthelion?utm_source=dbweekly&utm_medium=email) Yahoo Inc.​ code [couch-to-postgres: Node Libary to Stream CouchDB Changes Into PostgreSQL](https://github.com/sysadminmike/couch-to-postgres?utm_source=dbweekly&utm_medium=email) sysadminmikecode [Test the Distributed Open Source RDBMS for Real-Time Big Data Built on PostgreSQL](http://info.citusdata.com/BigDataDBW.html) — Download CitusDB, the distributed PostgreSQL 9.4 database, to gain [real-time insights](http://info.citusdata.com/BigDataPW3.html) Citus Datasponsored    

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