How SQL Could Drive You Mad: Elastic Search

Elastic Search saves many SQL headaches. Follow my journey of adding ES to the codehire.com Rails app. I go through how different representations of the same data can make life easier in different contexts.

Transcript

1. H O W S Q L C O U L D D R I V E Y O U M A D E L A S T I C S E A R C H
2. http://coderdan.co @danieldraper
15. https://github.com/ankane/searchkick SEARCHKICK
19. N O M O R E D I R T Y S Q L !
20. Q U E RY P E R F O R M A N C E Avg. Query Time (ms) 0 3.5 7 10.5 14 PostgreSQL ES
22. T H E P O W E R O F E L A S T I C • Keyword Analysis + Matching • Facets (e.g. locations with these tags) • Suggestions (“Did you mean”) • Similar Records
23. D A TA L A Y E R Complex, structured Domain Driven Model Optimised for CRUD N O R M A L I S E D S E A R C H L A Y E R Simple, unstructured Document Oriented Optimised for Search/Analysis D E - N O R M A L I S E D
24. http://coderdan.co @danieldraper HAPPY SEARCHING!