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.

Latest in SQL, Shell & Data Science


dev.to > support24htrack > your-tracking-integration-needs-a-date-sanity-check-1n3b

Your tracking integration needs a date sanity check

1+ hour, 26+ min ago   (667+ words) Every tracking integration I have seen trusts one thing it should not: that the newest event attached to a tracking number describes the shipment you are looking at. Most of the time it does. Then a support ticket arrives saying…...


dev.to > chenyuan20509 > sqlite-wal-does-not-mean-unlimited-writers-a-practical-python-playbook-2lkn

SQLite WAL Does Not Mean Unlimited Writers: A Practical Python Playbook

1+ hour, 39+ min ago   (1303+ words) A small service can run happily on SQLite for months, then begin throwing database is locked as soon as two background workers start processing jobs. Switching to Write-Ahead Logging (WAL) often improves the situation, but it does not turn SQLite…...


itjungle.com > 10/12/2026 > a-read-only-mcp-server-for-db2-for-i

A Read-Only MCP Server For Db2 for i

1+ hour, 59+ min ago   (668+ words) October 12, 2026 Alex Woodie IBM i developers who want to let their users query Db2 for i using AI tools like Claude Desktop and Cursor, but also want to limit their access to the database, may be interested in a new open…...


mayursurani.medium.com > 50-sql-interview-questions-worth-practicing-answered-with-real-queries-3d7e906abb0b

50 SQL Interview Questions Worth Practicing — Answered With Real Queries

4+ hour, 40+ min ago   (164+ words) From second-highest salaries to overlapping date ranges: a complete, hands-on prep guide with sample data you can run today. There is a moment in almost every data interview where the screen turns blank and a simple prompt appears: write a…...


dev.to > hackgo_6978 > keep-one-command-park-the-rest-until-monday-306m

Keep One Command. Park the Rest Until Monday.

9+ hour, 20+ min ago   (1213+ words) You sit down with a side project on Saturday morning. You want a tiny health page for one public repo. By noon the plan has three screens and no demo. That sprawl is the bug you should fix first. A…...


medium.com > @issuesphp > issuesphp-framework-multiple-database-connections-bc5601cffbaf

IssuesPHP Framework Multiple database connections

9+ hour, 46+ min ago   (78+ words) The IssuesPHP Framework allows you to connect to up to 12 different databases using PDO; let’s look at some examples. In the `Database.php` file, there is a default connection; if the `DB_NUMBER` constant is left empty or assigned the value 1, it…...


dev.to > ngmertey_joshua_b2b0fd299 > 3-weeks-learning-linux-filesystems-file-management-and-compression-3189

3 Weeks Learning Linux: Filesystems, File Management and Compression

9+ hour, 44+ min ago   (437+ words) It’s been 3 weeks since I started learning Linux at Akwannya Hub, and the journey has been both challenging and rewarding. Coming from a software development background, I’ve mostly interacted with computers through graphical interfaces. Learning Linux has pushed me to…...


dev.to > ngmertey_joshua_b2b0fd299 > week-4-of-learning-linux-bash-scripting-hardware-storage-and-networking-2c23

Week 4 of Learning Linux: Bash Scripting, Hardware, Storage, and Networking

9+ hour, 51+ min ago   (397+ words) It’s been four weeks since I started learning Linux at Akwannya Hub, and I’m gradually building a better understanding of how Linux systems work beyond basic commands. This week, I explored four important areas: Bash scripting, computer hardware, the Linux…...


dev.to > olgabraginskaya > where-did-my-data-go-benchmarking-llms-as-data-pipeline-detectives-21kd

Where Did My Data Go? Benchmarking LLMs as Data Pipeline Detectives

9+ hour, 50+ min ago   (403+ words) This is a submission for the Kaggle Benchmarking Challenge Every data engineer has gotten this ticket at least once. Someone from sales writes that Umbrella Corp is right there in the CRM but missing from the dashboard, and could you…...


medium.com > @idrisyusuff > understanding-group-by-and-order-by-in-sql-a-beginners-perspective-as-i-continue-learning-sql-86c2d4963f94

Understanding GROUP BY and ORDER BY in SQL: A Beginner’s Perspective As I continue learning SQL… | by Idris Yusuff | Oct, 2026

10+ hour, 13+ min ago   (337+ words) Understanding GROUP BY and ORDER BY in SQL: A Beginner’s PerspectiveAs I continue learning SQL, I’m discovering how different clauses help us organise data and answer questions more efficiently. Two concepts I studied recently are GROUP BY and ORDER BY....