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
Building a Type-Safe Database Workflow With Kysely
2+ hour, 16+ min ago (823+ words) Kysely is a query builder, not an ORM. There's no entity layer, no lazy loading, no magic session flushing things behind your back. You describe your schema once as a TypeScript interface and from there every method on the builder…...
Online enabling checksums in PostgreSQL 19
7+ hour, 1+ min ago (270+ words) PostgreSQL 19 will support enabling checksums online, allowing them to operate in the background while the application remains active, possibly with throttling to lessen workload impact. Here's an example. To set up a demonstration database without checksums, I initialized it using…...
OLAP vs OLTP: A Comprehensive Guide to Their Roles, Differences, Optimization, and Convergence
7+ hour, 34+ min ago (426+ words) An OLTP database typically stores data in a row-oriented format. This organization is optimal for transactional workloads because it allows the database to quickly locate, insert, update, or delete a complete record—such as a single customer order—with minimal…...
SQL for Data Analysts: Full Outer and Cross Join with Examples
4+ hour, 29+ min ago (384+ words) Hello! I’m Cavid, an aspiring data analyst. Today, we are going to continue our series on SQL JOINs. In my previous article, We talked …...
Join MySQL Public Discussion #6 and the November Contributor Summit
15+ hour, 43+ min ago (328+ words) The MySQL Community conversation continues this fall with two opportunities to connect, share feedback, and help shape the future of MySQL. Following the recent Contributor Summits and Public Discussions, we are continuing to expand practical ways for users, developers, DBAs,…...
When One Legacy Position Code Isn't Enough: A Common Oracle HCM Data Conversion Challenge
10+ hour, 17+ min ago (86+ words) Introduction Data migration projects often appear straightforward on paper. The source... Tagged with oracle, hcm, hdl, etl....
SQL Window Functions — Explained Simply | SQL Interview Series #6
7+ hour, 3+ min ago (218+ words) If you have been working with SQL, you may have used GROUP BY to calculate things like SUM(), AVG(), COUNT(), and MAX(). But there …...
Oracle PL/SQL: CASE Expression vs. CASE Statement
11+ hour, 20+ min ago (379+ words) Conditional Control: CASE Expression vs. CASE Statement Preserved & Corrected Notes CASE Expression: Evaluates conditional logic and returns a single scalar value. CASE Statement: Evaluates conditional logic to execute procedural actions/statements. Structure & Block Inclusion: A CASE statement can form a…...
LIMIT 1 in PostgreSQL: The Simple Query Optimization That Can Save Millions of Rows from Being…
7+ hour, 31+ min ago (33+ words) LIMIT 1 in PostgreSQL: The Simple Query Optimization That Can Save Millions of Rows from Being Scanned When your application needs exactly one row, why ask PostgreSQL to find every matching row? This …...
The Best ETL Tools for Real-Time Data Integration in 2026
20+ hour, 13+ min ago (1624+ words) It makes sense, then, because a dashboard updated every 15 minutes is OK, but a fraud detection tool for card transactions cannot wait for 15 minutes. In other words, what really matters is the freshness of data rather than finding the best…...