Suppose in the killrvideo app I want to show all the movie theaters near to the user location, how would you model for such cases.
Suppose in the killrvideo app I want to show all the movie theaters near to the user location, how would you model for such cases.
Just finished the workshop and it's 4am for me right now but I just wanted to acknowledge receipt of your question and we'll respond in a few hours. Cheers!
One way you could achieve this is by using a geo-hash. You can implement this using only a Cassandra based data model with no need for other workloads within DataStax Astra.
Check out this video from the personal blog of one of our DataStax folks -> He starts with talking about how to do this with DataStax enterprise, but at around 6:00 talks about how to do this with Astra.
This video comes from his blog. Notice the June 2020 post -> https://github.com/farrell0/DataStax-Developers-Notebook/blob/master/README.md. Notice the Application program code link. Download, untar it, and within you will find some *.cql files with the needed data model to support geo-hashing with a purely Cassandra workload.
BTW, I am making some assumptions at what I think you might want to do with the information you provided
" I want to show all the movie theaters near to the user location"
which is why I am suggesting a geo-hash since you can use it to handle various methods of creating search boxes/polygons to find theatre or whatever locations.
Thanks David, I think you answered all of my queries, will give it a try shortly.
Great. I would definitely like to know how things turn out for you. Geo problems are pretty fun IMO.
8 People are following this question.
DataStax Enterprise is powered by the best distribution of Apache Cassandra ™
© 2022 DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.
Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.
Privacy Policy Terms of Use