3 ms·
I'll let someone with more polars & duckdb experience to weigh in. But in short yes. Especially if you take the perspective they're both trying to help you do
by krawczstef 4y ago
I'll let someone with more polars & duckdb experience to weigh in.
But in short yes. Especially if you take the perspective they're both trying to help you do operations over tabular data, where the result is also something tabular.
Duckdb is "A Modern Modular and Extensible Database System" (https://www.semanticscholar.org/paper/DuckDB-A-Modern-Modular-and-Extensible-Database-Raasveldt/729cdaf9f2f7e2f48fa55fe48c0ea63c8a49f4d6 https://www.semanticscholar.org/paper/DuckDB-A-Modern-Modula...). So it has a bit more to it than polars, as it has a lot of extensibility, for example, you can give it a pandas dataframe and it'll operate over it, and in some cases, faster than pandas itself.
But otherwise at a high-level, yes you could probably replace one for the other in most instances, but not true for everything.