--- title: "#161: How Yelp Migrated to Elasticsearch" publication: "DB Weekly" issue: 161 published_at: "2017-06-30" canonical_url: "https://dbweekly.com/issues/161" --- Database Weekly 161 This week's database news -[Read this on the Web](http://dbweekly.com/issues/161) [Database Weekly](http://dbweekly.com) Issue 161 — June 30, 2017 [Moving Yelp's Core Search to Elasticsearch](https://engineeringblog.yelp.com/2017/06/moving-yelps-core-business-search-to-elasticsearch.html?utm_source=dbweekly&utm_medium=email) — A post mortem of Yelp’s successful migration to Elasticsearch from a custom system built on top of Lucene. Yelp Engineeringstory [An Architectural Comparison of NoSQL Databases [PDF\]](https://griddb.net/en/docs/NoSQL_Database_Architectural_Comparison.pdf?utm_source=dbweekly&utm_medium=email) — A white paper that compares and contrasts GridDB, Cassandra, MongoDB, Riak, and Couchbase. Fixstarsopinion [Apache RocketMQ: A Distributed Messaging and Streaming Data Platform](https://rocketmq.incubator.apache.org/?utm_source=dbweekly&utm_medium=email) — Targeting Java, .NET and C++ users and aims to work around scaling issues in Kafka and ActiveMQ. There’s [a comparison table](https://rocketmq.incubator.apache.org/docs/motivation/) available. Apache RocketMQtools [Get started with MongoDB](https://resources.mongodb.com/getting-started-with-mongodb?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=primary&utm_medium=display&utm_source=dbweekly0630) — We've put together a hub of our most popular resources to help jump-start your understanding of MongoDB. [Check it out](https://resources.mongodb.com/getting-started-with-mongodb?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=primary&utm_medium=display&utm_source=dbweekly0630). MONGODBsponsored [![\](https://copm.s3.amazonaws.com/27d3b8da.png)](https://resources.mongodb.com/getting-started-with-mongodb?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=primary&utm_medium=display&utm_source=dbweekly0630) [Introducing Dexter: An Automatic Indexer for Postgres](https://medium.com/@ankane/introducing-dexter-the-automatic-indexer-for-postgres-5f8fa8b28f27?utm_source=dbweekly&utm_medium=email) — By monitoring queries this tool will generate queries to improve their performance. Andrew Kanetutorial [Exactly-Once Semantics Is Possible: Here's How Apache Kafka Does It](https://www.confluent.io/blog/exactly-once-semantics-are-possible-heres-how-apache-kafka-does-it/?utm_source=dbweekly&utm_medium=email) — Kafka 0.11 has implemented ‘exactly-once semantics’, a significant feature. But how? Neha Narkhedetutorial [Making The Internet Archive’s Full Text Search Faster](https://medium.com/@giovannidamiola/making-the-internet-archives-full-text-search-faster-30fb11574ea9?utm_source=dbweekly&utm_medium=email) — 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 Damiolastory [Using Emoji in SQL](http://baldi.me/blog/emoji-in-sql?utm_source=dbweekly&utm_medium=email) — This doesn’t sound like a _great_ idea but it does work, at least with SQLite and PostgreSQL 9.6. Cristian Balditutorial [Whitepaper: 5 Steps to Agile Database Management](https://selectstar.io/campaigns/mini-pages/5-steps-to-a-more-agile-database-management.html) — Database Management is years behind software development. Here's how to bring your DBs up to speed. SelectStarsponsored [Kinetica Gets $50M for GPU-Accelerated, In-Memory Analytics](https://www.datanami.com/2017/06/29/kinetica-gets-50m-converged-gpu-analytics/?utm_source=dbweekly&utm_medium=email) Datanaminews [MySQL Tops Database Rankings](https://www.datanami.com/2017/06/28/mysql-tops-database-rankings/?utm_source=dbweekly&utm_medium=email) George Leopoldnews [Building SQL Queries for Funnel Analysis](https://blog.statsbot.co/sql-queries-for-funnel-analysis-35d5e456371d?utm_source=dbweekly&utm_medium=email) — How Statsbot constructs SQL queries for conversion funnel analysis. Nurzhan Ospanovtutorial [An Introduction to Temporary Tables in SQL Server](http://codingsight.com/introduction-to-temporary-tables-in-sql-server/?utm_source=dbweekly&utm_medium=email) Ben Richardsontutorial [Inside A Shopping Center Relational Data Model](http://www.vertabelo.com/blog/technical-articles/inside-a-shopping-center-data-model?utm_source=dbweekly&utm_medium=email) Vertabelotutorial [Recommending GitHub Repos with Google BigQuery and 'implicit'](https://medium.com/towards-data-science/recommending-github-repositories-with-google-bigquery-and-the-implicit-library-e6cce666c77?utm_source=dbweekly&utm_medium=email) Juarez Bochitutorial [The Brain of Every Database: Using Statistics to Guide Query Optimization](https://medium.com/hyrise/the-brain-of-every-database-c622aaba7d75?utm_source=dbweekly&utm_medium=email) Tim Zimmermanntutorial [How Qubit Deduplicates Streaming Data At Scale with Google Cloud Platform](https://cloud.google.com/blog/big-data/2017/06/how-qubit-deduplicates-streaming-data-at-scale-with-google-cloud-platform?utm_source=dbweekly&utm_medium=email) Google Cloud Platformstory [Postgres 10 Beta vs Postgres 9.6 Analytics Performance](http://www.cybertec.at/a-quick-check-on-postgres-10-beta-analytics-performance-vs-version-9-6/?utm_source=dbweekly&utm_medium=email) — How does the latest version of Postgres, still in beta, fare performance-wise? Kaarel Moppelopinion [Autoscaling for your Heroku dynos](https://www.hirefire.io?utm_source=dbweekly&utm_medium=email) — Automatically scale up and down to handle increased workloads and avoid wasting money on idle resources. HireFiretools sponsored [ind3xlite: SQLite3-Based Command-Line Fulltext Indexer and Searcher](https://github.com/namibj/ind3xlite?utm_source=dbweekly&utm_medium=email) GitHubtools [Building A Versatile Analytics Pipeline on Top of Apache Spark](https://tech.grammarly.com/blog/building-a-versatile-analytics-pipeline-on-top-of-apache-spark?utm_source=dbweekly&utm_medium=email) Misha Chernetsov / Grammarlyvideo [A Roundup of Core Apache Cassandra Concepts](https://www.youtube.com/watch?v=Mvsy2DZhKSw&utm_source=dbweekly&utm_medium=email) Tomer Ben Davidvideo Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/161) [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