Learn how to efficiently load a large CSV dataset into a Vercel Postgres database using Next.js. We'll cover setting up your project / databse, parsing CSV files with PapaParse, and inserting the data into your database.
0:00 - Intro
0:13 - What is a CSV?
0:26 - Setting up our Next.js project
1:00 - Creating our Vercel Postgres database
1:43 - Parsing the CSV with papaparse
3:10 - Creating the table and inserting data
4:26 - Running the script
5:09 - Verifying our data was added
Repo: https://github.com/vercel-labs/book-inventory
Vercel Postgres docs: https://vercel.com/docs/storage/vercel-postgres
@next/env: https://nextjs.org/docs/app/building-your-application/configuring/environment-variables#loading-environment-variables-with-nextenv
#nextjs #vercel #postgres
Download
0 formats
No download links available.
Loading Large CSVs into a Vercel Postgres Database | NatokHD