iiinova — where your digital self keeps evolving

Vini

@vinimdocarmo.com

Having fun with database internals, distributed systems and trying to document my joy along the way 👋 Software Engineer @ WeTransfer

Posts Replies Media

Vini @vinimdocarmo.com · 18/03/2025

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

000

Vini @vinimdocarmo.com · 13/03/2025

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

010

Vini @vinimdocarmo.com · 06/03/2025

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):

110

Vini @vinimdocarmo.com · 25/12/2024

That’s how I best learn things 🎨

Doodle drawn by hand explaining pipes in Linux

020

Vini @vinimdocarmo.com · 20/11/2024

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):

040

Vini @vinimdocarmo.com · 15/11/2024

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

100

Vini @vinimdocarmo.com · 15/11/2024

We got a dog 💜

000

Vini @vinimdocarmo.com · 03/11/2024

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

Personal notes explaining how to maintain the max-heap property.

100

Vini @vinimdocarmo.com · 03/11/2024

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.

Max-heap data structure notes done by me using Goodnotes app.

110

Vini @vinimdocarmo.com · 31/10/2024

Postgres is everywhere nowadays

010