Kaivalya Apte

@thegeeknarrator.bsky.social

Podcaster, Youtuber @TheGeekNarrator (https://youtube.com/@thegeeknarrator?si=yN0zWNDAScJKv_QZ) Databases, Stream processing, Distributed systems Software Engineer @Confluent

1/12. I'm excited to share our latest technical blog post on ParadeDB. After a brief hiatus focused on transforming ParadeDB into an enterprise-ready database, expect to hear a lot more from us. Today's post: How ParadeDB built an LSM on top of Postgres block storage. 🧵

ParadeDB@paradedb.com · last yr.

The ParadeDB BM25 index brings Elastic-style full-text search to Postgres, powered by our custom Postgres-native LSM tree. Dive into how we built it: www.paradedb.com/blog/lsm_tre...

What is State Machine thinking and how do I use it (practically)? State machine thinking is one of the best ways to build reliable software. The idea is to break down complex systems into discrete states and explicit transitions between them.

Bild

What is First principles thinking and how do I use it (practically) ?👇 First-principles thinking is one of the best ways to tackle complex problems. The idea is to break down complex problems into primitive elements and then reassemble the problem from scratch.

Bild

DUPLICATE events and painfully SLOW joins are a real and painful problems in the world of stream processing and realtime analytics. But why there hasn't been a simple, easy and fast solution for these problems that just works with the hassle?

Bild

DUPLICATE events and painfully SLOW joins are a real and painful problems in the world of stream processing and realtime analytics. But why there hasn't been a simple, easy and fast solution for these problems that just works with the hassle?

Bild

There is a lot of innovation happening in the Databases world BUT one area where there is a lot of opportunities is Query optimisers. I recently learnt about query optimisers and the amazing work CMU db group is doing in this space with their new query optimiser “Optd”.

If someone says “I am a perfectionist”… they are either lying OR mean they are not going to get/let things done on time. The only realistic way is to be above a certain quality bar and keep the progress iterative and incremental. Get things done fast.