JAJuan Andrés Lópezinmetadriven.hashnode.dev·14h ago · 5 min readOracle JSON Has Grown Up I still remember the first time I had to store JSON in Oracle Database. The solution worked, but it wasn't exactly pleasant. Everything went into a CLOB, every query required JSON_VALUE(), and updatin00
AArisyninarisyn.hashnode.dev·1d ago · 7 min readDesigning an AI Data Infrastructure Layer for Enterprise AnalyticsModern enterprise AI isn't limited by language models anymore. It's limited by how well enterprise data can be understood. After working on enterprise analytics projects, I've become convinced that mo00
ACAlexander Codesinalexandercodes.hashnode.dev·1d ago · 10 min readHow to Evaluate AI-Generated SQL on DatabricksAn AI assistant can produce a query that runs and returns a plausible result. But how do we know if it's correct? Suppose a user asks: Which enterprise customers had revenue growth last quarter? An 00
JJubsindreaded-developer.hashnode.dev·2d ago · 15 min readManaging Database Changes: SQL Projects, DbUp, and the Alternatives You Should Actually Know"The scariest deploy is the one that touches the database. But it doesn't have to be." We talk a lot about application code quality — unit tests, clean architecture, SOLID principles — but database c00
AArisyninarisyn.hashnode.dev·6d ago · 1 min readData, Metadata, and Knowledge Are Not The Same ThingThe data industry often treats these concepts as interchangeable. They’re not. Data tells you what exists. Metadata tells you what it means. Knowledge tells you how it’s actually used. That’01M
KSKanishka Shashiinnodej.hashnode.dev·Jun 23 · 10 min readModern Database Access: Prisma, Drizzle, and ORMs ExplainedWhere Does Application Data Live After a User Closes the App? Imagine you're using an e-commerce application. You create an account, add products to your cart, place an order, and close the app. The n00
BKBalaji Kottanaindatanarratives.hashnode.dev·Jun 22 · 9 min readSnowflake Micro-Partitions: The storage unit that powers everythingPlatform: Snowflake · Parquet · Delta Lake · Iceberg · BigQuery · Redshift · ClickHouse Topics: Micro-partitions · No partial partition · Partition pruning · Column pruning · Columnar storage · Cross-30
VSVijay Sandeep Veeramreddyinvvscodes.hashnode.dev·Jun 22 · 2 min readWeek 2 in Bengaluru: SQL Progress, Job Hunting, and Unexpected LessonsAnother week has passed since I started my Python Full Stack journey in Bengaluru, and this week taught me lessons both inside and outside the classroom. Python Progress This week, our Python classes 00
Ssamueltohinsamueltoh.hashnode.dev·Jun 21 · 3 min read Point-in-polygon: one PostGIS query for geofencing, zones, and spatial lookupsYou've got a coordinate. You've got a pile of regions on a map. You need to know: which region does this point fall in, or is it inside one at all? That single question hides inside a lot of features:00
AHAutumn Hendersoninautumnhenderson.hashnode.dev·Jun 20 · 7 min readImplementing Feature Flags Across StackShipping an application that I didn't have access to was giving me heartburn. So I decided to create a lightweight feature flag tool. The Problem The team that I work on recently shipped a Vue 3, C#, 00
