Centralized Job Execution Strategy in Cloud Data Warehouses
Control Diagram The Architecture: Core Components Query vault table Controller procedures Trigger point (can be an external or internal trigger) Details of Core Components 1....
Read MoreWhy Domain-Driven Design Is Still Essential in Modern Software Development
There’s no doubt that software has become the invisible infrastructure of our modern world. Over a decade ago, Forbes published a prophetic article titled ...
Read MorePython Development With Asynchronous SQLite and PostgreSQL
After years of working from the comfort of Python and Django, I moved to the wild asynchronous world of FastAPI to improve latency in web-based AI applications. I started with Fast...
Read MoreDistributed Locking in Cloud-Native Applications: Ensuring Consistency Across Multiple Instances
Overview I am sure that most of us may have used some kind of locking during development, or may have faced issues of incorrect results in some states that are difficult to reprodu...
Read MoreTypes of Web 3 APIs
An API (Application package interface) is a software tool that enables researchers and developers to access some third-party data and functionality within a main software. Usually,...
Read MoreIndexing Across Data Models: From Tables to Documents to Text
Every modern software application relies on a database to persist and manage its data. The choice of database technology is largely influenced by the application’s data model...
Read MoreBeyond Secrets Manager: Designing Zero-Retention Secrets in AWS With Ephemeral Access Patterns
Secrets management in AWS has traditionally relied on long-lived secrets stored in Secrets Manager or Parameter Store. But as attack surfaces grow and threat actors become faster a...
Read MoreAdvanced Snowflake SQL for Data Engineering Analytics
Snowflake is a cloud-native data platform known for its scalability, security, and excellent SQL engine, making it ideal for modern analytics workloads. Here in this article...
Read MoreCNCF Triggers a Platform Parity Breakthrough for Arm64 and x86
The Challenge Developing open-source software for deployment on Arm64 architecture requires a robust continuous integration and continuous deployment (CI/CD) environment. Yet, ther...
Read MoreWhat Is API Testing?
APIs are the buzzword of the software industry these days. They power most modern applications and allow seamless communication between different systems, services, and platforms....
Read MoreWhy Enterprise AI Needs Agentic Messaging Platforms
Enterprise AI initiatives often follow a predictable pattern. They launch with ambitious goals: "We need AI agents that can automate workflows, integrate with our systems, and exec...
Read MoreIntroduction to Spring Data Elasticsearch 5.5
It's been a while since my first article dedicated to Spring Data Elasticsearch usage as a NoSQL database was published. A couple of articles with configuration changes or hints fo...
Read MoreFixing a Test Involves Much More Than Simply Making It Pass
Software tests are essential mechanisms in the development lifecycle designed to verify that code behaves as expected. They catch bugs, ensuring functionality aligns with requireme...
Read MoreAI-Assisted Kubernetes Diagnostics: A Practical Implementation
Kubernetes troubleshooting follows a repetitive pattern: identify unhealthy pods, examine descriptions, review logs, analyze events, and correlate information to find root causes....
Read MoreEfficiently Reading Large Excel Files (Over 1 Million Rows) Using the Open-Source Sjxlsx Java API
If you are a developer, regardless of the technologies you use, at some point, you will face the challenge of handling large Excel files. Most commonly, you will see the "out of me...
Read MoreTransforming Your Node.js REST API into an AI-Ready MCP Server
The evolution of large language models (LLMs) and agentic AI requires a fundamental shift in how applications expose their capabilities. Traditional REST APIs are designed for soft...
Read MorePattern Searching and PostgreSQL Full-Text Search: Understanding the Mismatch
A while ago, a request emerged to implement a global find functionality in one of our products. Briefly, the purpose was to be able to search for multiple (different) entities by a...
Read MoreBuilding Cost-Effective Internet Scale Applications
As developers, it is important that when we build an application, we design keeping both its targeted scale and the cost of running it in mind. If we are building an internet-scale...
Read MoreBooleans vs Integers in Databases: Understanding the Trade-Offs
When designing a database, developers often encounter a seemingly simple decision: Should we use a boolean or an integer to represent a (decision) field? While the difference might...
Read MorePredictable Low Latencies for Apache HBase
Apache HBase Apache HBase is an open-source, strongly consistent distributed database designed to store record-oriented data across a scalable cluster of machines. HBase stores row...
Read More