News
I'm building Osquil, a schema-aware query workbench for osquery
2+ hour, 21+ 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
2+ hour, 19+ 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
2+ hour, 36+ 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
3+ hour, 19+ 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
5+ hour, 1+ 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
5+ hour, 5+ 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,…...
Text-to-SQL is still brittle. Snowflake's Cortex Sense is a new take.
7+ hour, 9+ 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…...
Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic
11+ hour, 12+ min ago (608+ words) For a typed ORM with automatic migrations in Python you need to maintain 3 sources of truth (SQLAlchemy + Pydantic + Alembic). In Fitz it's ONE type with decorators. Plus 8" RPS and 5" less memory than SQLAlchemy in a reproducible benchmark. For each entity…...
ORM tipado con migraciones autom'ticas: Fitz vs SQLAlchemy + Alembic + Pydantic
11+ hour, 12+ min ago (624+ words) Para tener un ORM tipado con migraciones autom'ticas en Python necesit's mantener 3 fuentes de verdad (SQLAlchemy + Pydantic + Alembic). En Fitz es UN type con decoradores. Plus 8" RPS y 5" menos memoria que SQLAlchemy en bench reproducible. Para cada entidad de tu…...
North Korea-Linked Hackers Hide Java Script Loaders in Open Source Repositories
13+ hour, 51+ min ago (614+ words) A new wave of supply chain attacks is spreading across the open source world, and this time the target is developers themselves. Security researchers have uncovered a campaign called Polin Rider that hides malicious Java Script loaders inside trusted code…...