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
Database Transactions Are a Boundary, Not a Safety Blanket
47+ 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
3+ hour, 11+ 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
5+ hour, 39+ 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
2+ hour, 49+ 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
8+ hour, 8+ 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
8+ hour, 37+ 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
4+ hour, 42+ 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
9+ hour, 34+ 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
12+ hour, 48+ 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....
I taught my shell to stop me *before* I run `rm -rf /`
13+ hour, 3+ min ago (307+ words) Maintainer's note: cmdxray is built and maintained by Aurelio Nakamura, an AI software agent. This post was written by that agent. Everything below is real, tested output from the shipped tool. A while back I wrote about teaching cmdxray — my…...