DEV Community

Arpit Bangre profile picture

Arpit Bangre

Data Engineer specializing in Enterprise Database Architecture, SQL Performance Optimization, Distributed Data Pipelines, and Modern Cloud Data Platforms. Passionate about building robust, scalable da

Joined Joined on  github website
Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)
arpitmbangre profile

Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

#sql #datascience #database #dataengineering
Comments
2 min read

Want to connect with Arpit Bangre?

Create an account to connect with Arpit Bangre. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
arpitmbangre profile

SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

#sql #database #dataengineering #beginners
Comments
2 min read
Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)
arpitmbangre profile

Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)

#sql #database #dataengineering #career
Comments
2 min read
Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained
arpitmbangre profile

Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

#database #sql #dataengineering #performance
Comments
2 min read
SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds
arpitmbangre profile

SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds

#sql #database #dataengineering #backend
1
Comments 2
1 min read
loading...