Browsing Tag
backend
82 posts
REST Pagination techniques
My thoughts had always been that pagination was straightforward — just throw in a LIMIT and OFFSET and…
Mastering Postgres Window Functions for Data Analysis in Supabase
Postgres window functions are a powerful SQL feature that lets you perform calculations across rows related to the…
Secure Remote Access with AWS Verified Access
Managing secure connectivity to private workloads has always been a challenge. Traditionally, organizations relied on VPNs or bastion…
APIs are everywhere. But how do we test them without breaking the bank?
If you’ve been around long enough, you probably remember the glory days of service virtualization. (If you don’t…
Code Smell 309 – Query Parameter API Versioning
Misusing query parameters complicates API maintenance TL;DR: Use URL paths or headers for API versioning. Problems 😔 Confusing…
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle When working with Oracle databases, developers and DBAs often…
Stop-Guessing-Start-Measuring-A-Pragmatic-Guide-to-Web-Performance
GitHub Home Stop Guessing, Start Measuring: A Pragmatic Guide to Web Performance It was another Black Friday. At…
POST API for pushing content on Devto
First of all let’s see the code below // Function to post to Dev.to app.post("https://dev.to/post-to-devto", async (c) =>…
Introduction to system design
What is system design? System design is the process of defining the elements of a system, as well…
