Find Jobs
Hire Freelancers

PostgreSQL server code

€8-30 EUR

Closed
Posted about 6 years ago

€8-30 EUR

Paid on delivery
I have a web application that store some data in postgresql db, I need the server (postgresql) to add a value in the record based on the value from web application. Return the highest value for that particular group and Insert highest value +1 in a new record together with the information that comes from web. I think this could be solved with stored procedure/insert trigger. This is an easy task for a skilled DBA.
Project ID: 16231333

About the project

6 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average €23 EUR for this job
User Avatar
A proposal has not yet been provided
€19 EUR in 1 day
5.0 (21 reviews)
4.4
4.4
User Avatar
Hi, This indeed seems straightforward. I would create an insert trigger and related trigger function to do the job. Is this only for insert operations or update also? What is your postgresql version? Does this job involve and non-postrgresql work? My bid involves only the pg programming. Do you have multiple rows in one insert? Do you have a **lot** of inserts going on in your table, in other words are there any performance considerations? This case there should be a better way to find out the next value of a kind-of serial field then selecting the highest from existing table. Maybe a sequence for every one of your groups...
€26 EUR in 1 day
5.0 (3 reviews)
3.0
3.0
User Avatar
Hello More 20 years programming experience. I need more details to set real price and time. Regards.
€34 EUR in 1 day
5.0 (1 review)
2.0
2.0
User Avatar
I am dba with 25+ years of experience I am quite good in writing procedures and performance tuning I am dba with 25+ years of experience
€23 EUR in 2 days
5.0 (1 review)
0.4
0.4
User Avatar
A proposal has not yet been provided
€12 EUR in 3 days
0.0 (0 reviews)
0.4
0.4
User Avatar
Hi, I have been working with postgresql since 2004 and version 8 to 9.2 and I have a very good knowledge about this Database.
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NORWAY
Stavanger, Norway
5.0
9
Payment method verified
Member since Sep 27, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.