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
MySQL Overselling: Why SELECT Isn't Enough and How SELECT... FOR UPDATE Solves It
1+ hour, 38+ 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?
1+ hour, 40+ 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
4+ hour, 15+ 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
27+ 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
5+ hour, 45+ 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
8+ hour, 2+ 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
13+ hour, 10+ min ago (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...
Why Parameterized Queries Matter for SQL Security
13+ hour, 30+ min ago (559+ words) SQL injection is one of the classic examples of what can happen when an application mixes user input directly into a database query. The underlying problem is simple. The application expects data. The database may interpret part of that data…...
Database Isolation Levels: What Can Concurrent Transactions Actually See?
9+ hour, 53+ min ago (743+ words) Transactions do not execute in isolation from reality. Isolation levels define how much of that reality they are allowed to observe. In the previous topic, we explored Optimistic and Pessimistic Concurrency Control. Now we can go one level deeper. What…...
Recursive CTEs: How SQL Secretly Learned to Loop
14+ hour, 25+ min ago (454+ words) Ask a SQL query to find "all employees under this manager," and things get ugly fast if you don't know how many levels deep the org chart goes. A regular join handles one level. Two joins handle two levels. Nobody's…...