[OpenLayers-Users] Fwd: design question: how to geocode multiple dynamic "city, country"?

[zach cruise]

I sent the email below, then realized I can simply add custom dynamic
markers in openlayers on click (see
http://stackoverflow.com/questions/4624301/adding-custom-markers-dynamically-to-map-using-openlayers,
http://wiki.openstreetmap.org/wiki/OpenLayers_Marker_Example), but
need some real-life examples of how this could be done in batch.

---------- Forwarded message ----------
From: zach cruise
Date: Thu, Apr 10, 2014 at 3:48 PM
Subject: design question: how to geocode multiple dynamic "city, country"?
To: PostGIS Users Discussion
Cc: PostgreSQL

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?