News
I'm building Osquil, a schema-aware query workbench for osquery
1+ hour, 26+ min ago (589+ words) I've been working on Osquil, a schema-aware workbench for osquery. The first version is close, and before I publish it I want feedback from people who actually use osquery. osquery itself is great. Turning the OS into a queryable database…...
5 SQL Interview Questions That Trip Up Beginners
1+ hour, 24+ min ago (326+ words) If you're prepping for a tech interview, SQL usually feels "easy" until you're actually in the room. Here are 5 questions that look simple on paper but catch people off guard " plus quick explanations so you don't get caught out. The…...
Tracking Tableau Viewership with Postgre SQL
1+ hour, 41+ min ago (922+ words) Tableau's native "Who has seen this view?" panel is a flat list " no trends, no way to tell if usage is real or just the publisher checking their own work. With direct access to the Tableau Postgre SQL repository, you…...
Building an Enterprise-Grade Real-Time Analytics Pipeline with Fast API and Timescale DB
2+ hour, 24+ min ago (102+ words) I just released v1. 0. 0 of an open-source, production-ready real-time analytics pipeline built with Python. Here's what it does and why you might care. Every Saa S product needs analytics " event tracking, real-time dashboards, time-series aggregations. Most teams either pay for Segment…...
Data Engineer Leet Code: What to Grind and What to Skip
4+ hour, 6+ min ago (628+ words) I bombed it. Not because I wasn't prepared. Because I prepared for the wrong test. Let me save you some time. Here's the math that should make you angry: there are over 3, 000 problems on Leet Code. The vast majority test…...
Reading Your Data Layer at 2 AM: Glass Box vs. Black Box Queries
4+ hour, 10+ min ago (234+ words) Debugging production issues often feels like a race against the clock, especially when it's 2 AM and a critical system is down. In these moments, the clarity of your codebase becomes paramount. This is particularly true for the data access layer,…...
Idempotent gateway sync: adopt on conflict, paginate for real, and never widen scope
4+ hour, 51+ min ago (390+ words) A gateway sync takes your desired state (routes, upstreams, plugins, consumers) and makes the gateway match it. The mental trap is writing that as "create each thing." Creates are one-shot; sync runs again tomorrow, and the day after. The correct…...
Text-to-SQL is still brittle. Snowflake's Cortex Sense is a new take.
6+ hour, 14+ min ago (332+ words) The core problem with text-to-SQL is context, not syntax. Large language models are perfectly capable of writing SQL. What they lack is the deep, implicit knowledge of your business encoded in your database schema: which user_id joins to which account_id, what a…...
Hardwood Promises High-Speed JVM Apache Parquet Processing with Zero Mandatory Dependencies
9+ hour, 6+ min ago (503+ words) Live Webinar and Q&A: Building AI Agent Evals for High-Stakes Incident Response (Aug 6, 2026) Save Your Seat Erik Steiger discusses the operational pain of legacy PDF generation in regulated banking and manufacturing. He explains how transitioning from resource-heavy engines like Puppeteer…...
Migrating off Jira with one command: radial import --from jira
8+ hour, 2+ min ago (730+ words) For Radial, that part is a command. You export your Jira project, run radial import --from jira against the file, and your issues, projects, labels, comments, and history come across in a single run. Dry-run it first so you see…...