All Questions
3 questions
3
votes
1
answer
4k
views
Fetch, parse, and store JSON in PostgreSQL
I was given a task to read JSON from a URL and then parse it in python. Each field will be assigned to a variable to store the value. The value will then be stored into postgres table.
Example of ...
- 141
5
votes
1
answer
13k
views
Insert data to PostgreSQL
Im inserting data to a PostgreSQL database using the below function.
Im not very happy with the solution for the IF statements to handle the adaptation of Python <...
- 153
5
votes
2
answers
4k
views
Loading 40GB twitter JSON TAR file from archive.org and load into PostgreSQL
I wrote the script below to load data obtained from the twitter JSON archive on archive.org into a PostgreSQL database.
I'm looking for optimizations in the code. It currently runs at ~1.7 seconds ...
- 698