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.

Range queries can quietly slow down PostgreSQL as datasets grow. This guide helps you spot the root cause, compare query plans side by side, and speed things up with indexing improvements like GiST. Learn how Query Profiler helps compare query results and confirm real improvements when running PostgreSQL on AWS Aurora.

Moving from MySQL to PostgreSQL is common for teams planning long-term growth. But the work continues after the migration. DBAs still need to verify schemas, tune autovacuum, and monitor replication. This guide outlines a few practical checks to help keep PostgreSQL systems stable and consistent.

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.

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.

We are happy to announce the release of Review Assistant 4.3, introducing support for integration with Visual Studio 2026 and a more practical permissions model for viewing project reports.

Consecutive repeating URL segments require ordered comparison logic rather than pattern matching shortcuts. This guide demonstrates how to split URLs into arrays, preserve sequence with ordinality, and use LAG() to detect repeats in Trino SQL—delivering accurate results across large-scale datasets.

Not all SQLite ODBC drivers deliver the same level of reliability. This guide compares leading options in 2026, examining SQL support, cross-platform compatibility, and real-world performance so you can select a driver that works seamlessly with your reporting and analytics tools.

This guide shows how to scale a CLI query tool across multiple databases in a clear and practical way. It explains why SQL Server, MySQL, Oracle, and PostgreSQL should be your first focus, how to build reliable CLI automation, and when it makes sense to extend support to data warehouses like Redshift.

Boolean columns look harmless, until they force PostgreSQL to read half your table to answer a simple query. This guide shows how to stop the scan, design an index the optimizer will actually use, and restore fast performance even when your dataset grows into the millions.