DuckDB now has a Node.js API

I tried using DuckDB in a recent project. In their Python API, it had trouble correctly handling binary blob inserts. I really should have started poking at the code and tried to submit a patch, but I also realized I&#x27;d probably need to write my own schema migration layer (I&#x27;m use to yoyo-migrations for sqlite3).<p>I ended up back on sqlite3. It seemed cool though; might pick it up again for a future project.

DuckDB is incredible for large stats projects using R. R can&#x27;t really handle large datasets and simply runs out of memory if you load everything. You get around this by splitting your data into a bunch of RData files but there&#x27;s quite a bit of overhead maintaining those, recreating them when you need more variables, etc.<p>With DuckDB you can just load it once into the database then use dplyr&#x2F;dbplyr to transparently access data with the queries pushing down to the DB afaik. And it runs anywhere and doesn&#x27;t need local admin (like most database servers).<p>(SQLLite can&#x27;t handle many columns without a custom build)

Hope they do a wasm emscripten build like sqlite has too. Would be an incredible building block for the move to distributed computing.