Thread: design question: how to geocode multiple dynamic "city, country"?
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"?
From
Rémi Cura
Date:
Hey,
my 2 cents :
If you give write access, beware of the sql injections my 2 cents :
http://en.wikipedia.org/wiki/SQL_injection
Cheers,
Rémi-C
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