Thanks for building this. The speed boost is pretty insane, this would actually be great for an API layer for performing multiple operations on large query results in memory to reduce requests to the database. I imagine you could add a simple condition to use ducks if the array size exceeds a certain length.
Also, kudos for snagging the ducks pypi slug. I can’t believe that was available.
Oh yeah. It was a good day when the ducks name turned up! The "plural animal" thing references pandas / polars, which are like the OLAP version of ducks. Good near-homonym too. Index? In ducks!
The API layer sounds like a great application. Anywhere there's at least 1000 or so Python objects in memory, ducks will greatly speed up finding the subset you need.
Also, kudos for snagging the ducks pypi slug. I can’t believe that was available.