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
Understanding Hybrid Table Bulk INSERTs
1+ hour, 43+ min ago (447+ words) With our release of Hybrid Table Bulk INSERT, we are bringing the faster performance of Optimized Bulk Loads to more INSERT queries, achieving up to 10x faster batch INSERTs.[0] Hybrid Tables leverage a row store as the primary data store to…...
Turn Any SQL Query Into an OCI Monitoring Metric — From Inside Autonomous AI Database
3+ hour, 50+ min ago (1158+ words) Information, tips, tricks and sample code for data management in an autonomous, cloud-native, data-driven world No agent. No function. No compute instance. Just a SELECT and a scheduler job. Autonomous AI Database gives you more than forty metrics in OCI…...
Bridging Local and Cloud Databases for Centralized Data Management
2+ hour, 13+ min ago (276+ words) Introduction Structured data (typically in rows and columns) resides in databases such as... Tagged with postgres, dbeaver, aiven, powerbi....
Subqueries and CTEs: Asking a Question Inside a Question
3+ hour, 4+ min ago (624+ words) Some questions can't be answered in one pass. "Which hive produced the most honey?" needs the maximum honey figure before it can find the hive that matches it. "Which keepers are above average?" needs the average before it can compare…...
A New Take on Raw SQL in Python
10+ hour, 53+ min ago (926+ words) I've been using the excellent PugSQL library for some years now. It's very easy to use: just annotate your SQL queries in a text-file with a name, result-type and parameters; then load the sql file with a PugSQL module and…...
SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY
15+ hour, 34+ min ago (392+ words) Some SQL problems look simple until you read the rules twice. This one is tagged Apple and rated hard, and it teaches a useful pattern: grouping the results of a grouping. Let's solve it step by step. A power purchaser…...
Chunking Strategies for Structured Data in RAG Systems (Part 2): Where Text-to-SQL Falls Short | HackerNoon
20+ hour, 39+ min ago (983+ words) This is Part 2 of a three-part series. Part 1 covered how to chunk structured data so a retriever can find it. This article covers the first query pattern, i.e., RAG-based Text-to-SQL. We discuss what works, what doesn't, and where it hits its…...
Build a Valorant Uninstaller: PowerShell Script [2026]
22+ hour, 18+ min ago (1762+ words) Either mode leaves traces after a normal uninstall: the driver file, the service registrations in the registry, and folders under Program Files and ProgramData. A script that checks each of those locations explicitly, rather than trusting the Riot uninstaller to…...
Database Transactions Are a Boundary, Not a Safety Blanket
19+ hour, 39+ min ago (783+ words) The uncomfortable part of a failed payment flow is not always the error. Sometimes the function returns an error and the database still keeps half of the work. That is the failure Lab 03 demonstrates. A payment is inserted. The order…...
One Line of mv Kills the 4x Duplicate Run After Recovery: Making launchd Queue Processing Idempotent
22+ hour, 3+ min ago (1359+ words) Six months ago my side business made ¥0 a month. This month it's ¥1.2M, running on an autonomous... Tagged with automation, launchd, bash, claudecode....