I'm sorry for being away for some time. I was busy. However, I am back, and I have good and bad news.
Bad News:
Missing data in csv files still needs to be resolved. The company behind the food DB does not email with users who don't pay for their paid plans. Work needs to be done in this area
Good News:
I figured out that you can insert into PostgreSQL much quicker with the "COPY table_name (column 1, column 2, column 3) ..." instead of adding one by one. Was able to insert 2 million items in around 30 seconds, which is much faster than the 5 or so hours needed before.
Updates should be more consistent now.
Top comments (0)