NODE POSTGRESQL CSV IMPORT/EXPORT

Import from CSV 1 mil benchmark with autogenerated UUID

id UUID PRIMARY KEY DEFAULT gen_random_uuid()

LOG:  statement: COPY users(username, first_name, last_name) FROM STDIN DELIMITER ';' CSV HEADER
LOG:  duration: 3696.663 ms

Import from CSV 1 mil benchmark with autogenerated SERIAL

id SERIAL PRIMARY KEY

LOG:  statement: COPY users(username, first_name, last_name) FROM STDIN DELIMITER ';' CSV HEADER
LOG:  duration: 1282.590 ms

Export to CSV 1 mil benchmark with UUID

LOG:  statement: COPY users TO STDOUT WITH (FORMAT csv, HEADER, DELIMITER ';', QUOTE '"')
LOG:  duration: 576.788 ms

Cmds

# shutdown and delete db
docker compose down
docker volume rm import-csv-into-psql_import_csv_db

npm run build
npm run start

# dev
npm run dev


# generate user and pass
bash ./pgbouncer/generate-userlist.sh

Node Version

v22.1.0