Hello, To be clear and transparent - I know very little about ES. I would normally lurk around, but figure I might as well ask.
I have a project that I think would be a good fit for ES, but wondering to what extent. I'd like to use ES for what it is really good at vs trying to make it work in other situations. The project is www.lionseek.com One part of me thinks that ES would be best if I used it only when a visitor conducts a text search and thereby replacing a fulltext search via mysql. The search query would tap into the ES index which updates every minute or so and the results would be displayed. The other part of me thinks that ES can be used for much more. Basically every time a page is rendered, ES is involved in one way or another regardless if a search term/parameter is entered. A concern I do have (with my very very limited knowledge of ES) is how relative timestamps would be used. For a specific example: 1) let's say that Lionseek indexes content from a forum 2) it knows that the time of the posting is 9am today 3) the timezone of the forum is in San Francisco (UTC-08:00) 4) a time offset is entered 5) a relative time is shown to the visitor - i.e. 'updated 2 hours ago' In MySQL we would do a sum() and join. We'd sum up the offset and the posted_time column as normalized_time. In ES, it seems that can't be done? ES uses UTC as the timezone and that seems unchangeable. Maybe a new field needs to be added? Thanks for taking the time to read through this and my ultimate question in the end is.... to what extent do you see ES being integrated into a project like Lionseek? I know it's asking a lot, but I'm hoping the gurus here can point to things they see and say... 'Well, I think ES would be an excellent component to help you in [this] regard or [that] regard.' -Tom -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/39943803-1918-4843-97ca-6c532925f47d%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
