Issue 101 — April 21, 2016
Featured
SQL Injection Challenges — 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.
breakthenet code
Analyzing A Billion Taxi Rides with Google's BigQuery — A basic intro to analyzing 100GB+ of data on Google’s Cloud Platform if you haven’t given it a try yet.
Mark Litwintschik tutorial
Monitoring MySQL Performance Metrics — A guide to distilling the 300+ metrics MySQL provides down to something useful. Learn to track latency, throughput, connections, and buffer pool utilization.
John Matson tutorial
RavenDB: See How a Modern Web App is Built with a Modern Database — 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.
RavenDB sponsored
Firebird 3.0.0 Released — 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.
Firebird news
Shift: An App to Run Online Schema MySQL Migrations — Built for use at Square, Shift lets you queue, run, and otherwise manage migrations through a webapp.
Square tools
Postgres-XL 9.5 R1 Released — A Postgres fork offering massively-parallel functionality for BI and OLTP style workloads.
Postgres-XL news
Jobs
The Easiest Way to Find a Job — 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.
Hired.com
In brief
One Call to Rule Them All — DreamFactory's autogenerated REST APIs work across multiple databases on a multitude of servers. Free, open source platform.
DreamFactory tools sponsored
Citus Launches New Postgres Database As A Cloud Service — Citus Cloud is built on top of AWS.
TechCrunch news
Amazon RDS for PostgreSQL Now Supports 9.5 — Postgres 9.5, the much awaited release with upsert support, is now available to use on Amazon RDS.
Kevin Jernigan news
Datanami news
Solr 6, SolrCloud and SQL Queries — Solr 6 (the open source enterprise search platform) was released this month.
Rafal Kuć news
Alfredo Kojima news tools
Benjamin Young tutorial
Secure Signed Cookies with PostgreSQL's pgcrypto — Generating and verify secure signed cookies from a webapp with just PostgreSQL’s pgcrypto library.
Nick Gauthier tutorial
Datanami opinion
Monitor MySQL, Redis, DynamoDB, Amazon RDS, Postgres, and more — Datadog collects DB performance and resource metrics for graphing, alerting, and full-stack correlation analysis. 14-day full-featured trial.
Datadog tools sponsored
MariaDB Foundation tools
The PostgreSQL Global Development Group tools
Jethro Data tools