DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 97 — March 24, 2016
Featured
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.
Ferruh Mavituna    tools   
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.
Manish R Jain
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.
Pete Corey
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.
EnterpriseDB    sponsored   
Exploring SQL Server 2016’s Powerful New Features — A practical look at SQL Server’s improved in-memory OLTP and Always Encrypted functionality.
vertabelo    news   
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.
John Regehr
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.
Bruce Momjian    news   
(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.”
Mathias Fussenegger    opinion   
Streaming SQL with PipelineDB [PDF] — PipelineDB is a database based off of Postgres but that adds continuous, streaming SQL query functionality.
Derek Nelson    news   
Field Definitions In Elasticsearch — 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 — 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.
2ndQuadrant
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.
Hired.​com
In brief
Impact or No? A Simple Event Study in SQL, Part I — Gnarly math becomes gnarly, but powerful, SQL.
Periscope    tutorial   
Copying a Heroku Hosted Database To Your Local Machine (with Rake) — Pulls down a Postgres backup and restores it locally.
Jon McCartie    tutorial   
Embrace SQL with HugSQL, Clojure and PostgreSQL — Using annotated SQL to auto generate Clojure functions.
Compose Articles    tutorial   
Simplifying Database Queries in Java and Scala with Jinq
InfoQ    tutorial   
SQL Server in Windows Containers
SQL Server Database Engine Blog    tutorial   
Many-to-Many Relationships in NoSQL Databases
Ilias Tsangaris    tutorial   
How to Scale and Migrate Elasticsearch with Docker
Sacheendra Talluri    tutorial   
Redis Performance Dashboard and Autoscaling from RedisGreen — Redis auto-scaling & analytics. Backed by support from engineers with years of Redis scaling expertise.
RedisGreen    tools    sponsored   
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.”
Steve Wilkes    opinion   
Efficient Documentation using SQL Grammar Diagrams — A look at how different databases graph SQL queries using grammar diagrams.
Matt Jibson    opinion   
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.”
Bilal Aslam    opinion   
Overcoming Spark Performance Challenges in Enterprise Hadoop Environments
Datanami    opinion   
Datazenit: A MySQL and PostgreSQL Admin Tool — A (paid, but with trial) database administration tool with schema builder, data grid and charts.
Datazenit    tools   
PostgreSQL and Sphinx Search Seamless Integration — A look at an extension for Postgres that introduces Sphinx’s advanced full-text search features.
Andrey Kutejko    tutorial    tools   
From The Database Schema to RESTful API with DinGo — DinGo creates a Go-based microservice-style app starting from a MySQL database schema.
Massimo Zerbini    tools   
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.
GridGain In-Memory Data Fabric    tools    sponsored   
jpgAgent: A PostgreSQL Job Scheduler, Written in Java
Adam Brusselback    code   
thanos: A Simple Demonstration of SQL Injection on a SQLite Database
Tasdik Rahman    code   
Hacker News Data on Google Cloud Platform for Use with BigQuery — All stories and comments from Hacker News since its launch.
Google    code   
How Did MongoDB Get Its Name?
Morpheus
« Prev
Next »