Databases Resources

Problem Analysis in Apache Doris StreamLoad Scenarios

Troubleshoot common Apache Doris StreamLoad import errors, including missing partitions, data type mismatches, and special character issues, for smooth syncing.

April 3, 2025

by li yy

· 6,719 Views · 3 Likes

Lessons from Migrating an Oracle Database to AWS RDS

Migrating an on-prem Oracle database to AWS RDS brings cost savings and automation but comes with performance tuning limits, upgrade challenges, and DBA restrictions.

April 2, 2025

by arvind toorpu

CORE

· 4,755 Views · 3 Likes

AWS CloudTrail Monitoring Using Event-Driven Ansible

Automate AWS CloudTrail event responses with Event-Driven Ansible. Learn how to monitor EC2 actions and trigger workflows for security, compliance, and efficiency.

April 2, 2025

by Binoj Melath Nalinakshan Nair

CORE

· 6,498 Views · 6 Likes

How to Build a New API Quickly Using Spring Boot and Maven

Realizing that not all use Gradle, I thought I would demonstrate how quickly a RESTful API can be created by leveraging ChatGPT, Spring Boot, Maven, and Heroku.

April 1, 2025

by John Vester

CORE

· 51,371 Views · 15 Likes

Understanding SQL Server Query Store: A Comprehensive Guide

In this article, we will explore what the Query Store is, its benefits, scenarios for its use, and steps to implement it with examples.

April 1, 2025

by arvind toorpu

CORE

· 6,944 Views · 8 Likes

Building Scalable Data Lake Using AWS

Build a secure, scalable AWS data lake with S3, Glue, and Lake Formation, and learn key components, best practices, and analytics for optimized insights.

April 1, 2025

by Digvijay Waghela

· 4,908 Views · 3 Likes

Understanding Database Consistency: A Key Concept in Distributed Systems

This article explores database consistency models in distributed systems and explains trade-offs between strong, eventual, causal, and other consistency types.

March 31, 2025

by Sandeep Kumar Gond

· 6,419 Views · 5 Likes

Doris vs Elasticsearch: A Comparison and Practical Cost Case Study

Apache Doris excels in analytics, SQL support, and cost efficiency, while Elasticsearch leads in text search but has higher storage costs and complexity.

March 31, 2025

by Darren Xu

· 3,924 Views · 2 Likes

Stop Exposing Secrets! Secure Your APIs in Postman Like a Pro

Don't expose your secrets! Learn how to secure your APIs in Postman with Vault, Secret Scanner, and best practices to keep your data safe.

March 31, 2025

by Gbadebo Bello

· 4,785 Views · 6 Likes

AWS WAF Classic vs WAFV2: Features and Migration Considerations

AWS WAFV2 is a major upgrade over WAF Classic, offering better scalability, flexibility, and automation. We'll also look at key migration considerations.

March 31, 2025

by Srinivas Chippagiri

CORE

· 20,785 Views · 2 Likes

Product Design vs Platform Design for Software Development

Compare platform and product design approaches for business needs. Understand their differences and compare them to find the best fit for your use case.

March 31, 2025

by Ravi Kiran Mallidi

CORE

· 4,573 Views · 5 Likes

The Role of DevSecOps in Securing Multi-Cloud Architectures

Discover how DevSecOps enhances security in multi-cloud ecosystems, enabling safe implementation and addressing key challenges with effective strategies.

March 31, 2025

by Hrushikesh Deshmukh

· 4,598 Views · 2 Likes

Why Mocking Sucks

Mocking can be risky as it doesn't replicate real-world conditions, making real development versions of services preferable.

March 28, 2025

by Andy Pai

· 4,741 Views · 2 Likes

Using Terraform Moved Block to Refactor Resources

Terraform moved block, introduced in version 1.1.0, provides a straightforward way to refactor resources by explicitly mapping old resource addresses to new ones.

March 28, 2025

by Mariusz Michalowski

· 4,648 Views · 1 Like

Building a Scalable ML Pipeline and API in AWS

This blog explains the architecture and design for building a scalable end-to-end ML pipeline using AWS for automated model execution, real-time data processing, and API.

March 28, 2025

by Dhanush Thirugnana

· 5,620 Views · 3 Likes

Moving PeopleSoft ERP Data Between Databases With Data Mover Scripts

Learn how to efficiently move application data between different PeopleSoft databases using Data Mover scripts, with detailed examples and step-by-step instructions.

March 27, 2025

by Tirumala Rao Chimpiri

· 4,579 Views · 1 Like

Automatic Versioning in Mobile Apps

This article presents an automatic versioning and migration framework for mobile app databases using schema hashes and seamless upgrades.

March 27, 2025

by Liewen Huang, Ph.D.

· 2,989 Views · 2 Likes

Optimized Metrics Generation With Metadata-Driven Dynamic SQL

Learn about a metadata-driven approach to generate metrics with dynamic SQL, enhancing scalability, flexibility, and efficiency in auditing and reporting.

March 27, 2025

by Tapan Parekh

· 2,917 Views · 1 Like

Avoid Cross-Shard Data Movement in Distributed Databases

Learn four effective strategies to optimize distributed joins, reduce network overhead, and improve query performance in sharded databases.

March 26, 2025

by Baskar Sikkayan

· 6,949 Views · 5 Likes

Jakarta NoSQL 1.0: A Way To Bring Java and NoSQL Together

Jakarta NoSQL 1.0 standardizes NoSQL integration in Java with familiar annotations, a fluent API, and support for multiple NoSQL types—boosting productivity, portability.

March 26, 2025

by Otavio Santana

CORE

· 9,543 Views · 6 Likes

The Latest Databases Topics