Find Jobs
Hire Freelancers

convert large JSON to SQL db in python

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
The objective of this project is to create a utility in python which can import multiple (5-10) large JSON files into a SQL database. Each file to be imported is sized between 100 – 200 mb. Schema for the output is up to the developer, however, the quantity and size of the individual elements varies greatly, so expectation is that the utility read the JSON file, and create a different table for each element, using the CRD number as the key element. All elements must be stored, however under Current_Registration we need only track if the field is populated or not, the text does not need to be stored in the database.
Project ID: 11143943

About the project

13 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
check my profile on fiverr :) [login to view URL] my clients are always satisfied I just started on freelancer.com but I have a long experience on fiverr :) you can count on me
$55 USD in 2 days
5.0 (5 reviews)
3.8
3.8
13 freelancers are bidding on average $190 USD for this job
User Avatar
Dear Sir or Madam, Thank you for considering my bid! I just developed a Python-based tool for communicating with a web service that stores quite sizable json queries in a database. So I'm quite comfortable with dynamically creating tables.. Working with a buffered data source is fine as well, so you can count on me regarding this project. :) I think we might need several tables for splitting data into. Right? Is the data schema consistent throughout the whole dataset? Please just drop me a line ;) I'm available for a phone conversation today at about 2-3pm your time. Have a great weekend! Thanks for posting, Paul
$250 USD in 3 days
5.0 (26 reviews)
5.7
5.7
User Avatar
Hi Can it not be done in anything other than Python? Which version of SQL Database you are currently using? From where we will get these files? Copied on local or from a remote location? How often this import process will run? Does it need to be adhoc on demand or automated back-end service? Please reply to above so that I can proceed further. Regards AZ
$277 USD in 4 days
4.9 (12 reviews)
4.9
4.9
User Avatar
Hello, I am interested in your project. I am a software engineer and I have professional experience with MySQL and Python. Thank you, Best regards, David
$100 USD in 5 days
5.0 (18 reviews)
4.0
4.0
User Avatar
Hi This is Vikas having 5+ years of experience in IT and able to do this task very professionally. I am employer oriented and you will never get disappointed. I'll be here for any future support. Hope I would be your choice. Thank you Regards Vikas
$250 USD in 3 days
5.0 (4 reviews)
3.6
3.6
User Avatar
Dear Sir/ Madam, Kindly check my bid & project completion ratio before awarding. I'm really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks & Regards Prog2U
$166 USD in 1 day
5.0 (6 reviews)
2.8
2.8
User Avatar
I have more than 10 years of experience as a software engineer. I have worked with mainstream languages (Java, C#, Ruby, Javascript) and databases (Oracle, Postgresql, Mysql, Mongodb). I also know the basics of Python
$277 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I'm a computer engineer and software developer. I can do your project. I'm ready for you. Best regards.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cranford, United States
5.0
6
Payment method verified
Member since Jul 27, 2013

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.