DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 100 — April 14, 2016
Featured
Analyzing the Panama Papers with Neo4j — A look at how a graph database has major strengths to deep dive into large, interconnected collections of documents like the Panama Papers.
Michael Hunger and William Lyon    tutorial   
Scaling a MySQL Datastore By 20x+ in 3 Weeks — The tale behind how a team rapidly scaled their MySQL-based datastore and the problems and tools they encountered along the way.
Christine Spang    story   
PostgreSQL Bloat: Origins, Monitoring and Managing — PostgreSQL's MVCC model supports running multiple transactions operating on the same data set, but questions have arisen around bloat. Here's a look at how it can affect performance and how to monitor and manage it.
Compose    sponsored   
Do GPU Optimized DBs Threaten Oracle, Splunk and Hadoop? — GPU optimized databases are moving from science project to business reality, but what does that mean?
Kurt Marko    opinion   
MySQL 5.7.12: Big Steps Forward for MySQL? — The usual bug fixes and enhancements expected with a point release, but a new protocol and a new MySQL Shell are also emerging.
Mike Frank    news   
How The Guardian Analyzed 70m Comments On Its Site — A brief, high level look. It required joining together their AWS-hosted Postgres database, Redshift, CSV files, and Apache Spark.
Mahana Mansfield    news   
PostgreSQL Query Optimization — For many, what happens when you join two tables is a mystery. Once you do build a deeper understanding, it becomes much easier to optimize joins - luckily it’s not rocket science to understand some of the logic under the covers, as seen here.
Jincheng Li
Jobs
Work on a Better Stack — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 3,500+ companies instantly.
Hired.​com
In brief
AWS Schema Conversion Tool Now Supports Conversions Between MySQL and PostgreSQL
Amazon Web Services    news   
Securely Modernizing Employee Access Management with Graph Databases
Datanami    news   
What Does PostgreSQL 9.5 Bring to Developers
Petar Partlov    news   
The Ancient Greek Guide to Re-Negotiating with Oracle — Learn valuable tips from the CEO of Palisade Compliance, Craig Guarente, a 16-year licensing veteran from Oracle.
EnterpriseDB    tutorial    sponsored   
Using SQL to Calculate the Popularity (on Stack Overflow) of Derby, H2, and HSQLDB
jooq.​org    tutorial   
ElasticSearch Cluster Rolling Restart at the Speed of Light
Frederic de Villamil    tutorial   
How We Get High Availability with Elasticsearch and Ruby on Rails
18F Digital Services    tutorial   
A Developers' Guide to Azure SQL Data Warehouse
Microsoft    video   
Urban Myths About SQL (2015) (slidedeck)
Michael Stonebraker    opinion   
The Unspoken Complexity of NoSQL
Pjuu    opinion   
Could PostgreSQL 9.5 Be Your Next JSON Database? — TL;DR: No, but that’s not the right question.
Dj Walker-Morgan    opinion   
Mongoclient: A MongoDB Management Tool
Sercan Özdemir    tools   
Sqlectron: A Simple DB Client for Postgres, MySQL and SQL Server — A simple and lightweight SQL client desktop/terminal with cross database and platform support.
Sqlectron    tools   
PGInsight: CLI Tool to Dig Inside Your Postgres Databases — Easily dig deep inside your Postgresql database. Features include finding index information, disk usage, cache hits and more.
Khalid Lafi    tools   
Auto-generated APIs for any database — Powerful API automation for standardization, portability, and scale. Free dev environment for testing and rapid prototyping.
DreamFactory    tools    sponsored   
Corvus: Fast and Lightweight Redis Cluster Proxy for Redis 3.0
eleme    code   
gredis: A Redis Server built over grpc
Abhijeet Mohan    code   
jseg: JavaScript Entity Graph — A super simple, in-memory, JS graph database.
Brandon Bloom    code   
Data Modeling in Cassandra From A Postgres Perspective — Usually we highlight articles of people moving from other systems to Postgres, in a contrast here’s how to apply a Postgres perspective to a database that doesn’t lend quite the same flexibility–Cassandra.
neovintage.​org
An SQL Joins Visualizer — A simple, but very clear tool to visually explain joins in SQL.
Alexey Vasiliev
« Prev
Next »