Обсуждение: design question: how to geocode multiple dynamic "city, country"?

Поиск
Список
Период
Сортировка

design question: how to geocode multiple dynamic "city, country"?

От
zach cruise
Дата:
i accept multiple "city, country" from users on-the-fly, and want to
dynamically map them.

i could create a table where i insert their multiple entries, and then
geocode that table for display.

but i also want to avoid giving write permission to the web user.

i could create a schema and restrict write to that schema.

or something better?


Re: [postgis-users] design question: how to geocode multiple dynamic "city, country"?

От
Rémi Cura
Дата:
Hey,
my 2 cents :
If you give write access, beware of the sql injections
http://en.wikipedia.org/wiki/SQL_injection

Cheers,
Rémi-C



2014-04-10 21:48 GMT+02:00 zach cruise <zachc1980@gmail.com>:
i accept multiple "city, country" from users on-the-fly, and want to
dynamically map them.

i could create a table where i insert their multiple entries, and then
geocode that table for display.

but i also want to avoid giving write permission to the web user.

i could create a schema and restrict write to that schema.

or something better?
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users