Data foundationsBy Harsh Vardhan Goswami
From Dashboards to Decisions: What a Modern Analytics Platform Should Do
How teams can carry a question from dashboard signal through governed investigation to a reviewable operational next step.
Read articleField notes / 13 issues
Systems worth inspecting.
Practical notes on building data work that stays governed, inspectable, and useful to the people responsible for the answer.
Latest story
Archive
12 articles
Data foundationsBy Harsh Vardhan Goswami
Using the SyneHQ SQL Extension from Jupyter
A practical guide to using the SyneHQ Jupyter SQL extension, including its connection model, query outputs, access boundaries, and operating caveats.
Read article
Systems practiceBy Harsh Vardhan Goswami
Centralizing Session Checks with an NGINX Auth Proxy
How this OpenResty and NGINX auth proxy validates Auth.js JWE session cookies, fails closed, and sets boundaries for mixed-language services.
Read article
Applied AIBy Harsh Vardhan Goswami
Long Context in LLMs: Testing Degradation Before Production
How to evaluate long-context LLM behavior with position-aware retrieval tests, realistic distractors, model-specific measurements, and operational safeguards.
Read article
Data foundationsBy Harsh Vardhan Goswami
Auditing PostgreSQL Schema Changes with Event Triggers
A practical PostgreSQL event-trigger audit pattern for recording DDL context, limiting access, testing behavior, and planning retention.
Read articleData workBy Harsh Vardhan Goswami
What Is a Data Lake? Architecture, Tradeoffs, and Use Cases
A practical explanation of data lakes, their storage and governance layers, common failure modes, and when a warehouse or federation is a better fit.
Read article
Systems practiceBy Harsh Vardhan Goswami
MongoDB Search Projections with Monstache and Elasticsearch
A build note on using Monstache to maintain an Elasticsearch search projection from MongoDB, including sync, recovery, and rollback work.
Read articleSystems practiceBy Harsh Vardhan Goswami
Building Rabbit: A Self-Hosted TCP Tunnel with Persistent Ports
A build note on Rabbit's token-to-port TCP tunnel model, connection flow, persistence, operations, and the security boundaries operators own.
Read article
Data foundationsBy Harsh Vardhan Goswami
Choosing Text Search: PostgreSQL, DuckDB, and External Engines
A practical comparison of PostgreSQL, pg_search, DuckDB FTS, and external search engines, with workload tradeoffs and selection checklists.
Read article
Data foundationsBy Harsh Vardhan Goswami
Phased PostgreSQL Schema Migrations with pgroll
Use pgroll's versioned schemas and expand-contract workflow to stage PostgreSQL changes while checking locks, backfills, clients, and rollback boundaries.
Read article