Of the various ways to transfer files to and from Oracle Database, buffering in Node.js is the easiest to implement. In this post, you’ll learn how to perform file uploads and downloads using buffered binds and fetches.
Buffering means that a file’s contents are fully materialized (buffered) in Node.js before being transferred to either the database or the client. This is as opposed to streaming, where the contents are passed along intermittently. Streaming is more efficient with respect to memory utilization, but it is also more complex to implement.