---
title: "#152: What You Need To Know About SQL's 'GROUP BY'"
publication: "DB Weekly"
issue: 152
published_at: "2017-04-28"
canonical_url: "https://dbweekly.com/issues/152"
---

Database Weekly 152   . 

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

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

Featured [What You Need To Know About SQL's 'GROUP BY'](https://periscopedata.com/blog//everything-about-group-by.html?utm_source=dbweekly&utm_medium=email) — GROUP BY is used so often in SQL that it pays to understand it well. Periscopetutorial [Squeezing Performance From SQLite: EXPLAINing The Virtual Machine](https://medium.com/@JasonWyatt/squeezing-performance-from-sqlite-explaining-the-virtual-machine-2550ef6c5db?utm_source=dbweekly&utm_medium=email) — Under the hood, SQLite is organized around a virtual machine. This is an intriguing look at how it works and what it does. Jason Feinsteintutorial [Pushing A Trillion Row Database With GPU Acceleration](https://www.nextplatform.com/2017/04/26/pushing-trillion-row-database-gpu-acceleration/?utm_source=dbweekly&utm_medium=email) — 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 Morgannews [JawsDB - Fast, reliable, no-bullshark MySQL as a service](https://www.jawsdb.com/?utm_source=db-weekly&utm_medium=email&utm_campaign=jawsdb-ga-2017-wk-17&utm_content=db-weekly-1) — 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. JawsDBsponsored [![\](https://copm.s3.amazonaws.com/19aea3aa.png)](https://www.jawsdb.com/?utm_source=db-weekly&utm_medium=email&utm_campaign=jawsdb-ga-2017-wk-17&utm_content=db-weekly-1) [Speed: The No. 1 Reason to Adopt Graph Tech](https://www.datanami.com/2017/04/26/speed-no-1-reason-adopt-graph-tech/?utm_source=dbweekly&utm_medium=email) — Alex Woodie runs through the results of IBM’s recent _“State of Graph Databases”_study. Datanaminews [AWS Opens Access to Preview of PostgreSQL-Flavored Amazon Aurora](https://aws.amazon.com/about-aws/whats-new/2017/04/announcing-open-preview-of-amazon-aurora-with-postgresql-compatibility/?utm_source=dbweekly&utm_medium=email) — 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](http://tech.marksblogg.com/billion-nyc-taxi-rides-aws-ec2-p2-8xlarge-mapd.html?utm_source=dbweekly&utm_medium=email) — Take 2 GPU-powered EC2 instances, add the MapD 3.0 database and visual analytics platform, and [1.1 billion NYC taxi trips](https://github.com/toddwschneider/nyc-taxi-data) and analyze away. Mark Litwintschiktutorial In brief [Oracle Is Building A 'Transformational' Startup Inside The Company](http://uk.businessinsider.com/oracle-is-building-a-transformational-startup-inside-the-company-2017-4?r=US&IR=T&utm_source=dbweekly&utm_medium=email) Business Insidernews [Blog: How APM Inspired Better Database Performance Management](https://selectstar.io/blog/why-we-built-selectstar/) — Learn how the best features & the biggest gaps in modern APM inspired a new database performance platform. SelectStarsponsored [Building a Basic Next.js App With MongoDB](http://thecodebarbarian.com/building-a-nextjs-app-with-mongodb.html?utm_source=dbweekly&utm_medium=email) — Next.js is a Node.js framework for building server-rendered React apps. The Code Barbariantutorial [Spatial Analytics with PostGIS, PL/R and R](http://info.crunchydata.com/blog/spatial-analytics-with-postgres-postgis-plr?utm_source=dbweekly&utm_medium=email) — An introduction to spatial analytics with PostgreSQL, PostGIS, PL/R and R. Joe Conwaytutorial [Top 5 Tips for Migrating Your Data Warehouse to Google BigQuery](https://cloud.google.com/blog/big-data/2017/04/top-5-tips-for-migrating-your-data-warehouse-to-google-bigquery?utm_source=dbweekly&utm_medium=email) Google Cloud Platformtutorial [Object Relations in a NoSQL Database](https://restdb.io/blog/object-relations-in-a-nosql-database?utm_source=dbweekly&utm_medium=email) Jon Erik Solheimtutorial [Intermediate MySQL Stored Procedures](https://medium.com/@peter.lafferty/intermediate-mysql-stored-procedures-24394d3cab03?utm_source=dbweekly&utm_medium=email) Peter Laffertytutorial [Why and How Swat.io Migrated From MySQL to Postgres in 2 Years](http://garage.socialisten.at/2017/04/how-swat-io-migrated-from-mysql-to-postgresql-in-2-years/?utm_source=dbweekly&utm_medium=email) Die Socialisten Garagestory [Homegrown Master-Master Replication for a NoSQL Database](https://hackernoon.com/fault-tolerant-processing-of-10m-oauth-tokens-with-tarantool-189323fc5236?utm_source=dbweekly&utm_medium=email) Vadim Popovstory [High Available and Scalable Open Source Database - SiriDB](http://siridb.net/) — SiriDB is robust, fast and has a unique query language that makes it easy to create charts for your application. Transceptor Technologysponsored [Pgweb: A Cross-Platform Client for Postgres](https://sosedoff.github.io/pgweb/?utm_source=dbweekly&utm_medium=email) — Built using Go and works on macOS, Linux and Windows. Dan Sosedofftools [Variety: A Schema Analyzer for MongoDB](https://github.com/variety/variety?utm_source=dbweekly&utm_medium=email) github.​comtools [infreqdb: S3 Backed Key/Value Database for Infrequent Read Access from Go](https://github.com/turbobytes/infreqdb?utm_source=dbweekly&utm_medium=email) turbobytescode [Flint: A Time Series Library for Apache Spark](https://github.com/twosigma/flint?utm_source=dbweekly&utm_medium=email) Two Sigmacode [MG4J: Managing Gigabytes for Java](http://mg4j.di.unimi.it/?utm_source=dbweekly&utm_medium=email) — A full-text search engine for large document collections written in Java. Sebastiano Vigna and Paolo Boldicode [Redis Graph: A Redis Module Implementing A Simple Graph Database](https://github.com/swilly22/redis-module-graph?utm_source=dbweekly&utm_medium=email) Roi Lipmancode [Atlas: Netflix's In-Memory Dimensional Time Series Database](https://github.com/Netflix/atlas?utm_source=dbweekly&utm_medium=email) Netflixcode    

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