John Kutay

@jkxosound.com

Product & Engineering @ Striim (streaming sql, change data capture), creator/host @ What's New in Data pod, music @ jkxo

@clare.dev is one of the leaders making AI engineering simple and scalable at AWS. Had a great time chatting with her as we discussed Strands Agents and patterns like “Retrieval as a Tool”.

Really appreciate the depth at which the Hex team broke down their Text-to-SQL implementation. Everyone's trying to teach LLMs SQL like it's a training problem but it's really a graph traversal problem.

Bild

In my post about #DuckDB I digress into the role of the database buffer cache to discuss how we segregate transactional workloads from analytical. DuckDB turned out to be a natural, lightweight approach to offloading analytical queries ensuring our application upheld performance requirements.

Bild

Instead of materialized views, we built in-process DuckDB caching in the control plane of Striim Developer — improving query performance 5–10x with zero added infra. PostgreSQL for OLTP, DuckDB for Operational OLAP. But I won't call it HTAP 🤐 medium.com/striim/beyon...

Beyond Materialized Views: Using DuckDB for In-Process Columnar Caching

In this post we will talk about using DuckDB as the operational analytics store for the control plane of Striim Developer — a serverless…

medium.com

A side effect of LLMs: I'm taking on way more than I ever have in my life. I don't know if this is more productive or diluting myself. tbd!

Just found out one of the internal b2b CRUD app vendors is more like CRD because it doesn't support updating submissions. AI gonna cook that sector so hard.

Them: Wait so you're saying I don't need to deploy Kafka? Me: No Them: Kinesis? Me: No Them: Zookeeper? YARN? Me: No Them: Will you write every record to disk and replicate it? Me: No Unfortunately the bar of complexity for streaming has been set so high. I'm calling it Streamholm Syndrome.

A single Striim cluster (multi-node for scalability and fault tolernace) can handle 35k, very wide, very active databases that produce millions of DML per hour hour and dozens of DDL per day. The 'intelligence' layer or Striim was able to apply rule based logic on how to handle complex DDL.

Bild

I will die on this hill but MySQL's 'Alter Table Add Column AFTER' DDL is pointless. It doesn't change the layout on disk. If you care about order of the columns, that's purely a read side construct and you should address it in your query not your DDL!

We’ve shifted embedding generation and transformers left into the streaming layer to support near real-time RAG. Take a read if you want to hear the optimizations we made for change data capture and incremental embedding generation. www.striim.com/blog/real-ti...

Real-Time RAG: Streaming Vector Embeddings and Low-Latency AI Search

Imagine searching for products on an online store by simply typing “best eco-friendly toys for toddlers under $50” and getting instant, accurate results—while the inventory is synchronized seamlessly ...

striim.com

I always love seeing clovers in the wild! Knowing every transaction is streamed to Snowflake in real time with Striim’s streaming CDC service. We do a lot of work to ensure transactions are bound reliably and replicated with no duplicates while maintaining low latency.

Bild

As someone taking inventory of receipts of everything I ever owned, I regret every single purchase I didn't make online because its so hard to find the receipt.

I was really surprised to hear a data team ask me how replication will impact their database and had legit concerns. Database providers need to do a better job making sure their developers have confidence deploying for HA.

MAGA narrative has infiltrated the Palisades fire. The truth is there was lots of low and mixed income apartments along Sunset in my area (Marquez) and near the high school. Those residents deserve to come back home too. Some had been there for decades.

Bild

Transaction logs and their respective interfaces are a bit of a complicated topic and SQLServer has some unique challenges. I'd say its quite different from Oracle's redo log and how OSS databases like PostgreSQL and MySQL approach logical replication. We worked on making the first in-memory log...

Bild