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

[@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)

[@pranjaldoorwar9743]

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

[@ViktosB]

Hi, I really enjoy your videos. One of the most productive publisher on KZbin. 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..

[@officialabdulrehman]

This was very helpful. Thank you

[@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

[@vpetryniak]

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

[@bipinshukla5222]

Awesome explaination

[@CarlosHonorioBriones]

nice! This is good to know. Thanks!

[@lucanthony2209]

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

[@LarsRyeJeppesen]

Super stuff, thanks. Subbed

[@rorycawley]

Great video, thanks

[@ПетърТодоров-о7ф]

thank u, buddy!

[@YOUdudex]

Cool video, thanks subscribed

[@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.