pgsql/JSON relay - repost


I'd like a fixed price for the following two-part job. Just ask if you need more details. I'd appreciate if you also specify your choice of method (language, dependencies, protocols).

Part 1:

A server-side script runnable on the Linux platform to perform these steps:

- Receive a request over a protocol that is widely supported in AJAX (JSON over HTTPS or your suggestion). The request consists of a function name and a variable-length list of parameters, all of them strings.

- Transform this request into a PostgreSQL database lookup, calling the function with a prefix added to the name and with the given arguments. (Just query "select * from prefix_functionname('arg1', 'arg2 ... 'argN');")

- Return the result in a way that the client can determine whether the query was successful, and if so read the content of the returned data. All returned fields will be strings. The script should not depend on column names.

I will expect the script to be secure, not allowing sql injections or security holes of any sort, or calling any database function with a name lacking the mentioned prefix. The script should of course also be reasonably efficient.

Part 2:

An html/javascript page getting data from the JSON API and showing the result in a grid. Basically a mockup just to test that part 1 actually works. Depending on the price and quality of the work, I'd like to hire you for the actual client side application.

One more thing: Don't bother bidding over $80.

Skills: HTML, Javascript, PHP

See more: pgsql api, pgsql json, sql server price list, prefix function, postgresql sql, postgresql any, relay, php json , json, json script, JSON PHP, json c, json client, ajax grid, html json list, grid ajax, javascript ajax grid, php list json, php json list, json sql script, php query https, php read json, php api json server, JavaScript JSOn, php api return json

About the Employer:
( 1 review ) deru, Sweden

Project ID: #4373451

4 freelancers are bidding on average $124 for this job


hi, i can do it for U. please pm to me.

$140 USD in 4 days
(1 Review)

Please check private message for samples of previous work

$80 USD in 3 days
(3 Reviews)

Piece of cake! Ajax expert ready to start!

$77 USD in 1 day
(4 Reviews)

Hello Sir, I can do this task.

$198 USD in 30 days
(0 Reviews)