DuckDB in Action

https://www.manning.com/books/duckdb-in-action/

by tosh • 2 years ago

30 11 2 years ago

manning.com

boxcarr• 2 years ago

Motherduck.com has a pop-up promotion to get the book for free.

vladsanchez• 2 years ago

https://motherduck.com/duckdb-book-brief/

timenova• 2 years ago

Does anyone know how well does DuckDB's persistent mode compare to SQLite for example?

Does it write synchronously on COMMIT and never lose data? Is it reliable enough to use instead of SQLite?

r1cka• 2 years ago

DuckDB targets analytical workloads. Your question sounds like your workload is transactional to me, so I'd recommend sticking with SQLite.

cipherzero• 2 years ago

Agree, in fact this wonderful book calls this out, stating:

  As DuckDB is an analytics database, it has only minimal support for transactions and parallel write access. You therefore couldn’t use it in applications and APIs that process and store input data arriving arbitrarily. Similarly when multiple concurrent processes read from a writeable database.

overbytecode• 2 years ago

How do you decide when to reach for Polars vs DuckDB?

jasonjmcghee2• 2 years ago

In Python, I think of them as, DuckDB is for getting the data you want, in the form you want it, from a file / remote place. Polars is for when you want to do something with that data, like visualize it.

`duckdb.sql("SELECT foo, bar * 2 as bar_times_2 FROM ...").pl()` (now in polars format) -> other stuff

In Rust, it's a bit fuzzier to me, as DuckDB is a pretty heavy dependency. I'm looking more and more fondly at DataFusion.

nozzlegear• 2 years ago

Do you mean Polars depends on/uses DuckDB pretty heavily in Rust? I'm only just now dabbling in Rust myself so I'm not familiar.

joelschw• 2 years ago

Or you use Ibis and switch between the two at will!

lvl102• 2 years ago

DuckDB is nice but I’d like to see some alternatives to RAPIDS in the GPU space.

DuckDB in Action

Related Stories