How to use read and write streams in node.js for BIG CSV files

An overview on how to use a read and write stream in node when you want to read in a very large csv file and process it quickly.
------------
🔔 Newsletter eepurl.com/hnderP
💬 Discord / discord
📁. GitHub github.com/cod...

[@sameerbharadwaj11]

Thank You! This helped a lot with writing 20mil records to solr.

[@WebDevCody]

Oh wow this actually helped? I’m glad 😂

[@martinmingosuarez8690]

there is a core module called readline that works with streams to read one line at a time, no need to write the logic yourself, otherwise great explanation and video. Cheers

[@veremox]

im not an expert but a chunk is not necessarily a line...

[@oscarmamani5996]

martinmingosuarez8690 thank you for this comment! it help me

[@LegendKopper]

-----The topic "NodeJS streams---->
(your head)

[@officialabdulrehman]

This was very helpful. Thank you

[@ViktosB]

Hi, I really enjoy your videos. One of the most productive publisher on RUclips. But in that video the name "overWatermark" is highly misleading. I struggled understand the whole structure only because of that naming. This would be better if you use instead "canWrite". canWrite is true when we can write and false when the buffer is full. Then we stop -> !canWrite.
const canWrite = writeStream.write(`${i},
`);
if (!canWrite) {
await new Promise((resolve) => writeStream.once('drain', resolve));
}
}
I might be wrong of course.
Other than that - great job again. Continue watching you content 🙂

[@PhuTran-nb7me]

Hello Sir, I have a question, much appreciated If you can address my doubt. Do chunks come in sequence, in other words, does the read stream wait for the current chunk to finish the operations before it emit the "data" event to process the next chunk? You have a potentially long running iteration there and more importantly, each chunk is interdependent to each other as the last If statement is used to assign the last incomplete row to "unprocessed" variable for the next chunk to use.

[@WebDevCody]

Yes they should come in order.

[@empty8537empty]

It should be in order..which is taken care by your transport layer..

[@vpetryniak]

How to use Web stream API in node js to do the same thing?

[@pranjaldoorwar9743]

This might be helpful to me i am trying to read csv data and insert it into mongodb first before parsing it

[@Tony.Nguyen137]

What if I want to read big data of users - User{age:20………height:7“} - and save it into a database, but that chunk of data miss some properties that a user have like age:20“ ? Could this happen if yes how to solve it

[@LarsRyeJeppesen]

Super stuff, thanks. Subbed

[@bipinshukla5222]

Awesome explaination

[@CarlosHonorioBriones]

nice! This is good to know. Thanks!

[@YOUdudex]

Cool video, thanks subscribed

[@rorycawley]

Great video, thanks

[@lucanthony2209]

Hello @vJunkie,
Thanks for the great content.
CAn you make a video using csv-parser & fs libraries to read & write csv files ?

[@user-xw6jr7ue4b]

thank u, buddy!

[@mtuchidev]

How do you pass a chunk size ?

[@SeibertSwirl]

Good job babe!!!

[@haohong5141]

node version?

[@himaliamit8698]

if you show us the format of the csv file it would have made much more sense.

[@majidshah48]

i think opening the file will take time or it might just crash

[@boople2snoot]

them jump cuts

[@boople2snoot]

also no sub, your variable is overWatermark, you're waiting for an event emitter if not overWatermark, the function therefore must return true if it is not over the watermark and var should be named underWatermark. Or it would run if not overWatermark, which is under the watermark, which? shit you just ramble, bye.