Databases Resources

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,557 Views · 3 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,796 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

· 5,765 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,900 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

· 5,248 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

· 10,335 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

· 60,457 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

· 7,632 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

· 8,615 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

· 5,268 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

· 5,693 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

· 6,066 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

· 7,171 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

· 15,100 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

· 6,022 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

· 5,374 Views · 6 Likes