Issue 107 — June 2, 2016
SQL Server 2016 Now Generally Available
— Includes updateable, in-memory columnstores, R integration, and improved cross-platform analytics (such as with
Comparing CHAR and VARCHAR Types in Different DB Engines
— Database storage engines frequently spring up surprises - this roundup looks at the various ways MySQL, SQLite, Postgres, Oracle and SQL Server deal with CHAR and VARCHAR types.
See inside your Redis database. New memory mapping from RedisGreen
— RedisGreen builds a map of your Redis memory usage, tracking the size of keys over time, helping you track down problems and gain new insights.
BigBash: Convert SQL SELECTs to Bash One-Liners
— Converts select statements to Bash one-liners that are executable directly on CSV, log files & similar files.
Looking Inside The MySQL 5.7 Document Store
— A quick demonstration of how MySQL’s new document storage feature works.
Extending The Redis Database
— A 10 minute discussion with Redis creator Salvatore Sanfilippo about Redis’ new module system.
Monitoring Cassandra at Scale
— Yelp uses Cassandra heavily and while it’s built to deal with failure, robust monitoring is essential at their scale.
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.
Big Data and the Cloud: Uncover New Insights Hiding in Your Data
Export Redis Snapshots from ElastiCache to Amazon S3
On-demand Webinar: Turbocharge Your SQL Queries In-Memory with Apache® Ignite™
— Learn how to boost performance 1,000X and scale to over 1 billion transactions per second with your SQL-based applications.
GridGain In-Memory Data Fabric
Building an Application with CockroachDB and SQLAlchemy
5 Useful Tips to Make Your Hadoop Deployment Robust
Setting Up Elasticsearch for a Blog
Using Elasticsearch Aggregations for Analytics
Mutating Table Error In Oracle: Why It Happens And What You Can Do About It
Redesigning A Notification System using Postgres
Merging Batch and Stream Processing in a Post Lambda World
One Call to Rule Them All
— Access SQL and NoSQL databases across multiple servers with a singular REST API. Free, open source platform.
ElectroCRUD: A Modern MySQL CRUD Application
libsqlfs: Implements A POSIX-Style Filesystem on top of SQLite
Miniredis: A Pure Go Redis Server, Ideal for Unit Tests
How Netflix Caches App Data Using SSDs
The Netflix Tech Blog