All geek questions in one place

Does the google application support the mysql (Cloud SQL) engine?

I tried to find some documentation about this on the application engine and sql cloud sites, but cannot find anything referring to it anyway. I know that you can execute GIS queries with your custom sql parameter, and I know that mysql supports GIS out of the box, but I also know that this requires some C libraries for which there is limited support.

In particular, I am interested to know if geo-django supports the use of mysql gis using the sql application / cloud combination. (Or maybe if their custom offer supports geodjango?)

+4
source share
2 answers

GeoDjango with Cloud SQL is not supported. GeoDjango depends on several libraries that are not available in the application. Any application with django.contrib.gis.db.models throws a white line on the application engine development server. Presumably, an equivalent error will be encountered in the Live kernel instance.

+4
source

Yes, Cloud SQL supports Spatial Queries . I don’t know if it works with geodjango, but I don’t understand why it is not.

Keep in mind that Mysql geospatial queries require myisam tables. Myisam tables can be damaged much more easily than innodb tables, so you must be very careful in using them. In particular, if your data changes frequently, you will sometimes need to restore backups. In this case, consider the Search API for geospatial queries instead. If data changes infrequently (for example, a physical storage locator), myisam tables are likely to work fine.

+3
source

Source: https://habr.com/ru/post/1308905/

More articles:


All Articles