Has anyone used mariaDB for storing spatial data? I am using postgis now. My queries are mostly "finding peope within certain radius". Happn app an app which shows you "the people you crossed path with in real life" seems to be using MariaDB in their stack.Should I move to MariaDB for perfomance?
MariaDB/MySQL have about 160 spatial operators:
Whereas PostGIS adds about 600 to PostgreSQL:
PostgreSQL/PostGIS is extremely feature complete from a spatial perspective, so it allows you to do a lot. But PostgreSQL is also a very large enterprise level database engine.
MySQL/MariaDB are much more lean, more simple and lightweight.
As for performance, I imagine if the function can be done with both, the speed will be pretty comparable.
If you are already using MariaDB and just need a few spatial operators, no point switching over the PostgreSQL. But if you are doing full GIS operations in the database, PostgreSQL/PostGIS is the best choice.