News
I just published Postgres MCP Server in Go!
1+ hour, 29+ min ago (273+ words) I open sourced a project I have been building on the side: a Go MCP server that connects Claude Code (or Cursor) directly to a live Postgre SQL database. Most "AI plus database" workflows still look like this: copy SQL…...
Stop using the default terminal. You need these 5 CLI tools immediately. "
1+ hour, 58+ min ago (176+ words) If you spend more than 10% of your day in the command line, the default terminal is slowing you down. Here are 5 tools you need to install immediately to 10x your speed. The absolute standard. Auto-suggestions and themes make navigating directories effortless....
I'm building Osquil, a schema-aware query workbench for osquery
12+ hour 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
11+ hour, 59+ 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
12+ hour, 15+ 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
12+ hour, 58+ 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
14+ hour, 40+ 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
14+ hour, 44+ 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.
16+ hour, 48+ 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
20+ hour, 51+ 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…...