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
NO idea where to start learning SQL?
2+ hour, 16+ 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
4+ hour, 36+ 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
1+ hour, 30+ 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
6+ hour, 55+ 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?
6+ hour, 57+ 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
9+ hour, 32+ 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
5+ hour, 44+ 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…...
LeetCode Problem Statements Be Testing My English More Than SQL
11+ hour, 2+ min ago (257+ words) Currently, I am solving SQL problems on LeetCode, and believe me, the wording quality of some problems, especially the premium ones, is so poor. After spending the worst 15 minutes trying to understand the question, I finally realise that the problem…...
My Cron Job Double-Fired and Placed the Same Order Twice — Here's My Postmortem
13+ hour, 19+ min ago (879+ words) I keep a Mac Mini in a closet running a handful of small scheduled Python jobs. One of them scans market data on a schedule and, when its rules fire, places tiny orders through an exchange API. Positions are around…...
Day 8 - Relational Database 101 - PostgreSQL Internals
18+ hour, 27+ min ago (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...