DB Weekly Issue 97: March 24, 2016

SQL Injection Cheat Sheet — 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.

DGraph: Scalable, Distributed, Low Latency, High Perf Graph DB — 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.

NoSQL Injection in Modern Web Applications — An hour long talk looking at the security of NoSQL databases, what NoSQL ‘injection’ entails, and how to both attack and fix an app.

Open Arms for Open Source: Dell SharePlex and EnterpriseDB Team Up — 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.

Exploring SQL Server 2016’s Powerful New Features — A practical look at SQL Server’s improved in-memory OLTP and Always Encrypted functionality.

SQLite with a Fine-Toothed Comb — 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.

Oracle Attacking Postgres in Russia? — 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.

(Abusing) Elasticsearch as a Framework — "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."

Streaming SQL with PipelineDB [PDF] — PipelineDB is a database based off of Postgres but that adds continuous, streaming SQL query functionality.

Field Definitions In Elasticsearch — Elasticsearch isn’t just for storing text documents, it can deal with arrays, nested datatypes, geo-location information, and more.

PostgreSQL Developers, Consultants & Support DBAs at 2ndQuadrant — 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.

Stop Applying to Jobs - Let Companies Apply to You — 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.

Impact or No? A Simple Event Study in SQL, Part I — Gnarly math becomes gnarly, but powerful, SQL.

Copying a Heroku Hosted Database To Your Local Machine (with Rake) — Pulls down a Postgres backup and restores it locally.

Embrace SQL with HugSQL, Clojure and PostgreSQL — Using annotated SQL to auto generate Clojure functions.

Simplifying Database Queries in Java and Scala with Jinq

SQL Server in Windows Containers

Many-to-Many Relationships in NoSQL Databases

How to Scale and Migrate Elasticsearch with Docker

Redis Performance Dashboard and Autoscaling from RedisGreen — Redis auto-scaling & analytics. Backed by support from engineers with years of Redis scaling expertise.

Filling Your Data Lake One Stream at a Time — "You end up building your data lake one business use case at a time. You’re not going to start with 50 data sources."

Efficient Documentation using SQL Grammar Diagrams — A look at how different databases graph SQL queries using grammar diagrams.

Building A Scalable Job Scheduler for Amazon Redshift — "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."

Overcoming Spark Performance Challenges in Enterprise Hadoop Environments

Datazenit: A MySQL and PostgreSQL Admin Tool — A (paid, but with trial) database administration tool with schema builder, data grid and charts.

PostgreSQL and Sphinx Search Seamless Integration — A look at an extension for Postgres that introduces Sphinx’s advanced full-text search features.

From The Database Schema to RESTful API with DinGo — DinGo creates a Go-based microservice-style app starting from a MySQL database schema.

Unlimited Scalability & Unprecedented Speed with In-Memory Computing — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture.

jpgAgent: A PostgreSQL Job Scheduler, Written in Java

thanos: A Simple Demonstration of SQL Injection on a SQLite Database

Hacker News Data on Google Cloud Platform for Use with BigQuery — All stories and comments from Hacker News since its launch.

How Did MongoDB Get Its Name?