Databases Resources

Getting Started With DuckDB in Python: A Fast and Lightweight Analytics Database

DuckDB is an embedded SQL OLAP engine that runs analytical queries on local files and DataFrames in Python, with minimal setup and no external server.

July 28, 2025

by Praveen Kumar Myakala

· 9,300 Views · 56 Likes

AWS vs. Azure vs. GCP: A Comprehensive Guide to Choosing the Right Cloud Provider

The three most well-known cloud providers by highlighting their unique strengths, diverse services, and various pricing plans, enabling you to make informed decisions.

July 28, 2025

by Sairamakrishna BuchiReddy Karri

· 2,573 Views

Building Intelligent Applications Using Generative AI and Azure Database for PostgreSQL

Embed GenAI into PostgreSQL using Azure extensions for semantic search, predictions, and smart applications — directly within your data layer.

July 28, 2025

by Aravind Nuthalapati

CORE

· 11,383 Views · 2 Likes

Test Pyramid: Test Setup Best Practices

Here, I revisit the plain old test pyramid and will speak a lot about how one can structure the tests to make them more reliable and profitable.

July 25, 2025

by Bartłomiej Żyliński

CORE

· 1,577 Views · 2 Likes

Data Partitioning and Bucketing: How Modern Data Systems Organize and Optimize Your Data

This article explains how partitioning and bucketing work in the big data world and talks about best practices that you can follow.

July 24, 2025

by Rajanikantarao Vellaturi

· 4,312 Views · 6 Likes

How LangChain Is Powering Next-Gen AI Apps: A Developer’s Guide in 2025

LangChain is a pivotal framework empowering developers to efficiently integrate advanced language models into AI applications.

July 24, 2025

by Sairamakrishna BuchiReddy Karri

· 3,510 Views · 1 Like

Deploying Containers on Azure Container Apps

In this article, we’ll explore Azure Container Apps and walk through example ARM templates to demonstrate how to deploy them within an Azure environment.

July 24, 2025

by Siri Varma Vegiraju

CORE

· 3,389 Views

What Is Availability? Theory, Problems, Tools, and Best Practices

What is availability? Today, I will answer that question, dive into challenges, and share best practices related to availability.

July 24, 2025

by Bartłomiej Żyliński

CORE

· 2,605 Views · 2 Likes

Configuring Model Context Protocol (MCP) With Amazon Q CLI

In this post I share how MCP Servers can help provide better context with Amazon Q CLI, a next generation AI Coding Assistant

July 23, 2025

by Ricardo Sueiras

· 5,370 Views · 1 Like

Automating a Web Form With Playwright MCP and MySQL MCP

Learn how to automate form filling using Playwright MCP and MySQL MCP by fetching real-time data from a database with minimal scripting.

July 23, 2025

by Kailash Pathak

CORE

· 3,626 Views

Implementing Least Privilege in AWS IAM: Principles, Practices, and Automation

Applying least privilege in AWS IAM helps reduce risk, improve compliance, and secure environments by granting only necessary permissions to users and services.

July 22, 2025

by Ishwar Bansal

· 4,297 Views · 2 Likes

Building a Multi Tenancy Platform Using Camunda

This guide shows how to build a multi-tenant platform using Camunda BPM, covering AWS deployment, tenant isolation, upgrades, observability, and scaling best practices.

July 22, 2025

by Lakshmi Narayana Rasalay

· 1,915 Views · 1 Like

Debugging Distributed Flight Search: What Logs Alone Won’t Tell You

Logs aren’t enough. Learn how tracing, metrics, and correlation IDs help debug fare mismatches in distributed flight search systems.

July 22, 2025

by Ravi Teja Thutari

CORE

· 2,323 Views · 3 Likes

Automation of IT Incident Reports Using Observability API and GenAI

A summary of the integration of observability API and GenAI to automate preliminary incident reporting with a sample incident report from on-prem and cloud models.

July 18, 2025

by Pandian Ramaiah

· 3,829 Views

Burn that List: Smarter Use of Allowlists and Denylists in Multi-Tenant Systems

Without a burndown plan, access lists become rigid, outdated, and risky. Prefer dynamic, policy-based controls that adapt over time.

July 18, 2025

by Ramchandran Maharajapuram Easwarasharma

· 4,362 Views · 1 Like

How We Built a Smarter University Chatbot Using LLaMA2, AWS SageMaker, and RAG

We built a multilingual university chatbot using LLaMA2, SageMaker, LangChain, and Milvus with RAG for real-time answers scalable to domains like healthcare and HR.

July 18, 2025

by Kishore Thota

· 4,547 Views · 1 Like

Developing Secure REST API Using Spring Boot SSL Bundle Feature

Learn how to secure REST APIs in Spring Boot using SSL and self-signed certificates. Set up HTTPS on the server and configure a client to consume secure endpoints.

July 18, 2025

by Jiwan Gupta

· 7,946 Views · 6 Likes

From Drift to Discipline: Operating Model for Regaining Enterprise Cloud Control

Enterprises chasing AI and scale won’t win with more tools—they’ll win by turning infrastructure into standardized infrastructure-as-code.

July 18, 2025

by Aharon Twizer

· 3,576 Views

Implementing Event-Driven Systems With AWS Lambda and DynamoDB Streams

Learn how to build a real-time, event-driven system using AWS Lambda and DynamoDB Streams to process data changes automatically without polling or extra infra.

July 18, 2025

by Akash Verma

· 3,703 Views · 2 Likes

Migrating Traditional Workloads From Classic Compute to Serverless Compute on Databricks

This tutorial explains the migration of Databricks workloads from Classic Compute to Serverless Compute for efficiency and cost effectiveness.

July 17, 2025

by Prasath Chetty Pandurangan

· 4,654 Views

The Latest Databases Topics