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
1+ hour, 39+ 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
2+ hour, 42+ min ago (20+ words) Mermaid erDiagram is great for... Tagged with mermaid, sql, database, opensource....
Database Indexing Mistakes That Are Quietly Killing Your App's Performance
7+ hour, 36+ 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?
10+ hour, 55+ 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
13+ hour, 15+ 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
10+ hour, 9+ 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
15+ hour, 35+ min 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?
15+ hour, 36+ min 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
18+ hour, 11+ min ago (23+ words) Sering kali kita... Tagged with postgres, mongodb, database, backend....
Window Functions in PySpark: A Practical Guide with ROW_NUMBER, RANK, LAG, LEAD, and Running Totals
14+ hour, 23+ min ago (104+ words) Non member readers can read it here for free If you work with Apache Spark, PySpark, Databricks, or SQL, sooner or later you will encounter a problem that looks deceptively simple: “For every customer, find their latest transaction.” “Calculate the…...