Issue 186 — January 12, 2018
Scaling SQLite to 4M QPS on a Single Server
— Tips and tricks for scaling SQLite for 4M real-ish queries per second on a single server, and how bare metal compares to EC2 for this workload.
ViyaDB: An In-Memory Columnar Analytical Data Store
— An in-memory data store designed for fast, ad-hoc analytic queries and written in C++. Queried via a REST and JSON-powered API.
How to Query MongoDB with SQL?
— This post is a step by step tutorial on how to run SQL SELECT Query against MongoDB with NoSQLBooster. SQL support includes SQL functions, expressions, aggregation for collections with nested objects and arrays.
How 'Meltdown' and 'Spectre' Will Impact Analytics
— Fixes for the recently revealed CPU security vulnerabilities are having varied impacts on performance.
PostgreSQL is DB Engines' 'DBMS of the Year' 2017
— Postgres might not be new, but its popularity has increased in the last year, fuelled by some fantastic releases, like Postgres 10, and its newest features.
In Major Shift, Amazon, Salesforce Move Away From Oracle?
— Sorry, most of the story is behind a paywall, but in a nutshell it seems Amazon and Salesforce are making ‘significant progress’ in getting off Oracle’s technology.
Meltdown's Impact on Cassandra Latency
— Benchmarks showing a 20% latency increase for both reads and writes.
Mick Semb Wever
Graph Databases Hit Wall Street
— They’re naturally suited to applications from risk assessment to portfolio management.
Webinar: Why We're Excited About MySQL 8.0
Ransomware Attacks Against MySQL and How to Avoid Them
Database Sharding Explained in Plain English
Elasticsearch Performance Tuning Practice at eBay
Building a Serverless REST API with Node.js and MongoDB
How to Import the Bitcoin Blockchain into Neo4j
Extending Redis with a Native Time Series Data Type
3-Minute Test: What Do You Know About SQL Performance?
— Five questions to see how much you know about SQL performance. Never make these mistakes again.
Three Reasons I Hate Booleans In Databases
End-To-End Monitoring for Any Stack, at Any Scale. Try Free
LiteDB: A .NET NoSQL Document Store in a Single Data File