Issue 84 — December 18, 2015
Featured
DataGrip 1.0: A new IDE for Databases and SQL —
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.
JetBrains tools
Literate SQL —
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 —
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.
GCHQ code
Holiday Traffic Overloading Your Servers? Let VividCortex Help. — 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.
Vivid Cortex sponsored
SqlPad: A Web App for Running SQL Queries and Visualizing The Results —
Run SQL in your browser, chart the results, supports MySQL, SQL Server and Vertica.
Rick Bergfalk code
Migrating Mountains of Big Data to AWS —
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 Maloney video
MongoDB 3.2: Now 'Powered' by PostgreSQL —
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 — 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
Segment news tools
RethinkDB news tools
ScriptRock tutorial
Cloudera tutorial code
Periscope tutorial
Nick Kolakowski opinion
Couchbase 4.1 Delivers Greatly-Enhanced SQL Capabilities —
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’.
ZDNet opinion
Open Source Hadoop Connectors for Solr —
Several connectors for indexing content from Hadoop to Solr are now open source.
Lucidworks tools
Fieldbook: Create A Database, As Easily As A Spreadsheet —
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.
Fieldbook tools
Daniel Paz-Soldan code
sysadminmike code
Test the Distributed Open Source RDBMS for Real-Time Big Data Built on PostgreSQL — Download CitusDB, the distributed PostgreSQL 9.4 database, to gain real-time insights
Citus Data sponsored