I thought DuckDB was fast SQL with great compression. Speeds are lightning fast - I was happy with that. Then I went through  Jasja De Vries 's 30-day DuckDB series. Day by day. All 30. Turns out I was using maybe 10% of what it can do. My analyst and data scientist friends,  DuckDB  isn't just fast SQL. It's Python, SQL and compression all in one box. Here're some features I didn't know existed: ▸ SELECT EXCLUDE - SELECT EXCLUDE (col1, col2) - grab everything except specific columns. SQL...

xlwings Lite turns Excel into a live Python app. No Python install on the user's machine. Just a browser-based add-in with code editor, console, and deep Excel integration. It launched earlier this year and I've been using it ever since. When you use AI coders like Claude, Cursor, or Gemini to write xlwings Lite code, they don't know its constraints. They generate desktop xlwings syntax that looks right but fails silently. So I started maintaining an instruction file - a document you feed to...

Two Clicks. Zero Setup. No Database, No Server, No Login needed. With 9 LLM options, Python & SQL to torture your data till it confesses. App live here: app.tigzig.com/analyzer See PDF for step-by-step guide What's New I've enhanced the sample datasets in my Database AI app (DATS-4). Previously, the test files were tiny, 50-60 rows. Now there's a full range: 64 rows to 11.8 million rows. File sizes from 14 KB to 1.6 GB. For the 1.6 GB file, setup takes around 9 minutes. Fully automated:...