Elasticsearch — Why and How

Andrea Gioco
Sep 9, 2018 · 7 min read

Use case #1: Text search

SELECT content_id FROM content WHERE title LIKE ‘%string%’ OR content LIKE ‘%string%’ OR …

Solution

Use case #2: Typeahead with suggester

SELECT location_id, location FROM location WHERE location LIKE “string%” ORDER BY location;

Solution

Use case #3: Position search with radius

Solution

Use case #4: Search points within a border

Solution

Give me all the points contained in a specific shape

Any other use case?

How did I interface my PHP application with Elasticsearch?

Kibana console tool

The end.

Andrea Gioco

Written by

Software engineer, Born in Milan, Live in London, PHP, Java and Flutter

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade