Martin·Just nowShrink a Postgres Index by Indexing Only the Rows You QueryA partial index on 50,000 pending jobs was 1.1 MB instead of 150 MB, and the query was just as fast
InSnowflake Builders Blog: Data Engineers, App Developers, AI, & Data SciencebyAkshay Sharma·Just nowTreat LLM Output as Evidence, Not Truth: A Production Pattern for Sentiment and NERHow to turn customer comments into validated, graph-ready data with Snowflake Cortex, and what the demos leave out
Basak Kaya·Just nowSQL vs. Pandas: Comparing Data Manipulation TechniquesThe same operations, two different approaches.
Ivone Atieno·6h agoI Tried to Predict US Retail Bankruptcies from SEC Filings. My Own Test Said It Didn’t Pass.A data analyst’s account of building an early-warning score, locking the rules before testing, and reporting a result that fell short.
Amanda Iglesias Moreno·10h agoFrom EXTRACT to GROUP BY ROLLUP: 15 SQL Functions You Should Know (Part 2)How to start learning SQL fundamentals
Abolfazl Kameli·10h agoWhat Is a Functional Dependency in Database Design?Understand how functional dependencies define relationships between attributes and normalize relational databases.
Nazmul Hasan·11h agoPostgres MERGE vs INSERT ON CONFLICT: MERGE Failed 3 of 4 Concurrent BatchesI timed eight bulk upserts from Python on PostgreSQL 18. The statement barely changed the speed. Skipping unchanged rows cut WAL by 4x.A response icon1A response icon1
Jesse Ruiz (she/they)·11h agoT-SQL Data Profiling ChallengeIn this article, I provide readers with a hands-on T-SQL coding challenge: writing a reusable data profiling query. Profiling is the…A response icon1A response icon1
Victor Magallanes at IT Solutions Network·12h agoPulling Order Details from Customer Emails with Claude: The NOT STATED Rule, ExplainedBoth prompts got 115 of 124 fields exactly right on 30 emails. The plain prompt then wrote a date the email never gave, and turned “around…