Issue 152 — April 28, 2017
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.
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.
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
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.
Speed: The No. 1 Reason to Adopt Graph Tech
— Alex Woodie runs through the results of IBM’s recent
“State of Graph Databases”
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
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.
Oracle Is Building A 'Transformational' Startup Inside The Company
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.
Building a Basic Next.js App With MongoDB
— Next.js is a Node.js framework for building server-rendered React apps.
The Code Barbarian
Spatial Analytics with PostGIS, PL/R and R
— An introduction to spatial analytics with PostgreSQL, PostGIS, PL/R and R.
Top 5 Tips for Migrating Your Data Warehouse to Google BigQuery
Google Cloud Platform
Object Relations in a NoSQL Database
Jon Erik Solheim
Intermediate MySQL Stored Procedures
Why and How Swat.io Migrated From MySQL to Postgres in 2 Years
Die Socialisten Garage
Homegrown Master-Master Replication for a NoSQL Database
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.
Pgweb: A Cross-Platform Client for Postgres
— Built using Go and works on macOS, Linux and Windows.
Variety: A Schema Analyzer for MongoDB
infreqdb: S3 Backed Key/Value Database for Infrequent Read Access from Go
Flint: A Time Series Library for Apache Spark
MG4J: Managing Gigabytes for Java
— A full-text search engine for large document collections written in Java.
Sebastiano Vigna and Paolo Boldi
Redis Graph: A Redis Module Implementing A Simple Graph Database
Atlas: Netflix's In-Memory Dimensional Time Series Database