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
Build a Valorant Uninstaller: PowerShell Script [2026]
5+ hour, 22+ 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
2+ hour, 43+ 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
5+ hour, 7+ 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
7+ hour, 35+ 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
4+ hour, 44+ 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
10+ hour, 4+ 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…...
When SQL Has Nothing to Say: Handling NULLs
10+ hour, 33+ min ago (44+ words) In Part 1 of the NULL series, we focused on: what NULL represents in a dataset: a value that is... Tagged with database, beginners, sql....
The Query That Finally Made SQL Click for Me
6+ hour, 38+ min ago (622+ words) Structured Query Language a.k.a SQL is a programming language that you can use to create, manipulate, manage, and query relational databases. It’s used …...
Your agent's SQLite state DB keeps corrupting: what actually causes it, and how to recover the data
11+ hour, 30+ min ago (974+ words) I run an agent that keeps its entire brain in one local SQLite file. Three weeks ago it came back with database disk image is malformed, and I did the first thing most of us do: deleted the -shm sidecar,…...
Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide
14+ hour, 44+ min ago (884+ words) If you have written SQL for more than a week, you have used SUM(), AVG() or COUNT(). They are the... Tagged with beginners, database, sql, tutorial....