News for hackers. Stuff that matters.

A comment on PredictionIO – open source machine learning for predictive features. Parent comment

Re:PredictionIO – open source machine learning for predictiv... by dszeto on Thursday April 10, 2014 @12:11PM (#7567401)
We picked MongoDB a while ago because of its built in geospatial indexing support. Would be happy to add support of other databases. Any strong candidates on top of your head?
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by saosebastiao on Thursday April 10, 2014 @12:42PM (#7567695)
Both Postgres and SQLite have extensive geospatial support (PostGIS and SpatiaLite respectively), including indexing and boatloads of useful geospatial functions. And in my experience, both of them are far more advanced than Mongo's geospatial support.
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by duaneb on Thursday April 10, 2014 @01:12PM (#7567984)
I haven't worked with geospatial databases as much (so verify this with someone who has), but Postgres is a good bet for an alternative to mongo in this scenario.
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by yaph on Thursday April 10, 2014 @12:18PM (#7567476)
PostgreSQL / PostGIS
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by todazar on Thursday April 10, 2014 @12:36PM (#7567636)
RethinkDB!
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by bduerst on Thursday April 10, 2014 @01:08PM (#7567928)
I know it's a pain to get data into it, but how about Big Query?
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by tstonez on Thursday April 10, 2014 @01:36PM (#7568194)
Ideally open-source. Surprised MongoDB 2.2+ is such an issue but thanks for the feedback and suggestions. We'll look into PostgreSQL, Riak and RethinkDB.
[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by bduerst on Thursday April 10, 2014 @01:47PM (#7568293)
It is based on an open-sourced db called Dremel:

https://code.google.com/p/dremel/

[ Parent | on HN ]
Re:PredictionIO – open source machine learning for predictiv... by yipjustin on Thursday April 10, 2014 @02:20PM (#7568573)
But dremel doesn't support incremental updates. Dremel is designed for read-only data. All its columns are indexed. The whole table needs to be re-built after update.
[ Parent | on HN ]