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
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