Databases Resources

Curating Efficient Distributed Application Runtime (Dapr) Workflows

With Dapr and its powerful abstractions, writing resilient workflows is easy. In this article, we will understand how to write one with an example.

October 4, 2024

by Siri Varma Vegiraju

CORE

· 6,444 Views · 4 Likes

Enhanced API Security: Fine-Grained Access Control Using OPA and Kong Gateway

Kong secures APIs and OPA handles policy decisions. This custom plugin caches user data, minimizing database checks and ensuring fast, accurate access control.

October 4, 2024

by Amrutha Paladugu

· 4,893 Views · 4 Likes

How to Create a Search Engine and Algorithm With ClickHouse and Snowflake

Explore a step-by-step guide to developing a search engine and algorithm using Clickhouse, an open-source data warehousing solution.

October 3, 2024

by Akash Mukherjee

· 3,682 Views · 2 Likes

Implementing Polling With RxJS

Learn how to implement polling with RxJS for efficient, repetitive API calls, and optimize performance with exponential backoff and advanced RxJS operators.

October 3, 2024

by Aliaksandr Mirankou

· 5,872 Views · 1 Like

Why Doesn't Postgres Use My Index?

It may happen that we create an index, but PostgreSQL doesn’t use it. What could be the reason, and how can we fix it?

October 3, 2024

by Adam Furmanek

CORE

· 4,269 Views · 7 Likes

A Comprehensive Guide to Database Sharding: Building Scalable Systems

Explore an in-depth guide to database sharding: what it is, its types, how to select shard keys, and route queries for building scalable systems.

October 2, 2024

by Suleiman Dibirov

CORE

· 6,415 Views · 8 Likes

AWS LetsEncrypt Lambda or Why I Wrote a Custom TLS Provider for AWS Using OpenTofu and Go

LetsEncrypt Lambda helps to manage TLS certificates. Compared to Certificate Manager it provides certs that can be used at non-only AWS services like EC2 Nginx.

October 2, 2024

by Alexander Sharov

· 6,631 Views · 2 Likes

Misconfiguration Madness: Thwarting Common Vulnerabilities in the Financial Sector

Financial services are among the most attacked sectors of any industry, making it critical that developers operate at the highest level to produce secure code.

October 2, 2024

by Matias Madou

· 3,515 Views · 1 Like

Workarounds for Oracle Restrictions on the Size of Expression Lists

Learn five strategies to workaround ORA-01795 and ORA-00913 errors and explore a comparative analysis of their performance.

October 1, 2024

by Thiago Nascimento

CORE

· 6,038 Views · 2 Likes

Best Practices for Market Data Replay

Based on DolphinDB’s streaming replay, distributed database architecture, and APIs, you can create a tool for historical insight and model back-testing.

October 1, 2024

by Davis Zhou

· 2,850 Views · 1 Like

Using AWS WAF Efficiently to Secure Your CDN, Load Balancers, and API Servers

When securing your cloud architecture, performance and efficiency are incredibly important. Learn more about how to strike a fine balance.

October 1, 2024

by Manish Sinha

· 4,684 Views · 2 Likes

What Is Lambda Architecture? Ultimate Guide to Getting Started

Discover the basics of lambda architecture in our comprehensive guide. Explore its components, workflow, applications, and best practices.

Updated October 1, 2024

by Michael Bogan

CORE

· 14,673 Views · 11 Likes

Azure Deployment Using FileZilla

In this step-by-step guide, focus on the FileZilla FTP client as a means to publish your Angular UI application to Azure.

October 1, 2024

by ABUFAIZUR RAHMAN R ALI

· 3,932 Views · 1 Like

5 Best Practices for Data Warehousing

Getting started in data warehousing is a major undertaking, so it's important to consider a few best practices before beginning.

Updated October 1, 2024

by Zac Amos

· 6,537 Views · 2 Likes

Geo-Location Redirects With AWS CloudFront

This article explores how to set up geo-location-based redirection with AWS CloudFront and provides a comprehensive guide to using it effectively.

September 30, 2024

by Alexander Sharov

· 3,297 Views · 4 Likes

Stream Processing in the Serverless World

Learn how real-time data processing enables businesses to gain actionable insights without the overhead of managing infrastructure.

September 30, 2024

by Rajesh Pandey

· 3,957 Views · 2 Likes

Using AI in Your IDE To Work With Open-Source Code Bases

In this article, learn how we can add enhancements to the langchaingo project with Amazon Q Developer support in VS Code.

September 28, 2024

by Abhishek Gupta

CORE

· 3,408 Views · 2 Likes

Leveraging IBM WatsonX Data With Milvus to Build an Intelligent Slack Bot for Knowledge Retrieval

This tutorial covers populating the database with IBM WatsonX Data or open-source Milvus and connecting the bot to Slack to answer queries in real-time.

September 27, 2024

by Pradeep Gopalgowda

· 3,868 Views · 4 Likes

Indexes Under the Hood

One of the most obvious improvements for databases is to use indexes. Let's see them in detail to understand how they work in PostgreSQL and what makes them useful.

September 27, 2024

by Adam Furmanek

CORE

· 4,394 Views · 8 Likes

Low-Code AI Agent for Classifying User Support Tickets With OpenAI and Kumologica

This article discusses the design and implementation of an intelligent case classification scenario using an AI agent in Kumologica and the OpenAI platform.

September 27, 2024

by Pranav K

CORE

· 2,970 Views · 2 Likes

The Latest Databases Topics