DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
Issue 74 — October 9, 2015
Featured
Why SQL Is Simply Awesome — Lukas Eder, founder of Data Geekery, waxes lyrical on SQL and dispels some commonly repeated fallacies while looking at its strengths.
Lukas Eder
Couchbase 4.0 Released, Adds Multi Dimensional Scaling and More — Couchbase 4.0 is available, bringing secondary indexes, geo-spatial indexes, workload isolation, and a new storage engine.
ZDNet
You Probably Don’t Use SQL INTERSECT or EXCEPT Often Enough — While JOIN operations are much more versatile, they are also more complex for the simple tasks that can be solved by UNION, INTERSECT, and EXCEPT.
Data Geekery
Redis Performance Dashboard and Autoscaling from RedisGreen — Ever wonder what your Redis server was actually doing? Find out with RedisGreen's dashboard and monitoring tools.
RedisGreen    sponsored   
How Airbnb Partitioned Its Main Database in Two Weeks — A walk through how Airbnb used MySQL’s replication on Amazon RDS to partition the database with only brief downtime and without writing any bookkeeping or migration code.
Airbnb Engineering
What PostgreSQL Has Over Other Open Source SQL Databases — First in a series of posts looking at Postgres’ strengths. In this outing, it looks at the storage of data.
Compose    opinion   
AWS Database Migration Service — Amazon has unveiled a preview of a new AWS service to help you migrate databases to AWS without any downtime. It supports all widely used databases.
Amazon    tools    news   
SpaceCurve: An Utterly Unique And Absurdly Fast Geospatial Database — “SpaceCurve is a prototype of a new class of database architecture. It fuses two novel computer science foundations that make it optimal for workloads that mix extremely high concurrent write rates with low-latency parallel queries.”
J.​ Andrew Rogers
How to Make a Box-and-Whisker Plot in SQL — Understanding how your data is distributed is critical for any analysis. Box-and-whisker plots are great for summarizing distributions and comparing distributions across datasets. Here’s how to create them in SQL.
Benn Stancil
Jobs
Want to spend less time job searching? Apply to the best startups in 60 seconds. — If you’re accepted, startup decision-makers will email you as soon as next Monday. You decide where to interview and where to work. Now open in SF, NYC, and remote. Join the Underdog.io platform today!
Underdog.​io
In brief
Amazon QuickSight: Fast & Easy to Use Business Intelligence for Big Data
Amazon    tools    news   
Caching a MongoDB Database with Redis
SitePoint    tutorial   
Easy Load-Balancing and High-Availability using MySQL Router
MySQL High Availability    tutorial   
Combined Row-Based and Columnar Storage in PostgreSQL 9.5
Citus Data    tutorial   
Introduction to Redis Data Structures: Sets
Vaibhaw    tutorial   
Protecting MySQL Passwords with the sha256_password Plugin
MySQL Server Blog    tutorial   
Clash of the Titans: MapReduce vs. Spark for Large Scale Data Analytics [PDF] — An academic paper
Shi, Qiu, Minhas, et al.​
Redis Keys in RAM — A funny Dr Seuss style tribute to Redis.
RedisLabs
PostgreSQL Monitoring Cheatsheet
Russ Garrett
Ask HN: Anything Better Than Tableau for Data Viz, Dashboards?
Hacker News    opinion   
Ask HN: Implementing a graph database using Postgres tables for nodes and edges?
Hacker News
Store Your User Data Easily and Securely. No Database Needed. — Why build, secure, and maintain a database just for user data? Stormpath stores user profiles easily and securely, with up to 10MB of custom JSON data.
Stormpath    tools    sponsored   
SampleClean: Fast and Accurate Query Processing on Dirty Data
sampleclean.​org    tools   
libsl3: A C++ wrapper for SQLite3
bitbucket.​org    code   
« Prev
Next »