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
Why I Keep My Database Layer Boring
1+ hour, 9+ 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
1+ hour, 38+ 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....
Your agent's SQLite state DB keeps corrupting: what actually causes it, and how to recover the data
2+ hour, 35+ 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
5+ hour, 49+ 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 /`
6+ hour, 4+ 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
6+ hour, 29+ 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…...
Sticky in process, gone on restart: auditing the state your CLI daemon keeps in memory
7+ hour, 14+ min ago (589+ words) A containment flag can be wired correctly, tested, documented, and still be a containment flag you do not have. The wiring is only half the story. The other half is where the baseline lives. Here is the whole audit, with…...
SQL Detectives: Solving Business Mysteries One Query At a Time
3+ hour, 5+ min ago (707+ words) Introduction The Question That Started It All Every journey starts with a question. Mine was this — how do companies understand all …...
Database Index Overhead: Write Amplification, Cache Pressure, and Maintenance Costs
8+ hour, 22+ min ago (367+ words) To evaluate indexing strategies objectively, systems engineers must balance read-path acceleration against the compounding storage and CPU costs of index maintenance. Databases rely on indexes to bypass full-table scans (heap scans), reducing disk I/O and CPU overhead during retrieval…...
Jev was the tipping point - I built the last MySQL search statement
8+ hour, 42+ min ago (70+ words) The problem that kept finding me was mapping unstructured data into an existing corpus. Supplier... Tagged with showdev, mysql, jev....