---
title: "This week's database news, issue 101"
publication: "DB Weekly"
issue: 101
published_at: "2016-04-21"
canonical_url: "https://dbweekly.com/issues/101"
---

Database Weekly 101   . 

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

[Database Weekly](http://dbweekly.com) Issue 101 — April 21, 2016     

Featured [SQL Injection Challenges](https://github.com/breakthenet/HackMe-SQL-Injection-Challenges?utm_source=dbweekly&utm_medium=email#readme) — Six challenges for you to complete to learn about SQL injection vulnerabilities along the way. Deploy the challenge environment to Heroku (button included) and get going. breakthenetcode [Analyzing A Billion Taxi Rides with Google's BigQuery](http://tech.marksblogg.com/billion-nyc-taxi-rides-bigquery.html?utm_source=dbweekly&utm_medium=email) — A basic intro to analyzing 100GB+ of data on Google’s Cloud Platform if you haven’t given it a try yet. Mark Litwintschiktutorial [Monitoring MySQL Performance Metrics](https://www.datadoghq.com/blog/monitoring-mysql-performance-metrics/?utm_source=dbweekly&utm_medium=email) — A guide to distilling the 300+ metrics MySQL provides down to something useful. Learn to track latency, throughput, connections, and buffer pool utilization. John Matsontutorial [RavenDB: See How a Modern Web App is Built with a Modern Database](https://debuggerdotbreak.wordpress.com/2016/04/10/make-it-modern-ravendb-angular-typescript-bootstrap-for-modern-web-apps/) — A modern dev stack for modern web apps. See how I built a new web app using RavenDB, Angular, Bootstrap and Typescript. Why these tools are an excellent choice for modern web dev. RavenDBsponsored [![\](https://copm.s3.amazonaws.com/839dd939.jpg)](https://debuggerdotbreak.wordpress.com/2016/04/10/make-it-modern-ravendb-angular-typescript-bootstrap-for-modern-web-apps/) [Firebird 3.0.0 Released](http://www.firebirdsql.org/en/firebird-3-0-0/?utm_source=dbweekly&utm_medium=email) — Firebird, the cross-platform open source RDBMS (which forked from InterBase), now has significantly improved SMP and multi-core support, as well as improved SQL support. Firebirdnews [Shift: An App to Run Online Schema MySQL Migrations](https://github.com/square/shift?utm_source=dbweekly&utm_medium=email) — Built for use at Square, Shift lets you queue, run, and otherwise manage migrations through a webapp. Squaretools [Postgres-XL 9.5 R1 Released](http://www.postgres-xl.org/2016/04/postgres-xl-9-5-r1-released/?utm_source=dbweekly&utm_medium=email) — A Postgres fork offering massively-parallel functionality for BI and OLTP style workloads. Postgres-XLnews Jobs [The Easiest Way to Find a Job](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=easiest&utm_campaign=q2-16-dbweekly&utm_location=us) — Hired lets you sit back while job offers come to you. When you complete your profile, instantly apply to 3,500+ companies on the platform who will contact you with job offers, including salary and equity up-front. [Try it today.](https://hired.com/?utm_source=newsletters=petercooperpress=cat-tech-database=easiest=q2-16-dbweekly=us) Hired.​com In brief [One Call to Rule Them All](http://blog.dreamfactory.com/working-with-virtually-related-data-0?utm_source=db_weekly&utm_medium=newsletter&utm_campaign=onecall) — DreamFactory's autogenerated REST APIs work across multiple databases on a multitude of servers. Free, open source platform. DreamFactorytools sponsored [Citus Launches New Postgres Database As A Cloud Service](http://techcrunch.com/2016/04/20/citus-launches-citus-cloud-beta-delivering-postgres-database-as-a-cloud-service/?utm_source=dbweekly&utm_medium=email) — [Citus Cloud](https://www.citusdata.com/blog/1773-craig-kerstiens/414-introducing-citus-cloud) is built on top of AWS. TechCrunchnews [Amazon RDS for PostgreSQL Now Supports 9.5](http://www.postgresql.org/about/news/1659/?utm_source=dbweekly&utm_medium=email) — Postgres 9.5, the much awaited release with upsert support, is now available to use on Amazon RDS. Kevin Jernigannews [Analytics Increasingly Seen Embedded in Apps](http://www.datanami.com/2016/04/18/analytics-increasingly-seen-embedded-apps/?utm_source=dbweekly&utm_medium=email) Datanaminews [Solr 6, SolrCloud and SQL Queries](https://sematext.com/blog/2016/04/18/solr-6-solrcloud-sql-support/?utm_source=dbweekly&utm_medium=email) — Solr 6 (the open source enterprise search platform) was released this month. Rafal Kućnews [MySQL 5.7.12: A New MySQL Command Line Shell](http://mysqlserverteam.com/mysql-5-7-12-part-4-a-new-mysql-command-line-shell/?utm_source=dbweekly&utm_medium=email) Alfredo Kojimanews tools [Building Hypermedia APIs with Apache CouchDB](https://blog.codeship.com/hypermedia-apis-apache-couchdb/?utm_source=dbweekly&utm_medium=email) Benjamin Youngtutorial [Secure Signed Cookies with PostgreSQL's pgcrypto](http://www.meetspaceapp.com/2016/04/19/cookie-signing-postgresql.html?utm_source=dbweekly&utm_medium=email) — Generating and verify secure signed cookies from a webapp with just PostgreSQL’s pgcrypto library. Nick Gauthiertutorial [10 Signs of a Bad Data Scientist](http://www.datanami.com/2016/04/19/10-signs-bad-data-scientist/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [Monitor MySQL, Redis, DynamoDB, Amazon RDS, Postgres, and more](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) — Datadog collects DB performance and resource metrics for graphing, alerting, and full-stack correlation analysis. [14-day full-featured trial.](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) Datadogtools sponsored [MariaDB 10.2.0 Alpha Now Available](https://mariadb.org/mariadb-10-2-0-alpha-now-available/?utm_source=dbweekly&utm_medium=email) MariaDB Foundationtools [pgBackRest: Reliable PostgreSQL Backup and Restore System](http://www.pgbackrest.org/?utm_source=dbweekly&utm_medium=email) The PostgreSQL Global Development Grouptools [Hadoop Hive and Comparing 11 SQL-on-Hadoop Alternatives](http://jethro.io/hadoop-hive?utm_source=dbweekly&utm_medium=email) Jethro Datatools    

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