Latest Programming news from Tech News
The Hidden Goldmine (and Nightmare) of Japan's Open Data Japan’s government ministries publish massive amounts of open public data: Multi-billion-do…
Window functions are the most common SQL topic in data engineering interviews, and most candidates know the syntax. The follow-up questions are wher…
In my previous post, Amazon Aurora's analytics being DuckDB — a side-by-side comparison with pg_duckdb , I examined Aurora Analytics in detail along…
Most SQL GUIs treat DuckDB as one more driver on a list. You get the SQL every database shares, and DuckDB's best parts — FROM-first queries, DESCRI…
Сценарий знакомый: открываешь в pandas файл побольше, ноутбук задумывается, и через минуту всё падает с MemoryError. Следом обычно звучит совет: для…
Part 1 gave you a map: every PII-bearing column, tier-tagged. Part 2 armed you: HMAC for direct identifiers, tokens for what must be reversible, mas…
DuckDB Labs has previewed DuckDB v2.0, codenamed "Cyanoptera." This release includes over 10000 commits and introduces a client/server mode, enablin…
This is the architecture of Shibui Finance , an MCP server that gives Claude direct SQL access to 64 years of US stock market data. About 10,000 sym…
A few things I noticed. None of them alarming on their own. Our database doubles in size every year. Not "grows a lot" — doubles . Of its 180 GB, fi…
Introduction In the evolving landscape of data engineering, DuckLake is emerging as a powerful solution for building data lakes with ACID transactio…
We have all seen SQL pushed past its comfort zone to build things like 3D renderers or cellular automata. Naturally, I wondered about a classic comp…
The problem Backlink data is a $1.5B/year SaaS category. Ahrefs is $129/month, SEMrush is $140/month, Moz is $99/month. As an indie I needed competi…
At the beginning of 2025, DeepSeek changed the conversation around AI infrastructure. Most people focused on the model quality, the training cost, a…
Introduction - SQL without a Server Pandas is widely used for data analysis and almost every data analyst or even data engineers utilize it for fast…
News for DuckDB users! Valentina Studio 17.3 now fully supports the new DuckDB VARIANT type on all three desktop platforms — Windows, macOS and Linu…
We were burning $42,000 a month on managed PostgreSQL 17 instances to power our analytics dashboards, with p99 query latency hitting 11 seconds for…
The Conventional Wisdom Open any data-engineering thread in 2026 and you'll see the same chorus: "DuckDB is the SQLite of analytics, just use it." M…