Advanced SQL Window Functions – Part 3: Ranking and Value Functions (RANK, ROW_NUMBER, NTH_VALUE)
In the Part 1 of this blog series, we learnt how to create a frame using frame_types…
Continue ReadingAdvanced SQL Window Functions – Part 2: PARTITION BY, EXCLUDE, LAG & LEAD
In the Part 1 of this blog series, we learnt how to create a frame using frame_types…
Continue ReadingAdvanced SQL Window Functions – Part 1: Understanding Frame Types (ROWS, RANGE, GROUPS)
SQL is a remarkably rich and versatile declarative database and programming language.Development…
Continue ReadingUtilizing Threads in Ruby for Better Performance
We all know what a process is it is a unit of work with a single thread of control.Thread is also a lightweight…
Continue ReadingFastify on Lambda: Serverless Deployment Guide
An efficient server implies a lower cost of the infrastructure, better responsiveness under load, and happy…
Continue ReadingPredicting NFT Image Prices with AI
An NFT is an image in the form of a digital token. These tokens are then sold online. AN NFT can be anything in digital…
Continue Reading