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?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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>:
Show quoted text
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