VVisuaLeaf - MongoDB Data Workspace5h ago · 8 min readHow to Mask Sensitive Data in SQL: Make a Safe Database CopyData masking replaces sensitive values, like names, emails, and card numbers, with hidden versions. The result is a database copy you can share with developers or testers without exposing real people.visualeaf.hashnode.dev
CCraftstack Academy13h ago · 7 min readSQLite error "no such column": usually missing quotes, plus 4 other causesYou want the visitors who went into the room called Vault, so you write: SELECT name FROM visitors WHERE room = Vault; and SQLite answers: Error: no such column: Vault But Vault isn't supposed to becraftstack.hashnode.dev
HHu Jin1d ago · 4 min readFrom Requirements Doc to Working Code with Grok: Azure AI Search Integrated with a SQL DatabaseThe most common mistake people make with AI coding assistants is asking for the whole project at once: "Build me the entire thing." You get a pile of code that doesn't run, and when it breaks you havewhoai.hashnode.dev
CCraftstack Academy1d ago · 6 min readHow to Read an Error Message: A 3-Step Method for Python, Java, JavaScript and SQLEvery beginner meets the same moment: you press Run, the screen fills with red text, and your first instinct is to close it and stare at your code instead. Don't. The error message is the most useful craftstack.hashnode.dev
TThyne Ventures1d ago · 2 min readIs your Snowflake warehouse cache doing anything? One read-only query to checkWhen a warehouse suspends, its local disk cache is dropped, so the next queries read everything from remote storage again. This read-only query shows, per warehouse over the last 14 days, what share othyneventures.hashnode.dev
MMirinai1d ago · 3 min readI built a Windows SQL client where an LLM drafts the query and you stay in controlDisclosure: I work at Mirinai and built this app. This post was drafted with the help of AI and reviewed by me. It was first published on DEV. Letting an LLM near a database worries me in two ways: whmirinai.hashnode.dev
Ooctave Nkurunziza2d ago · 13 min readHow to find and fix slow PostgreSQL queriesTL;DR What you get: a repeatable way to find the queries that cost your database the most time, prove why they're slow, and fix them, with before-and-after numbers. Who it's for: developers running Poctave.hashnode.dev
TThyne Ventures2d ago · 2 min readIs your Snowflake warehouse too big for its queries? One read-only query to checkBigger warehouses double the credits per hour at each size step, but they only help when queries are large enough to use the extra compute. This read-only query looks at the last 14 days and shows, pethyneventures.hashnode.dev
Sspipaliya82d ago · 7 min readFirstOrDefault vs SingleOrDefault in EF Core: Which One Should You Use?When working with Entity Framework Core, we often need to retrieve a single record from the database. For example: Fetch a customer by email. Get the latest order. Retrieve a user by their unique ID.sudhirpipaliya.hashnode.dev
VVrushika D2d ago · 5 min readThe Hidden Role of Database Indexing in Managing Large QR Code CollectionsQR codes are easy to generate, but managing thousands or even millions of them efficiently is a different engineering challenge. Consider a platform where businesses generate QR codes for product labedigitalqr.hashnode.dev
