Databases Resources

Mastering the Art of Data Engineering to Support Billion-Dollar Tech Ecosystems

This article discusses managing the continuously increasing data footprint and efficient ways of data processing using a Massive Parallel Processing database.

September 20, 2024

by Ashish Karalkar

· 5,080 Views · 2 Likes

Open Source .NET Aspire and Dapr: What Are They and How Do They Complement Each Other For Distributed Apps?

This article covers both .NET Aspire and Dapr, the problems they solve, their differences, and why .NET developers should use them together.

September 20, 2024

by Marc Duiker

· 3,837 Views · 3 Likes

Battle of the RabbitMQ Queues: Performance Insights on Classic and Quorum

When deciding between RabbitMQ’s Classic and Quorum queues, it’s important to recognize that both have their strengths and weaknesses. Learn more here.

September 19, 2024

by Josephine Eskaline Joyce

CORE

· 11,098 Views · 8 Likes

Optimizing Cost and Carbon Footprint With Smart Scaling Using SQS Queue Triggers: Part 1

Dynamic scaling with Amazon SQS and AWS Auto Scaling optimizes costs and energy use, enhancing sustainability and efficiency in cloud environments.

September 18, 2024

by Varun Dixit

· 51,176 Views · 2 Likes

Troubleshooting PostgreSQL Low Free Memory

Gain an understanding of how databases (specifically PostgreSQL) manage memory and how to troubleshoot low free-memory scenarios.

September 17, 2024

by Adam Furmanek

CORE

· 5,444 Views · 7 Likes

Database Keys: A Comprehensive Guide

Database keys are crucial for organizing and retrieving data efficiently. This guide provides a quick rundown of the main types.

September 17, 2024

by Brij kishore Pandey

· 4,073 Views · 1 Like

Commonly Occurring Errors in Microsoft Graph Integrations and How To Troubleshoot Them (Part 6)

Explore an example to change a column value for a list item of a “user-defined” SharePoint list using a DriveItem, which also represents the PDF file.

September 16, 2024

by Constantin Kwiatkowski

· 3,516 Views · 1 Like

Low-Level Optimizations in ClickHouse: Utilizing Branch Prediction and SIMD To Speed Up Query Execution

ClickHouse accelerates queries using SIMD and optimizes block processing. It picks the best function implementation, boosting performance on AVX2 processors.

September 16, 2024

by Taras Baranyuk

CORE

· 4,576 Views · 3 Likes

The Ultimate Database Scaling Cheatsheet: Strategies for Optimizing Performance and Scalability

Enhance performance and scalability using database scaling strategies like indexing, vertical scaling, sharding, denormalization, caching, and replication.

September 16, 2024

by Suleiman Dibirov

CORE

· 8,167 Views · 8 Likes

Leveling Up My GraphQL Skills: Real-Time Subscriptions

Dive a little deeper to explore real-time data subscriptions by using GraphQL to automatically receive server-side updates with help from a WebSocket consumer.

September 16, 2024

by John Vester

CORE

· 59,459 Views · 2 Likes

How to Merge Excel XLSX Files in Java

This article discusses programmatically merging XLSX files into a single document as well as open-source and web API solutions for automating this workflow.

September 16, 2024

by Brian O'Neill

CORE

· 6,550 Views · 2 Likes

Zero to AI Hero, Part 3: Unleashing the Power of Agents in Semantic Kernel

This article will guide you through building agents with Semantic Kernel, focusing on the key components and offering practical examples.

September 16, 2024

by Aneesh Gopalakrishnan

· 6,633 Views · 1 Like

Releasing MuleSoft API

In this tutorial, learn how to set up MuleSoft environment-related deployment folders and tag the release version with custom-generated tags.

September 13, 2024

by Ash singh

· 4,485 Views · 4 Likes

Setting Up Secure Data Lakes for Starlight Financial: A Guide to AWS Implementation

This guide delves into securing financial data lakes with AWS services, focusing on best practices for data protection and compliance.

September 13, 2024

by Harsh Daiya

CORE

· 4,981 Views · 1 Like

Understanding the Purposes of Key Terraform Files and How to Structure Their Folders

Understand the role and function of critical Terraform files and structure their folders to optimize the efficiency and scalability of your cloud resources.

September 12, 2024

by Ryan Kh

· 5,412 Views · 1 Like

How to Build an OpenAI Custom GPT With a Third-Party API

This tutorial demonstrates how to build a conversational user interface with OpenAI's Custom GPT using any third-party API.

September 12, 2024

by Akhilesh Joshi

· 5,041 Views · 2 Likes

10 Things to Avoid in Domain-Driven Design (DDD)

DDD is an important strategic approach to software development. In this article, explore 10 things to avoid in DDD and examples to illustrate these pitfalls.

September 12, 2024

by Reza Ganji

CORE

· 12,600 Views · 13 Likes

8 Practices Software Engineers Should Adopt and Champion for Cybersecurity

Surprisingly, cybersecurity could be as simple as following best practices, which ideally should be integrated into the culture itself. Learn more in this post.

September 11, 2024

by Manish Sinha

· 5,147 Views · 3 Likes

Automatic 1111: Custom Sketch-to-Image API

Develop a custom Sketch-to-Image API for converting hand-drawn/digital sketches into photorealistic images using stable diffusion models powered by ControlNet.

September 10, 2024

by Tharakarama Reddy Yernapalli Sreenivasulu

· 4,071 Views · 3 Likes

Exploring Real-Time Data Ingestion Into Snowflake Using CockroachDB, Redpanda, and Kafka Connect

Explore Kafka Connect as a solution to stream changefeeds into Snowflake for greater control over how messages are delivered to Snowflake.

September 10, 2024

by Artem Ervits

CORE

· 5,451 Views · 1 Like

The Latest Databases Topics