Databases Resources

Solving PostgreSQL Indexes, Partitioning, and LockManager Limitations

Read this blog to learn how to avoid the scalability limitations of PostgreSQL's partition-based approach by leveraging automatic sharding and global indexing.

April 26, 2024

by Franck Pachot

· 1,229 Views · 1 Like

Auto-Increment Columns in Apache Doris

Auto-increment columns in Apache Doris accelerate dictionary encoding and pagination without damaging data writing performance.

April 26, 2024

by Shirley H.

· 1,040 Views · 1 Like

Understanding API Technologies: A Comparative Analysis of REST, GraphQL, and Asynchronous APIs

Learn about the advantages vs. disadvantages and ideal use cases for REST, GraphQL, and Async APIs in this concise guide.

Updated April 26, 2024

by Saurabh Dashora

CORE

· 5,732 Views · 7 Likes

Handling Vectors in AI Context via PostgreSQL pgVector

An introduction to PostgreSQL pgVector extension and its supported metrics — L2 squared distance (Euclidian), dot product, cosine distance/similarity.

April 25, 2024

by Horatiu Dan

· 1,047 Views · 1 Like

How To Integrate Weather Tracking Into Web Applications With PHP

To track weather using PHP, weather data from a reliable source is required. Several weather APIs are available that provide real-time and forecast weather information.

April 24, 2024

by Santosh Sahu

· 1,016 Views · 2 Likes

How To Build Generative AI Apps on AWS Using Anthropic Claude 3

Explore building generative AI applications using Anthropic Claude 3 on AWS. Discover cloud-based AI innovation and advanced techniques in our guide.

April 24, 2024

by Nisar Ahmad

· 1,608 Views · 3 Likes

HTTP API: Key Skills for Smooth Integration and Operation (Part 1)

In this article, I want to share my experience on how to work properly with HTTP APIs of third-party or internal services

April 24, 2024

by Filipp Shcherbanich

· 1,495 Views · 3 Likes

Debugging Terraform Like a Pro: Strategies for Efficient Infrastructure Management

Mastering debugging in Terraform by identifying and resolving issues in Terraform configurations, states, and workflows.

April 24, 2024

by Josephine Eskaline Joyce

CORE

· 1,910 Views · 4 Likes

How To Work Effectively With JDBC in Java Scripts

This article demonstrates how to streamline SQL queries in Java scripts using a single class, resulting in safer, more concise code with better readability.

April 23, 2024

by Pavel Ponec

· 1,814 Views · 4 Likes

PostGIS and Heroku Postgres: Location, Location, Location!

Learn how to get a PostGIS-enabled Postgres instance running on Heroku and run some sample queries on the database.

April 23, 2024

by Joseph Caudle

· 596 Views · 2 Likes

Leveraging AI to Bolster Cloud Security for APIs and Microservices

AI-powered cloud security solutions are essential for protecting APIs and microservices from online threats. Learn more about how AI improves cloud security.

April 23, 2024

by Nilesh Charankar

· 1,016 Views · 1 Like

Designing Developer-Friendly APIs and SDKs: Strategies for Platform Success

I place these four necessary strategies that should be at the heart of any API/SDK program: simplicity, resilience, community building, and continuous improvement.

April 23, 2024

by Ashwin Ganesh Krishnamurthy

· 2,997 Views · 3 Likes

An Introduction to Terraform's Core Concepts

In this article, learn about the core elements of Terraform and how they help you enhance collaboration and operational efficiency.

April 22, 2024

by Mariusz Michalowski

· 1,457 Views · 3 Likes

Microsoft Teams for Developers: Enhancing Communication With Call Initiating and Recording

Learn how Microsoft Teams empowers developers to create seamless communication with smart calling solutions, APIs, and third-party integrations.

April 22, 2024

by Arun Pandey

CORE

· 3,276 Views · 3 Likes

Scheduled Import of Excel Into Database

In this article, learn more about how to achieve a scheduled import and full automation from Microsoft Excel to a database.

April 22, 2024

by ryjfgjl xb

· 542 Views · 1 Like

FastAPI Got Me an OpenAPI Spec Really... Fast

When API First isn’t an option, FastAPI can save teams time by allowing existing RESTful microservices to be fully documented and consumed using OpenAPI v3 automatically.

April 22, 2024

by John Vester

CORE

· 41,034 Views · 4 Likes

Amazon Bedrock: Leveraging Foundation Models With Quarkus and AWS

Bedrock is the new Amazon service that democratizes the users' access to the most up-to-date Foundation Models (FM) of the highest-ranked AI actors.

April 22, 2024

by Nicolas Duminil

CORE

· 1,312 Views · 1 Like

Unlocking the Power of Static Pods in Kubernetes: A Beginner’s Guide

Unlock the potential of static pods in Kubernetes with this beginner-friendly guide, offering insights into deployment and management.

April 19, 2024

by Rajesh Gheware

· 1,575 Views · 1 Like

How to Really Build a GraphQL Server With Java

This tutorial aims to demonstrate the process of building a GraphQL server utilizing the venerable graphql-java library in Java.

April 18, 2024

by David Ventimiglia

· 2,674 Views · 5 Likes

Strategic Insights Into Azure DevOps: Balancing Advantages and Challenges

Here, find an introduction to the components of Azure DevOps and a balanced perspective by delving into the advantages and potential drawbacks of adopting it.

April 18, 2024

by Harshavardhan Nerella

· 4,585 Views · 3 Likes

The Latest Databases Topics