On Fri, 8 Apr 2011, dsuh wrote:
Can anyone suggest possible solutions?
For openkvk.nl and several demo's using OpenStreetMap data I'm using DBslayer http://www.cherokee-project.com/doc/cookbook_dbslayer.html For this to work you need the MonetDB support patches but basically it works as a plain interface from an URI to your database, where the results are rendered in many formats. Google translate might give you some clues: http://api.openkvk.nl/ Under the hood it works by granting the dbslayer user readonly access to the database. Connecting the webserver to the database. Sending a query from the javascript application to the webserver, and getting results back in for example JSON. Other options we use is to allow cross-site scripting. Stefan