#161: How Yelp Migrated to Elasticsearch

This week's database news - Read this on the Web

Database Weekly 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. Yelp Engineering   story   An Architectural Comparison of NoSQL Databases [PDF] — A white paper that compares and contrasts GridDB, Cassandra, MongoDB, Riak, and Couchbase. Fixstars   opinion   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 available. Apache RocketMQ   tools   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. MONGODB   sponsored   Introducing Dexter: An Automatic Indexer for Postgres — By monitoring queries this tool will generate queries to improve their performance. Andrew Kane   tutorial   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? Neha Narkhede   tutorial   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. Giovanni Damiola   story   Using Emoji in SQL — This doesn’t sound like a great idea but it does work, at least with SQLite and PostgreSQL 9.6. Cristian Baldi   tutorial   Whitepaper: 5 Steps to Agile Database Management — Database Management is years behind software development. Here's how to bring your DBs up to speed. SelectStar   sponsored   Kinetica Gets $50M for GPU-Accelerated, In-Memory Analytics Datanami   news   MySQL Tops Database Rankings George Leopold   news   Building SQL Queries for Funnel Analysis — How Statsbot constructs SQL queries for conversion funnel analysis. Nurzhan Ospanov   tutorial   An Introduction to Temporary Tables in SQL Server Ben Richardson   tutorial   Inside A Shopping Center Relational Data Model Vertabelo   tutorial   Recommending GitHub Repos with Google BigQuery and 'implicit' Juarez Bochi   tutorial   The Brain of Every Database: Using Statistics to Guide Query Optimization Tim Zimmermann   tutorial   How Qubit Deduplicates Streaming Data At Scale with Google Cloud Platform Google Cloud Platform   story   Postgres 10 Beta vs Postgres 9.6 Analytics Performance — How does the latest version of Postgres, still in beta, fare performance-wise? Kaarel Moppel   opinion   Autoscaling for your Heroku dynos — Automatically scale up and down to handle increased workloads and avoid wasting money on idle resources. HireFire   tools  sponsored   ind3xlite: SQLite3-Based Command-Line Fulltext Indexer and Searcher GitHub   tools   Building A Versatile Analytics Pipeline on Top of Apache Spark Misha Chernetsov / Grammarly   video   A Roundup of Core Apache Cassandra Concepts Tomer Ben David   video   Database Weekly is curated by Peter Cooper Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK