[MonetDB-users] How to access MonetDB in Javascript without XRPC/XQuery?
Now that XRPC/XQuery is being removed from the MonetDB source, are there any options for client-side browser Javascript access to SQL queries? Would it end up looking like using the PHP interface in the web server side and passing the results to the client-side Javascript? Exactly how would this look like? I am interested in using HTML5/Javascript on the client-side to create a mashup of different data including GIS information from MonetDB. Can anyone suggest possible solutions? David Suh
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
participants (2)
-
dsuh -
Stefan de Konink