Issue 121 — September 9, 2016
InfluxDB 1.0 GA Released: A Retrospective and What’s Next
— InfluxDB is an open source time series database with no external dependencies that’s useful for recording metrics, events, and performing analytics.
Dumb Tricks to Save Database Space
— Don’t store UUIDs as text, use smaller number types, use enums, avoid overusing JSON, and more.
Apache Hadoop 3.0 Alpha 1 Released
— The first in a series of planned alphas and betas. This isn’t ready for production use.
Join us at DataLayer
— Hear speakers from GitHub, Artsy, ZenDesk and many others as they discuss how their teams are optimizing the data layer to scale modern web and mobile apps. Reserve your seat now for this one day event on Sept. 28 in Seattle.
Compose | DataLayer
ScyllaDB Revamps NoSQL Database in 1.3 Release
— The drop-in replacement for Apache Cassandra boasts sub 1 millisecond 99% latency, 10x throughput of Cassandra, self-tuning, and more.
Code Generation: The Inner Sanctum of Database Performance
— Drew Paroski, architect and engineering manager at MemSQL, reflects on how human readable SQL queries are compiled to native code and what benefits this brings.
Yahoo Open-Sourcing Pulsar, Pub-Sub Messaging at Scale
— Pulsar is a highly scalable, low latency pub-sub messaging system running on commodity hardware. It seems to fill a similar niche to Apache Kafka.
Elasticsearch, The Server
— Reflections how Elasticsearch has evolved into a powerful search and analytics engine and how embedded Elasticsearch will no longer be supported.
Find Your Perfect Company Match
— You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies.
Improved Automatic Tuning Boosts Azure SQL Database Performance
— Azure SQL will ‘learn and adapt’ to fit applications and self-optimize its settings for better performance.
MapR Appoints New CEO, Preps for 'Hypergrowth'
PostgreSQL 9.6 RC 1 Released
— The first release candidate of Postgres 9.6 is here, which means we’re not far away from the full release. Help the community out by giving it a try.
DreamFactory 2.3 released, includes PHP 7, Cassandra, Redis
— This release includes major enhancements, including PHP 7, new APIs for Cassandra, Redis, and Memcached, and queued event scripts.
A Beginner's Guide to Hadoop Storage Formats (or File Formats)
A Simple Sentiment Analysis Prototype Using Elasticsearch
Fun With SQL Constraints
Calculating Proportional Values in SQL
Database Design: Relation Predicates and 'Identical Relations'
Querying Non-Existent MongoDB Fields
— A look at a subtle potential vulnerability.
FaRM: A Design for 'Fast Remote Memory'
— A high level overview of a paper describing an in-memory distributed computing platform.
NoSQL Is Ideal Database for Mobile Apps, Says Couchbase's Chief Mobile Architect
Open Source Time-Series Database Benchmarks
How can you help your team write better, shareable SQL faster?
— Learn more with our free video tips showing how SQL Prompt lets you write, refactor, and share SQL.
Apache Arrow: Columnar In-Memory Analytics
pg_cron: Run Periodic Jobs in PostgreSQL