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
One Line of mv Kills the 4x Duplicate Run After Recovery: Making launchd Queue Processing Idempotent
1+ hour, 39+ 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
4+ hour, 7+ 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
1+ hour, 16+ 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
6+ hour, 36+ 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
7+ hour, 5+ 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
3+ hour, 10+ 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
8+ hour, 2+ 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
11+ hour, 16+ 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 /`
11+ hour, 31+ 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…...
EasyJPA: Type-Safe Dynamic Queries in Three Lines, Not Thirty
11+ hour, 56+ min ago (617+ words) Every query is a lambda. Every join has a name. Not a single JPQL string. Here is the whole pitch in one screenshot's worth of code. Same query. Same type safety. Same generated SQL. Step 1 — add the dependency. The current…...