I'm in the process of evaluating the best technology stack for an appointment booking system, similar to that of Acuity and Calendly.
Does anyone have any experience using ES for this sort of thing?
Would it be possible to have an engine full of appointment documents, then run a query against those appointments to return a list of available time periods that aren't in the engine.
So for example let's say there were 3 appointments in the engine, 1 at 9 am, 1 at 12pm and 1 at 2pm.
Then let's say the appointment time is fixed at 1 hour, and appointments only ran between 9am and 5 pm.
Would elastic be able to analyze this request and return the following available times?
If so could you give a generalisation of how this would be achieved or even just guage the amount of work to run such a query?
I have a client that is looking to either build a MYSQL based solution in house, using generated tables, but also wants to consider ES.