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

Database Weekly 97   . 

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

[Database Weekly](http://dbweekly.com) Issue 97 — March 24, 2016     

Featured [SQL Injection Cheat Sheet](https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/?utm_source=dbweekly&utm_medium=email) — A detailed resource to find technical information about the many different variants of SQL injection vulnerabilities. A good reference for both seasoned penetration testers and those just getting started in web app security. Ferruh Mavitunatools [DGraph: Scalable, Distributed, Low Latency, High Perf Graph DB](http://dgraph.io/?utm_source=dbweekly&utm_medium=email) — Easily scale to multiple machines, or datacenters. DGraph’s sharded storage and query processing were designed to minimize the number of network calls. Open source, supports GraphQL as query language, and responds in JSON. Manish R Jain [NoSQL Injection in Modern Web Applications](http://blog.east5th.co/2016/03/21/nosql-injection-in-modern-web-applications/?utm_source=dbweekly&utm_medium=email) — An hour long talk looking at the security of NoSQL databases, what NoSQL ‘injection’ entails, and how to both attack and fix an app. Pete Corey [Open Arms for Open Source: Dell SharePlex and EnterpriseDB Team Up](http://www.enterprisedb.com/postgres-plus-edb-blog/darin-bartik/open-arms-open-source-dell-shareplex-and-enterprisedb-team?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016BlogDellEDB) — New Dell SharePlex for EDB Postgres solution provides near-real-time replication from Oracle to the EDB Postgres platform that's on-premises, geographically dispersed, or in the cloud. Liberate your IT spend for strategic initiatives and innovation. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/c6432721.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/darin-bartik/open-arms-open-source-dell-shareplex-and-enterprisedb-team?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016BlogDellEDB) [Exploring SQL Server 2016’s Powerful New Features](http://www.vertabelo.com/blog/technical-articles/exploring-sql-server-2016-powerful-new-features?utm_source=dbweekly&utm_medium=email) — A practical look at SQL Server’s improved in-memory OLTP and _Always Encrypted_ functionality. vertabelonews [SQLite with a Fine-Toothed Comb](http://blog.regehr.org/archives/1292?utm_source=dbweekly&utm_medium=email) — Despite being one of the most heavily tested systems out there, here’s a look at how SQLite’s reliance on C can still result in undefined behavior occurring. John Regehr [Oracle Attacking Postgres in Russia?](http://momjian.us/main/blogs/pgblog/2016.html?utm_source=dbweekly&utm_medium=email#March_22_2016) — Bruce reports that Oracle has been sending a letter to Russian customers citing a Russian law that may restrict Postgres’ use in government agencies. [More here.](http://www.theregister.co.uk/2016/03/21/oracle_fights_russian_software_policy_with_postgres_smear/) Bruce Momjiannews [(Abusing) Elasticsearch as a Framework](https://zignar.net//2016/03/18/abusing-elasticsearch-as-a-framework/?utm_source=dbweekly&utm_medium=email) — “Most people who know Elasticsearch think of it as a search engine, and they’re probably correct. But we at Crate think about it a bit differently and use it as a framework.” Mathias Fusseneggeropinion [Streaming SQL with PipelineDB [PDF\]](https://wiki.postgresql.org/images/a/ad/South_Bay_PG_Meetup_2016-03-08_PipelineDB.pdf?utm_source=dbweekly&utm_medium=email) — PipelineDB is a database based off of Postgres but that adds continuous, streaming SQL query functionality. Derek Nelsonnews [Field Definitions In Elasticsearch](https://qbox.io/blog/field-definitions-in-elasticsearch?utm_source=dbweekly&utm_medium=email) — Elasticsearch isn’t just for storing text documents, it can deal with arrays, nested datatypes, geo-location information, and more. Igor Bobriakov Jobs [PostgreSQL Developers, Consultants & Support DBAs at 2ndQuadrant](http://2ndquadrant.com/en/about/careers/?utm_source=dbweekly&utm_medium=email) — We're in demand ....and that means you could be too!. Due to our continued growth we're looking for people with relevant PostgreSQL skills and experience. [Check out our vacancies.](http://2ndquadrant.com/en/about/careers/) 2ndQuadrant [Stop Applying to Jobs - Let Companies Apply to You](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_term=cat-tech-database&utm_content=stopapplyingtojobs&utm_campaign=q1-16&utm_location=us) — On Hired, sign up in 10 minutes and get offers from top companies like Facebook, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week. Try it today. Hired.​com In brief [Impact or No? A Simple Event Study in SQL, Part I](https://periscopedata.com/blog//timeseries-blog-sunny.html?utm_source=dbweekly&utm_medium=email) — Gnarly math becomes gnarly, but powerful, SQL. Periscopetutorial [Copying a Heroku Hosted Database To Your Local Machine (with Rake)](http://blog.mccartie.com/2016/03/22/copy-heroku-database-to-local.html?utm_source=dbweekly&utm_medium=email) — Pulls down a Postgres backup and restores it locally. Jon McCartietutorial [Embrace SQL with HugSQL, Clojure and PostgreSQL](https://compose.io/articles/embrace-sql-with-hugsql-clojure-and-postgresql/?utm_source=dbweekly&utm_medium=email) — Using annotated SQL to auto generate Clojure functions. Compose Articlestutorial [Simplifying Database Queries in Java and Scala with Jinq](http://www.infoq.com/news/2016/03/simple-database-queries-jinq?utm_source=dbweekly&utm_medium=email) InfoQtutorial [SQL Server in Windows Containers](https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/21/sql-server-in-windows-containers/?utm_source=dbweekly&utm_medium=email) SQL Server Database Engine Blogtutorial [Many-to-Many Relationships in NoSQL Databases](https://medium.com/@itsangaris/many-to-many-relationships-in-nosql-8c2b444e2b05?utm_source=dbweekly&utm_medium=email) Ilias Tsangaristutorial [How to Scale and Migrate Elasticsearch with Docker](https://medium.appbase.io/how-to-scale-and-migrate-elasticsearch-with-docker-10179930d7c9?utm_source=dbweekly&utm_medium=email) Sacheendra Talluritutorial [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=link&utm_term=findout+autoscaling+performance) — Redis auto-scaling & analytics. Backed by support from engineers with years of Redis scaling expertise. RedisGreentools sponsored [Filling Your Data Lake One Stream at a Time](http://www.datanami.com/2016/03/21/filling-data-lake-one-stream-time/?utm_source=dbweekly&utm_medium=email) — “You end up building your data lake one business use case at a time. You’re not going to start with 50 data sources.” Steve Wilkesopinion [Efficient Documentation using SQL Grammar Diagrams](https://www.cockroachlabs.com/blog/efficient-documentation-using-sql-grammar-diagrams/?utm_source=dbweekly&utm_medium=email) — A look at how different databases graph SQL queries using grammar diagrams. Matt Jibsonopinion [Building A Scalable Job Scheduler for Amazon Redshift](http://www.appuri.com/blog/building-a-scalable-job-scheduler-for-amazon-redshift?utm_source=dbweekly&utm_medium=email) — “We are huge fans of Amazon Redshift but one feature we found sorely missing was the ability to run scheduled jobs on the data warehouse.” Bilal Aslamopinion [Overcoming Spark Performance Challenges in Enterprise Hadoop Environments](http://www.datanami.com/2016/03/22/overcoming-spark-performance-challenges-enterprise-hadoop-environments/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [Datazenit: A MySQL and PostgreSQL Admin Tool](http://datazenit.com/?utm_source=dbweekly&utm_medium=email) — A (paid, but with trial) database administration tool with schema builder, data grid and charts. Datazenittools [PostgreSQL and Sphinx Search Seamless Integration](https://anadea.info/blog/postgresql-and-sphinx-search-seamless-integration?utm_source=dbweekly&utm_medium=email) — A look at an extension for Postgres that introduces Sphinx’s advanced full-text search features. Andrey Kutejkotutorial tools [From The Database Schema to RESTful API with DinGo](http://packagemain.blogspot.co.uk/2016/03/from-database-schema-to-restful-api.html?utm_source=dbweekly&utm_medium=email) — DinGo creates a Go-based microservice-style app starting from a MySQL database schema. Massimo Zerbinitools [Unlimited Scalability & Unprecedented Speed with In-Memory Computing](http://www.gridgain.com/products/in-memory-data-fabric/?utm_source=dbweekly&utm_medium=email) — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture. GridGain In-Memory Data Fabrictools sponsored [jpgAgent: A PostgreSQL Job Scheduler, Written in Java](https://github.com/Tostino/jpgAgent?utm_source=dbweekly&utm_medium=email) Adam Brusselbackcode [thanos: A Simple Demonstration of SQL Injection on a SQLite Database](https://github.com/prodicus/thanos?utm_source=dbweekly&utm_medium=email) Tasdik Rahmancode [Hacker News Data on Google Cloud Platform for Use with BigQuery](https://cloud.google.com/bigquery/public-data/hacker-news?utm_source=dbweekly&utm_medium=email) — All stories and comments from Hacker News since its launch. Googlecode [How Did MongoDB Get Its Name?](https://www.morpheusdata.com/blog/2016-03-15-how-did-mongodb-get-its-name-?utm_source=dbweekly&utm_medium=email) Morpheus    

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