Closed

Software to create Postgresql Functions

This project was awarded to gyk for €200 EUR.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
€30 - €250 EUR
Total Bids
14
Project Description

I'm building a complex Postgresql database. I need a software that will write some functions based on some custom types.
The software requirements are:
- list custom types
- select a custom type and a type of function; for the selected type software must be able to build an insert/update funtion, a readall, readone, delete.
- software can be developed in c/c++, c#, [url removed, login to view] and some proposal can be accepted.
- I can accept software for Linux or for windows, your choice.

Some important details:
- Postgresql is used in version 9.1
- Custom types can contains other custom types, even in arrays
- These types are normalized, so for a single type, more tables can be involved. We can discuss about an eventual naming conventions.
- Some tables have a sequence. The function of insert will return the value of sequence.
- Software must be commented in English or Italian (best English).

I will provide a dump of the database and some example functions (hand written).

An example of datatype:
CREATE TYPE ztype_customer AS
(id integer,
username character varying(100),
name character varying(100),
surname character varying(100),
password character varying(100),
email character varying(100),
addresses ztype_address[],
customer_status ztype_customer_status,
customer_contacts ztype_customer_contacts[],
update_version integer);
ALTER TYPE ztype_customer
OWNER TO myuser;
COMMENT ON TYPE ztype_customer
IS 'This is a customer';


Fell free to ask any question.

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