Operations | Monitoring | ITSM | DevOps | Cloud

New Release of Delphi Data Access Components Adds Support for Latest IDEs, Databases, and Windows Arm64EC Target Platform

We are thrilled to announce a new release of our Delphi Data Access Components product line. This update delivers broader platform compatibility, enhanced security, and extended support for modern database technologies across multiple providers.

Migrating from MySQL to PostgreSQL: Performance and Replication Best Practices

Summary: Today, many teams are moving from MySQL to PostgreSQL as they update their database systems and plan for future growth. However, too often, there is extra work after the migration: for example checking that tables and constraints were copied correctly, tuning performance, and confirming that replication works properly. Devart’s PostgreSQL tools help DBAs with these tasks through features like Schema Compare, Data Compare, and other tools that help review and manage PostgreSQL databases.

High-Performance Range Queries in PostgreSQL: Overcoming Bottlenecks in AWS Aurora

Short Summary: PostgreSQL can slow down when range queries and frequent data updates rely on the same indexes. This guide shows how to spot the problem and use Devart tools to reduce B-Tree index conflicts, improve query plans, and manage bi-weekly data updates in AWS Aurora.

dotConnect for Zoho CRM | Connect Zoho CRM to .NET Apps Easily

Bring Zoho CRM data into your.NET applications with dotConnect for Zoho CRM—a fast, reliable ADO.NET provider built for secure and efficient connectivity. Set up in minutes using a Windows installer or NuGet, then explore and manage your CRM data from Visual Studio. This video walks you through connecting via Server Explorer, authenticating with Interactive OAuth, running queries through standard ADO.NET workflows, and integrating with popular ORMs like EF Core and Dapper.

New dotConnect and Entity Developer Release: EF Core 10, AI Vector Types, and Expanded Database Compatibility

We are thrilled to announce a set of product updates across our dotConnect data providers and Entity Developer. The new release adds support for Entity Framework Core 10, introduces AI-focused vector data types across major databases, and extends compatibility with the newest platform capabilities such as SQL Server 2025, Oracle 26ai, and Microsoft Entra authentication.

Code Compare 5.5 R1 Adds Integration Support for Visual Studio 2026

We’re excited to share Code Compare 5.5 R1, the latest update to our code comparison and merge tool. This release adds integration support for Visual Studio 2026, so teams can compare changes and resolve merge conflicts directly within the IDE workflow they already use. With Code Compare 5.5 R1, developers can review differences, apply merges, and handle conflicts in Visual Studio 2026 using the same comparison experience they rely on across projects and repositories.

Counting Consecutive Repeating Segments in URL Strings via Trino SQL

Short Summary: Sometimes URL paths repeat by mistake because of tracking problems or redirect loops.. In this guide, you’ll learn how to find and count those repeats using Trino SQL. By using simple SQL tools like CTEs, arrays, and window functions, you can break a long link into smaller pieces and clean up the data without using complex regex.

Optimizing PostgreSQL Performance for Large Tables with Boolean Filters

Short Summary: In this guide, we address performance problems that occur when PostgreSQL queries very large tables containing low-cardinality boolean fields. It also demonstrates how composite indexes, created and tested with Devart tools, allow PostgreSQL to locate the required rows directly instead of scanning the entire table.

Scaling Your CLI Query Tool: Prioritizing Database Support for Maximum Impact

Short Summary: This article explains how to expand your CLI query tool so it can handle multiple databases. First, we focus on key relational systems, then move to data warehouses. We’ll use dbForge Edge as a reference point, showing how different databases can be managed in one place while keeping automation simple.