Closed

pgsql/JSON relay - repost

This project received 4 bids from talented freelancers with an average bid price of $124 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
4
Project Description

Hi!

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online