Find Jobs
Hire Freelancers

Set up Postgresql database and connect to 3rd Party REST API

$25-50 AUD / hour

Cancelled
Posted almost 6 years ago

$25-50 AUD / hour

I have been using a mobile form app. There are around 8 forms creating about 12 tables. which reside on the 3rd party server. I need you to establish a posgres database and establish CRU operations using the 3rd party REST API. I am designing the forms and will be adding / changing fields regularly. Once I have the DB set up , I expect to be able to edit a JSON file to edit the fields for the API , then edit the fields in the DB. Then I will then be creating queries for use in a report writer. My objective it to be able to make a change in the form and be able to follow that change all the way through to the report. I want to be able to do the development in an eco system on my desktop and later migrate it to a hosted service. eg AWS (maybe Docker is appropriate?) I have insufficient experience in setting up but will be fine with form/SQL/Report writer. I have tried to get the API connected using postgrest but could not get it to log in to the DB. I have looked at other options - psql-api but I do not have the experience to be able to set these up. You may suggest other methods.
Project ID: 16586191

About the project

13 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
13 freelancers are bidding on average $37 AUD/hour for this job
User Avatar
Hello, I have worked with PostgreSQL on many projects and I have used it to host fairly large instances (1+ TB of data, billions of rows). I have experience with designing and tuning PostgreSQL as well as many of it's more advanced features (PostGIS, text search, JSON/JSONb). Since having a flexible structure seems important for this project I think PostgreSQL's JSON/b support will come in very handy - it allows you to store arbitrary data without the need to alter the structure (similar to how noSQL databases work). For this project I would write a Python application that implements the CRU operations on the DB; I can also help you deploy it to AWS since I'm using it regularly. As Python has great support for web development one could use it to build the reports with it as well. Can you give me a few more details about the data itself? Best wishes, iticus
$41 AUD in 20 days
5.0 (16 reviews)
5.3
5.3
User Avatar
10+ years experience in Java/J2EE/Node.js/Python/AWS development. Following are the list of expertise:- 1. AWS Technology - AWS lambda, S3, RDS, Dynamo, API gateway, cloud watch, SNS, SQS, SES, Cognito, Lex, Alexa, Cloud Front, Rekognition, Kinesis, Machine Learning, IoT and more 2. NodeJS 3. Python with Django framework 4. Frontend Technology - HTML,CSS,JQuery, ExtJS, Dojo,D3.js, AngularJS 1,2,ExpressJS, React.JS, IONIC, and Javascript, 5. J2EE frameworks - Struts, Spring, JSF 6. Databases - MySQL, Oracle, MSSQL server,PostgreSQL MongoDB 7. Expert in REST API/Web services development using JAX-RS, Spring,swagger 8. Expert in JSON and XML programming 9. Build Tools - Maven, Ant, Jenkins, Circle CI, CI/CD in Bitbucket & Gitlab; 10. Test frameoworks - Junit, TestNG, Mockito, Rest Assured, JBehave 11. Mobile website development using HTML5, CSS3, Bootstrap Other Integration Experience: - Auth0, Stripe, Chargebee, Emailoctopus, Google Map APIs, Google Cloud Platform, Machine Learning, Slack, Flock, Twillo and more Project Management Tools: Gitlab, Projects, Bitbucket, Trello, Github, Jira
$30 AUD in 30 days
5.0 (8 reviews)
4.4
4.4
User Avatar
Hi there..... Warm Greetings We came along with your request for Set up Postgresql database and connect to 3rd Party REST API and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Administration, Database Development, PostgreSQL, RESTful We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$50 AUD in 40 days
4.9 (6 reviews)
4.2
4.2
User Avatar
Greetings) I can help you to set up Postgresql database and connect to 3rd Party REST API. At this moment I have a team of 10 system administrators (5 of them are senior). In area of providing Managed Services we have experience with such technologies as Virtuozzo, different types of virtualization (OpenVZ, KVM, XEN), different distributives of OS Linux / OS Unix / OS MS Windows Server systems, VPN/DNS/IPTables/Firewalls/web servers/mail servers configuration and tuning etc. Also we have experience with Docker, AWS and PostgreSQL. If you are interested in our proposal or at least you want to discuss some points, please, contact us in a chat. Kind regards.
$33 AUD in 40 days
5.0 (2 reviews)
3.8
3.8
User Avatar
Hi, I have developed many AWS hosted web service connected via RESTApi from Mobile App. Then for backend db, used MongoDB, and loopbackAPI. I think that My Skills are enough for your project. I hope to discuss specially with you over chat.
$44 AUD in 40 days
5.0 (2 reviews)
1.9
1.9
User Avatar
Greetings! Hope you are doing great! Can I have look at mobile form app ? I have an extensive experience with Database Administration, Database Development, PostgreSQL, RESTful and I am ready to assist you with Set up Postgresql database and connect to 3rd Party REST API. Please let me know when can we discuss further ? I can be reached anytime via Skype /Email for further discussion. I appreciate your consideration and look forward to hearing from you ! Best Regards, Bhanu Madan
$50 AUD in 40 days
5.0 (1 review)
1.4
1.4
User Avatar
Hello,client I'm very interested in your job I have experience in Postgresql database. Usually, clients use mysql but the mysql and postgresql are different in funtion name. E.g. mysqli_query(mysql) and pg_query(postgresql) And I am expert of RESTful API. I am used to POSTMAN software for testing API Finally,I can do your job high quality Please discuss more details via chat THanks
$25 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I suggest you need it accessed remotely by using connection string right? I think it is better if you create a middle-tier apps such as a web service which will retrieve the command, forward to database and retrieve response, then reverse back to the caller (your apps). So, this would be more efficient, secure, and flexible. What do you think?
$35 AUD in 40 days
0.0 (1 review)
0.0
0.0
User Avatar
A proposal has not yet been provided
$33 AUD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, As outlined in the profile summary, I have significant experience with a range of database systems, including PostgreSQL, which is my platform of choice for my own personal projects. I also have a lot of experience in creating RESTful APIs. I have just recently finished a project to design and implement an API using JavaScript and node.js, though I have also used Java and .NET in the past. For these reasons I think I would be a great fit for your job. Look forward to hearing from you, Muhmud.
$41 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, let me introduce a little bit about me. My name is Phuoc On (Phil On), I have 7 years experiences as full-stack Ruby on Rails developer, my current position is the tech lead at GoldenOwl Asia - outsourcing company focused on Ruby on Rails, NodeJS, ReactJS, mobile app. I have built many systems with high traffic websites more persistent connection and stability. I am capable of analyzing requirements, building products with high quality and fully meet customer requirements on time. I've built many projects like build the crawler base to collect data from many web services, build API services, build the website from scratch, micro-services, ... The technology I use is Ruby on Rails, ReactJS, NodeJS, Android app, Swift iOS, PostgreSQL, MySQL, Redis, MongoDB, ElasticSearch, RabbitMQ, Rspec, Capybara... I am enthusiastic, responsible for the work and always eager to contribute ideas of their effort to complete your project in the best quality. Right now I am looking for a new opportunity to working remotely or relocation overseas. Please contact me via skype: chungphuoc1 for more detail Best Regards,
$27 AUD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$33 AUD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Mar 11, 2018

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.