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
Day 8 - Relational Database 101 - PostgreSQL Internals
2+ hour, 28+ min ago (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...
Why Parameterized Queries Matter for SQL Security
2+ hour, 48+ 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…...
Recursive CTEs: How SQL Secretly Learned to Loop
3+ hour, 43+ 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…...
EXPLAIN Describes a Query. Production Is Everything Else That’s Running.
1+ hour, 37+ min ago (1398+ words) A while back I wrote about migrating a terabyte of banking data from Oracle to PostgreSQL with no downtime. The part people …...
I Replaced Chroma, Qdrant, and Pinecone With a SQLite File
1+ hour, 34+ min ago (165+ words) I needed a vector DB that didn’t require a daemon. SQLite was already there. Every RAG tutorial starts the same way. Step one: install …...
Every text-to-SQL benchmark score you've seen was measured without access control
6+ hour, 12+ min ago (955+ words) Spider, BIRD, LiveSQLBench. If you have evaluated a text-to-SQL system in the last five years you have quoted a number from one of them. All three ask the same question: given a schema and an English question, does the system…...
Linux common commands every developer should know
7+ hour, 36+ min ago (159+ words) The command line is one of the most powerful and efficient ways to interact with Linux systems. For developers, knowing the commands can make tasks much faster and easier. This article provides a reference of useful Linux commands for developers....
Before You Learn Linux Commands, Read This First
6+ hour, 59+ min ago (34+ words) Did you know that every time you use Android, browse a website, stream Netflix, or deploy an application to the cloud, there’s a high chance Linux …...
My Terminal Was Fine. These Tools Make It More Useful
7+ hour, 17+ min ago (35+ words) A few useful finds for everyday frustrations As a Software Engineer, I find it exciting to discover new tools and those that makes me wonder …...
IEnumerable vs. IQueryable in C#
8+ hour, 16+ min ago (429+ words) This distinction sounds simple stated this way, but it has real, concrete consequences for where computation happens, how much data crosses the network, what C# expressions are even legal to write, and a specific, common class of bug that this…...