---
title: "#186: How 'Meltdown' and 'Spectre' Will Impact Analytics"
publication: "DB Weekly"
issue: 186
published_at: "2018-01-12"
canonical_url: "https://dbweekly.com/issues/186"
---

Database Weekly 186   

This week's database news -[Read this on the Web](http://dbweekly.com/issues/186) 

[Database Weekly](http://dbweekly.com) Issue 186 — January 12, 2018     

[Scaling SQLite to 4M QPS on a Single Server](https://blog.expensify.com/2018/01/08/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. David Barrettstory [ViyaDB: An In-Memory Columnar Analytical Data Store](https://github.com/viyadb/viyadb) — An in-memory data store designed for fast, ad-hoc analytic queries and written in C++. Queried via a REST and JSON-powered API. ViyaDBcode [How to Query MongoDB with SQL?](https://nosqlbooster.com/runSQLQuery) — 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. NoSQLBoostersponsored [![\](https://copm.s3.amazonaws.com/350a9e88.png)](https://nosqlbooster.com/runSQLQuery) [How 'Meltdown' and 'Spectre' Will Impact Analytics](https://www.datanami.com/2018/01/08/meltdown-spectre-will-impact-analytics/) — Fixes for the recently revealed CPU security vulnerabilities are having varied impacts on performance. Datanaminews [PostgreSQL is DB Engines' 'DBMS of the Year' 2017](https://db-engines.com/en/blog_post/76) — 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. DB Enginesnews [In Major Shift, Amazon, Salesforce Move Away From Oracle?](https://www.theinformation.com/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. The Informationnews [Meltdown's Impact on Cassandra Latency](http://thelastpickle.com/blog/2018/01/10/meltdown-impact-on-latency.html) — Benchmarks showing a 20% latency increase for both reads and writes. Mick Semb Wevernews [Graph Databases Hit Wall Street](https://www.datanami.com/2018/01/08/graph-databases-hit-wall-street/) — They’re naturally suited to applications from risk assessment to portfolio management. Datanaminews [Webinar: Why We're Excited About MySQL 8.0](https://learn.percona.com/cp-why-were-excited-about-mysql-80-recording) Perconasponsored [Ransomware Attacks Against MySQL and How to Avoid Them](https://www.databasejournal.com/features/mysql/ransomware-attacks-against-mysql-and-how-to-avoid-them.html) Rob Gravelletutorial [Database Sharding Explained in Plain English](https://www.citusdata.com/blog/2018/01/10/sharding-in-plain-english/) Craig Kerstienstutorial [Elasticsearch Performance Tuning Practice at eBay](https://www.ebayinc.com/stories/blogs/tech/elasticsearch-performance-tuning-practice-at-ebay/) Pei Wangtutorial [Building a Serverless REST API with Node.js and MongoDB](https://hackernoon.com/building-a-serverless-rest-api-with-node-js-and-mongodb-2e0ed0638f47) Adnan Rahićtutorial [How to Import the Bitcoin Blockchain into Neo4j](https://neo4j.com/blog/import-bitcoin-blockchain-neo4j/) Greg Walkertutorial [Extending Redis with a Native Time Series Data Type](https://blog.yugabyte.com/extending-redis-with-a-native-time-series-data-type-e5483c7116f8) Pritam Damaniatutorial [3-Minute Test: What Do You Know About SQL Performance?](https://use-the-index-luke.com/3-minute-test) — Five questions to see how much you know about SQL performance. Never make these mistakes again. Markus Winandopinion [Three Reasons I Hate Booleans In Databases](https://medium.com/@jpotts18/3-reasons-i-hate-booleans-in-databases-646d99696580) Jeff Potteropinion [End-To-End Monitoring for Any Stack, at Any Scale. Try Free](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeeklyB) Datadogsponsored [LiteDB: A .NET NoSQL Document Store in a Single Data File](https://github.com/mbdavid/LiteDB#litedb---a-net-nosql-document-store-in-a-single-data-file) Mauricio Davidcode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/186) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK