I need help with streaming a large json file from s3 into a postgres table from java. I have a working solution in python but I want to get it done using java The basic idea is we get mutiple gzipped json files into our s3 from a third party provider. I want to be able to process those files and load them into postgres without downloading the entire file into the memory If we can get 1 file work that way we can then look into multithreading The crux of it is read the content from gzipped json in s3 without downloading the entire file into the memory More info:
We are seeking a DBA Admin and/or Developer to help us migrate our database from MS SQL SERVER to PostgreSQL. We want to recreate out tables and stored procedures in PostgreSQL. We need someone experienced in both databases to help us with the code migration challenges.