Install
SQL, Shell & Data Science
SQL, Bash/PowerShell, and scientific computing languages for analysis and ops.
- 8 Tracked terms
- Last 30 days Feed window
What this topic collects on
An article joins this feed when it matches these terms. Each one is also a search of its own.
Related topics
Latest in SQL, Shell & Data Science
Subqueries and CTEs: Asking a Question Inside a Question
49+ min ago (624+ words) Some questions can't be answered in one pass. "Which hive produced the most honey?" needs the maximum honey figure before it can find the hive that matches it. "Which keepers are above average?" needs the average before it can compare…...
A New Take on Raw SQL in Python
8+ hour, 39+ min ago (926+ words) I've been using the excellent PugSQL library for some years now. It's very easy to use: just annotate your SQL queries in a text-file with a name, result-type and parameters; then load the sql file with a PugSQL module and…...
SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY
13+ hour, 20+ min ago (392+ words) Some SQL problems look simple until you read the rules twice. This one is tagged Apple and rated hard, and it teaches a useful pattern: grouping the results of a grouping. Let's solve it step by step. A power purchaser…...
Chunking Strategies for Structured Data in RAG Systems (Part 2): Where Text-to-SQL Falls Short | HackerNoon
18+ hour, 24+ min ago (983+ words) This is Part 2 of a three-part series. Part 1 covered how to chunk structured data so a retriever can find it. This article covers the first query pattern, i.e., RAG-based Text-to-SQL. We discuss what works, what doesn't, and where it hits its…...
Build a Valorant Uninstaller: PowerShell Script [2026]
20+ hour, 3+ min ago (1762+ words) Either mode leaves traces after a normal uninstall: the driver file, the service registrations in the registry, and folders under Program Files and ProgramData. A script that checks each of those locations explicitly, rather than trusting the Riot uninstaller to…...
Database Transactions Are a Boundary, Not a Safety Blanket
17+ hour, 24+ min ago (783+ words) The uncomfortable part of a failed payment flow is not always the error. Sometimes the function returns an error and the database still keeps half of the work. That is the failure Lab 03 demonstrates. A payment is inserted. The order…...
One Line of mv Kills the 4x Duplicate Run After Recovery: Making launchd Queue Processing Idempotent
19+ hour, 48+ min ago (1359+ words) Six months ago my side business made ¥0 a month. This month it's ¥1.2M, running on an autonomous... Tagged with automation, launchd, bash, claudecode....
How to Monitor Cron Jobs with a Simple HTTP Health Check
22+ hour, 16+ min ago (409+ words) Cron jobs are great for automating repetitive tasks, but there is one problem: What happens when the job stops running? A cron entry can exist for months without anyone noticing that the script has started failing. For example, you might…...
PostgreSQL Will Let You Invent a Type, Right Up Until It Asks for a C Compiler
19+ hour, 26+ min ago (41+ words) A partner feed lands a million order rows a day, and the order date arrives as 03/15/2021. Someone stores it in a text …...
Why I Keep My Database Layer Boring
1+ day, 45+ min ago (551+ words) When building an application, it's easy to get excited about the visible parts. A new Compose screen. The database usually gets less attention. But while working on FinLedger, I've found that the database layer is one of the places where…...