Search engines and import data formats
Version 3 - Updated on 26 Oct 2017 at 8:54PM by Joachim Hansen
Description
Sphinx
Support indexing SQL databases
http://sphinxsearch.com/docs/latest/quick-tour.html
http://sphinxsearch.com/docs/latest/features.html
Practical example:
https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-16-04
Solr
"
Solr natively supports indexing structured documents in XML, CSV and JSON.
"
https://lucene.apache.org/solr/guide/6_6/uploading-data-with-index-handlers.html
Tutorial below for indexing and searching
https://lucene.apache.org/solr/guide/7_0/solr-tutorial.html#exercise-1
Elasticsearch
Can load/import JSON documents in bulk
https://www.elastic.co/guide/en/elasticsearch/reference/current/_exploring_your_data.html
The URL above also contains a sample dataset
Practical exercises in
https://www.elastic.co/blog/a-practical-introduction-to-elasticsearch