What if you have an array and you want to transform it into a max-heap? Here you go:

Can do some basic @duckdb.org operations now 🤩 🦆

I was solving a DP LeetCode problem in Python and I really wanted to visualize my decision tree structure in the terminal. I'm not a Python expert nor I wanted to waste my energy implementing a "pretty print" function. Copilot was disabled, but I turned it on and did what one must (ask the AI):

That’s how I best learn things 🎨

Nice! For those using ClickHouse and want to read all rows from all the parquet files at once, the following query will give you a glimpse on how to achieve that (see the usage of /* at the end of the S3 path):

TIL: window functions work in ORDER BY! Pretty useful for complex sorting. Check this out

We got a dog 💜

If a node is breaking the heap property push it down by swapping places with smaller children recursively.

Sharing some personal notes on the max-heap data structure commonly used for implementing priority queues. I might keep sharing these kind of notes here in case it helps someone else.

Postgres is everywhere nowadays