--- title: "This week's database news, issue 69" publication: "DB Weekly" issue: 69 published_at: "2015-08-28" canonical_url: "https://dbweekly.com/issues/69" --- Database Weekly 69 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/69) [Database Weekly](http://dbweekly.com) Issue 69 — August 28, 2015 Featured [Breaking the SQL Barrier: Google BigQuery User-Defined Functions](http://googledevelopers.blogspot.com/2015/08/breaking-sql-barrier-google-bigquery.html?utm_source=dbweekly&utm_medium=email) — 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](https://medium.com/aws-activate-startup-blog/amazon-dynamodb-storage-backend-for-titan-distributed-graph-database-b9cc8cca80b7?utm_source=dbweekly&utm_medium=email) — 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](https://www.compose.io/write-stuff/?utm_source=cooper&utm_medium=DBweekly&utm_campaign=writestuff) — 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.​iosponsored [![\](https://copm.s3.amazonaws.com/ba2ccb91.png)](https://www.compose.io/write-stuff/?utm_source=cooper&utm_medium=DBweekly&utm_campaign=writestuff) [Why Gartner Dropped Big Data Off the Hype Curve](http://www.datanami.com/2015/08/26/why-gartner-dropped-big-data-off-the-hype-curve/?utm_source=dbweekly&utm_medium=email) — 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](http://www.techrepublic.com/article/amazon-aurora-whats-missing-and-whats-available-in-the-mysql-alternative/?utm_source=dbweekly&utm_medium=email) — 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](https://github.com/spotify/postgresql-metrics?utm_source=dbweekly&utm_medium=email) — A CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. Spotifytools [SQLFormat: Online SQL Formatter](http://sqlformat.org/?utm_source=dbweekly&utm_medium=email) — A free online formatter for SQL statements. SQLFormat.​org In brief [Riak Taps Mesos for 'Push Button' NoSQL Scalability](http://www.datanami.com/2015/08/20/riak-taps-mesos-for-push-button-nosql-scalability/?utm_source=dbweekly&utm_medium=email) Datanaminews [Win a Ticket to 'All Your Base' Database Conference in London on November 13](https://www.rafflecopter.com/rafl/display/cbc155511/?utm_source=dbweekly&utm_medium=email) Rafflecopternews [Designing A Data Model for A Hotel Room Booking System](http://www.vertabelo.com/blog/technical-articles/designing-a-data-model-for-a-hotel-room-booking-system?utm_source=dbweekly&utm_medium=email) Maria Alcaraztutorial [Generating MoM, YoY and CMGR from SQL](http://tech.yunojuno.com/sql-window-functions?utm_source=dbweekly&utm_medium=email) — 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 [How To Configure a Redis Cluster on Ubuntu 14.04](https://www.digitalocean.com/community/tutorials/how-to-configure-a-redis-cluster-on-ubuntu-14-04?utm_source=dbweekly&utm_medium=email) DigitalOceantutorial [How to Set Up a Redis Server as a Session Handler for PHP on Ubuntu 14.04](https://www.digitalocean.com/community/tutorials/how-to-set-up-a-redis-server-as-a-session-handler-for-php-on-ubuntu-14-04?utm_source=dbweekly&utm_medium=email) DigitalOceantutorial [Using SQL Techniques in NoSQL Is OK, Right? WRONG](http://www.theregister.co.uk/2015/08/25/beware_sql_like_nosql?utm_source=dbweekly&utm_medium=email) The Registeropinion [How Much Does It Cost to Run Relational Database Options on AWS](https://www.cloudyn.com/blog/how-much-does-it-cost-to-run-relational-database-options-rds-on-aws/?utm_source=dbweekly&utm_medium=email) Yoav Moropinion [About Redis Sets' Memory Efficiency](http://antirez.com/news/92?utm_source=dbweekly&utm_medium=email) Salvatore Sanfilippo [sql_firewall: SQL Firewall Extension for PostgreSQL](https://github.com/uptimejp/sql_firewall?utm_source=dbweekly&utm_medium=email) — 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 Technologiescode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/69) [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