DuckDB is incredible for high-speed, local OLAP analytics. It is lightweight, fast, embeddable, and designed for analytical queries. It also includes a […]
Read More
Identifying Fast-Path vs Distributed Transactions with EXPLAIN (ANALYZE, DIST)
YugabyteDB has always supported multiple transaction execution paths under the hood, but determining which path a statement actually used often required inference, […]
Read MoreFaster Distributed Transactions with CTEs
When working with distributed databases like YugabyteDB, writing safe, performant, and transactionally consistent SQL can get tricky — especially when your app […]
Read MoreShow Number of Rows Affected by an INSERT, UPDATE or DELETE
When you run a DML statement like an INSERT, UPDATE or DELETE, some number of rows are affected. Databases have various ways […]
Read More