SQL, Shell & Data Science

SQL, Bash/PowerShell, and scientific computing languages for analysis and ops.

  • 8 Tracked terms
  • Last 30 days Feed window
Search within this topic Ask AI about this topic All topics

What this topic collects on

An article joins this feed when it matches these terms. Each one is also a search of its own.

Latest in SQL, Shell & Data Science


dev.to > rose_odiwuor > when-sql-has-nothing-to-say-handling-nulls-34jm

When SQL Has Nothing to Say: Handling NULLs

17+ 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....


dev.to > milkyway008 > your-agents-sqlite-state-db-keeps-corrupting-what-actually-causes-it-and-how-to-recover-the-data-55hd

Your agent's SQLite state DB keeps corrupting: what actually causes it, and how to recover the data

1+ hour, 14+ 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,…...


dev.to > joseph_mwangi_3ae1f57a132 > window-functions-vs-aggregate-functions-in-sql-a-beginner-friendly-guide-i72

Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

4+ hour, 28+ 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....


dev.to > aurelionakamura > i-taught-my-shell-to-stop-me-before-i-run-rm-rf--2j9k

I taught my shell to stop me *before* I run `rm -rf /`

4+ hour, 43+ 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…...


dev.to > paganini2008 > easyjpa-type-safe-dynamic-queries-in-three-lines-not-thirty-542e

EasyJPA: Type-Safe Dynamic Queries in Three Lines, Not Thirty

5+ hour, 8+ 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…...


dev.to > pm25coder > sticky-in-process-gone-on-restart-auditing-the-state-your-cli-daemon-keeps-in-memory-48fb

Sticky in process, gone on restart: auditing the state your CLI daemon keeps in memory

5+ hour, 53+ 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…...


medium.com > @roshniichharampatil > sql-detectives-solving-business-mysteries-one-query-at-a-time-7a067007370f

SQL Detectives: Solving Business Mysteries One Query At a Time

1+ hour, 44+ 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 …...


dev.to > wantsvibes > database-index-overhead-write-amplification-cache-pressure-and-maintenance-costs-3p3g

Database Index Overhead: Write Amplification, Cache Pressure, and Maintenance Costs

7+ hour, 1+ 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…...


dev.to > maayanlevy > why-i-built-a-mysql-plugin-that-understands-natural-language-46c1

Jev was the tipping point - I built the last MySQL search statement

7+ hour, 21+ min ago   (70+ words) The problem that kept finding me was mapping unstructured data into an existing corpus. Supplier... Tagged with showdev, mysql, jev....


dev.to > serguey_shinder_4ab9b87b1 > seven-things-were-reading-that-database-and-none-of-them-were-listed-cfn

Seven Things Were Reading That Database and None of Them Were Listed

9+ hour, 18+ min ago   (782+ words) We retired an order history system in March after eighteen months of migration. Ninety days of notice went to every department, twice. Nobody objected. We switched it off on a Friday evening, and by Monday afternoon seven things had broken,…...