Issue 152 — April 28, 2017
Featured
What You Need To Know About SQL's 'GROUP BY' — GROUP BY is used so often in SQL that it pays to understand it well.
Periscope tutorial
Squeezing Performance From SQLite: EXPLAINing The Virtual Machine — Under the hood, SQLite is organized around a virtual machine. This is an intriguing look at how it works and what it does.
Jason Feinstein tutorial
Pushing A Trillion Row Database With GPU Acceleration — There’s an arms race in the nascent market for GPU-accelerated databases, and the winners will be those that can scale to the largest datasets while providing compatibility with regular SQL.
Timothy Prickett Morgan news
JawsDB - Fast, reliable, no-bullshark MySQL as a service — Our MySQL database-as-a-service makes it easy to one-click provision a database. Create, edit, and save reusable queries against your provisioned server. MariaDB and PostrgeSQL coming soon.
JawsDB sponsored
Speed: The No. 1 Reason to Adopt Graph Tech — Alex Woodie runs through the results of IBM’s recent "State of Graph Databases" study.
Datanami news
AWS Opens Access to Preview of PostgreSQL-Flavored Amazon Aurora — All AWS customers can now use the Postgres-compatible variant of its Amazon Aurora database service.
Amazon Web Services, Inc. news
Analyzing 1.1 Billion Taxi Rides with MapD 3.0 — Take 2 GPU-powered EC2 instances, add the MapD 3.0 database and visual analytics platform, and 1.1 billion NYC taxi trips and analyze away.
Mark Litwintschik tutorial
In brief
Business Insider news
Blog: How APM Inspired Better Database Performance Management — Learn how the best features & the biggest gaps in modern APM inspired a new database performance platform.
SelectStar sponsored
Building a Basic Next.js App With MongoDB — Next.js is a Node.js framework for building server-rendered React apps.
The Code Barbarian tutorial
Spatial Analytics with PostGIS, PL/R and R — An introduction to spatial analytics with PostgreSQL, PostGIS, PL/R and R.
Joe Conway tutorial
Google Cloud Platform tutorial
Jon Erik Solheim tutorial
Peter Lafferty tutorial
Die Socialisten Garage story
Vadim Popov story
High Available and Scalable Open Source Database - SiriDB — SiriDB is robust, fast and has a unique query language that makes it easy to create charts for your application.
Transceptor Technology sponsored
Pgweb: A Cross-Platform Client for Postgres — Built using Go and works on macOS, Linux and Windows.
Dan Sosedoff tools
github.com tools
Two Sigma code
MG4J: Managing Gigabytes for Java — A full-text search engine for large document collections written in Java.
Sebastiano Vigna and Paolo Boldi code
Roi Lipman code