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
Oracle HCM Position Hierarchy Explained: A Beginner's Guide to Structure, Setup, and HDL
1+ hour, 27+ min ago (225+ words) Introduction I recently came across the concept of Position Hierarchies in Oracle HCM and,... Tagged with beginners, learning, management, tutorial....
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17
1+ hour, 35+ min ago (968+ words) At one interview I was asked about VIEWs. I answered honestly: in real projects I had barely run into them; for aggregates it is safer to keep a separate table. One of the interviewers said, “You understand nothing about VIEWs,…...
Designing and Implementing Semantic Data Layers (Technics Publications)
2+ hour, 28+ min ago (27+ words) Programming book reviews, programming tutorials,programming news, C#, Ruby, Python,C, C++, PHP, Visual Basic, Computer book reviews, computer history, programming history, joomla, theory, spreadsheets and more....
SQL Is Surviving, Franklin: When One Query Isn't Enough
15+ hour, 55+ 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
16+ hour, 58+ min ago (20+ words) Mermaid erDiagram is great for... Tagged with mermaid, sql, database, opensource....
5 EXPLAIN ANALYZE Patterns Every Data Engineer Should Know
13+ hour, 43+ 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
21+ hour, 52+ 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?
1+ day, 1+ hour 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, 3+ hour 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+ day, 25+ 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 …...