Issue 161 — June 30, 2017
Moving Yelp's Core Search to Elasticsearch
— A post mortem of Yelp’s successful migration to Elasticsearch from a custom system built on top of Lucene.
An Architectural Comparison of NoSQL Databases [PDF]
— A white paper that compares and contrasts GridDB, Cassandra, MongoDB, Riak, and Couchbase.
Apache RocketMQ: A Distributed Messaging and Streaming Data Platform
— Targeting Java, .NET and C++ users and aims to work around scaling issues in Kafka and ActiveMQ. There’s
a comparison table
Get started with MongoDB
— We've put together a hub of our most popular resources to help jump-start your understanding of MongoDB.
Check it out
Introducing Dexter: An Automatic Indexer for Postgres
— By monitoring queries this tool will generate queries to improve their performance.
Exactly-Once Semantics Is Possible: Here's How Apache Kafka Does It
— Kafka 0.11 has implemented ‘exactly-once semantics’, a significant feature. But how?
Making The Internet Archive’s Full Text Search Faster
— How the Internet Archive made their full-text organic search faster — without scaling horizontally — allowing users to search across 35 million documents in seconds.
Using Emoji in SQL
— This doesn’t sound like a
idea but it does work, at least with SQLite and PostgreSQL 9.6.
Whitepaper: 5 Steps to Agile Database Management
— Database Management is years behind software development. Here's how to bring your DBs up to speed.
Kinetica Gets $50M for GPU-Accelerated, In-Memory Analytics
MySQL Tops Database Rankings
Building SQL Queries for Funnel Analysis
— How Statsbot constructs SQL queries for conversion funnel analysis.
An Introduction to Temporary Tables in SQL Server
Inside A Shopping Center Relational Data Model
Recommending GitHub Repos with Google BigQuery and 'implicit'
The Brain of Every Database: Using Statistics to Guide Query Optimization
How Qubit Deduplicates Streaming Data At Scale with Google Cloud Platform
Google Cloud Platform
Postgres 10 Beta vs Postgres 9.6 Analytics Performance
— How does the latest version of Postgres, still in beta, fare performance-wise?
Autoscaling for your Heroku dynos
— Automatically scale up and down to handle increased workloads and avoid wasting money on idle resources.
ind3xlite: SQLite3-Based Command-Line Fulltext Indexer and Searcher
Building A Versatile Analytics Pipeline on Top of Apache Spark
Misha Chernetsov / Grammarly
A Roundup of Core Apache Cassandra Concepts
Tomer Ben David