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
SQL Is Surviving, Franklin: When One Query Isn't Enough
12+ hour, 54+ min ago (1774+ words) Franklin survived SQL JOINs. Last time, we made tables talk to each other. We connected students to classes, classes to teachers, and somehow convinced Franklin that duplicate rows were not a database malfunction. He was beginning to feel confident. "Which…...
Turning Mermaid ER diagrams into shareable 3D schema tours
13+ hour, 57+ min ago (20+ words) Mermaid erDiagram is great for... Tagged with mermaid, sql, database, opensource....
5 EXPLAIN ANALYZE Patterns Every Data Engineer Should Know
10+ hour, 42+ min ago (180+ words) If you’ve stared at PostgreSQL’s EXPLAIN ANALYZE output and felt completely lost, you're not alone. A few months ago, I spent nearly three hours debugging a query that looked perfectly reasonable in code review but turned into a 15-second nightmare…...
Database Indexing Mistakes That Are Quietly Killing Your App's Performance
18+ hour, 51+ min ago (459+ words) Indexing is one of those topics every developer has heard of, most have used, and surprisingly few have actually reasoned through carefully. It's easy to add an index and move on — it's much harder to know whether that index is…...
NO idea where to start learning SQL?
22+ hour, 10+ min ago (246+ words) This article is a beginner friendly guide that gets you started into learning SQL as a programming... Tagged with programming, productivity, beginners, webdev....
Nightmare on Linux ST
1+ day, 30+ min ago (570+ words) canonical_url: https://theprettyrejectsguidetotechnology.blogspot.com/2026/08/nightmare-on-linux-st.html A quick one from my ongoing series on what it's actually like learning tech as a non-traditional student — bumps, bruises, and the occasional fever dream included. I have been having a recurring nightmare involving TUX the penguin. If you…...
SQLDungeon: Now with DuckDB
21+ hour, 24+ min ago (35+ words) SQL Dungeon grew a DuckDB marsh this weekend. Why, well because I wanted to learn it. SQL Dungeon started as a browser dungeon crawler where every room is a SQL puzzle …...
MySQL Overselling: Why SELECT Isn't Enough and How SELECT... FOR UPDATE Solves It
1+ day, 2+ hour ago (431+ words) Imagine you’re running an online store, there’s exactly one item left in stock. Two customers click... Tagged with database, mysql, backend, softwareengineering....
Two Transactions, One Row: What Does MySQL Actually Let You See?
1+ day, 2+ hour ago (554+ words) Two users, One database row, Both reading and writing at almost exactly the same time. Who sees... Tagged with database, mysql, softwareengineering, backend....
SQL vs NoSQL: Kenapa PostgreSQL Masih Jadi 'Swiss Army Knife' di 2026
1+ day, 5+ hour ago (23+ words) Sering kali kita... Tagged with postgres, mongodb, database, backend....