Issue 69 — August 28, 2015
Featured
Breaking the SQL Barrier: Google BigQuery User-Defined Functions —
Google BigQuery is a petabyte-scale data analytics service that uses SQL as its query interface. As part of its latest release, however, it supports user-defined functions (UDFs) written in JavaScript for when SQL doesn’t cut it.
Google Developers Blog
Amazon DynamoDB Storage Backend for Titan: Distributed Graph Database —
A quick refresher on graph databases before looking at Titan, a scalable graph database abstraction that can run on top of Amazon’s DynamoDB service.
Amazon Web Services
Get Paid to Write about Databases — Write about databases, earn 200ドル cash and 200ドル in Compose credit. Write a deep dive into how you use databases in your technology stack. Let people know useful tips and tricks for a particular database. Explain the philosophy and practical implications of database concepts. All ideas welcome.
Compose.io sponsored
Why Gartner Dropped Big Data Off the Hype Curve —
Big data has been a fixture on the Hype Cycle for Emerging Technologies for several years, but now Gartner says it’s off the hype cycle entirely.
Datanami
Amazon Aurora: What's Available and What's Missing in The MySQL Alternative —
Amazon Aurora is a new database service within Amazon Web Services that provides a compatible alternative to MySQL but with extra scalability.
TechRepublic
Spotify PostgreSQL Metrics: Tool That Extracts and Provides Metrics On Your Database —
A CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster.
Spotify tools
SQLFormat: Online SQL Formatter —
A free online formatter for SQL statements.
SQLFormat.org
In brief
Datanami news
Maria Alcaraz tutorial
Generating MoM, YoY and CMGR from SQL —
Window functions are extremely powerful and you can do many things with them. One very common capability is computing month over month growth without having to break out a scripting language or Excel.
YunoJuno Tech Team
DigitalOcean tutorial
DigitalOcean tutorial
The Register opinion
Yoav Mor opinion
Salvatore Sanfilippo
sql_firewall: SQL Firewall Extension for PostgreSQL —
Should a SQL injection vulnerability occur in your application it could be a huge disaster, here’s a newer approach for helping prevent such by analyzing every query and alerting on unknown queries against your system.
Uptime Technologies code