Dmitry Narizhnykh

full-text search

MySQL and PostgreSQL for Advanced Full-Text Search.

This article introduces the advantages of full-text search, focusing on MySQL and PostgreSQL. It details the features, indexing, and search approaches. How to handle PostgreSQL BTree index row size errors.

mysql

MySQL vs Postgres in 2024.

The rise of PostgreSQL and MySQL is fueled by cloud adoption, boosting deployment ease. PostgreSQL dominates in 2023, yet MySQL still appeals to learners. In 2024, PostgreSQL aims to improve sharding, logical replication, while MySQL focuses on availability, security, and analytics.

aws

Aurora vs. RDS: How to Choose the Right AWS Database for 2024

Comparing Amazon Aurora and RDS, AWS's fully managed relational database services. Highlighting key differences, Aurora is cloud-native with serverless support, while RDS offers superior customization and supports more database engines.

dbconvert streams

Mitigating NATS Errors and Optimizing Data Transfer in DBConvert Streams.

Managing data flow in distributed systems can be complex. This article explores common NATS errors in DBConvert Streams, their origins, and practical solutions, emphasizing the role of the dataBundleSize parameter in preventing these errors.

dbconvert streams Featured

What Is a Streaming Database?

Streaming databases are the superheroes in data management that handle constant data updates and provide real-time information for various applications.

database migration Featured

Your Roadmap to Database Conversion Excellence.

This guide explores the importance of database migration for adapting to evolving application needs and highlights key considerations and benefits, including improved performance and cost savings through open-source solutions.

access

Microsoft Access: Unveiling the Dual Power of Database and Front-End Development

Microsoft Access combines database management and front-end development, empowering developers. It offers a user-friendly interface, integrates with Office applications, and supports external data sources. DBConvert enhances Access with data migration and synchronization capabilities.

sql server

Simplifying Data Migration: Converting DBF to SQL Server.

Introduction. In the ever-evolving world of data management, businesses often face the challenge of migrating their data from legacy systems to more modern and scalable platforms. One such migration scenario involves converting DBF to SQL Server, commonly associated with dBase, XBase, Clipper, FoxBase and FoxPro databases. This article explores the

Change Data Capture

Change Data Capture vs Database Conversion: Use Cases and Key Differences.

Introduction: Change Data Capture (CDC) and database conversion are different data management and data migration approaches. Each method serves specific purposes and provides unique benefits. This article aims to explore the use cases and highlight the key differences between these approaches, as well as provide insight into when to choose

aws

Deploying DBConvert Streams on Amazon Web Services: A Step-by-Step Guide.

This article will guide you through the steps to deploy DBConvert Streams on the Amazon Web Services (AWS) infrastructure. The example demonstrates how to set up DBS to stream data from an Amazon RDS for MySQL Binlog, using Change Data Capture (CDC), to an Amazon RDS for PostgreSQL database.

dbconvert streams

Debezium vs DBConvert Streams: Which Offers Superior Performance in Data Streaming?

In contemporary application design that utilizes microservices and keeps up with dynamic analytics demands, it's common to synchronize data from various databases dispersed throughout an enterprise and integrated with diverse systems. In modern applications, real-time syncing of databases is often necessary, so the synchronization cannot wait for a batch job

postgresql

MySQL vs PostgreSQL in 2023.

PostgreSQL and MySQL are reliable, secure, and scalable databases that have been around for years. Each has unique strengths and weaknesses, making one more suitable for specific needs. This article will compare them to aid in making an informed decision in 2023.

dbconvert streams Featured

Streaming data from MySQL to Postgres.

DBConvert Streams replicates your MySQL data to PostgreSQL in real-time. It captures any changes made to your source MySQL database and immediately applies them to the target PostgreSQL database. Here is a comprehensive guide on how to stream data from MySQL to Postgres.

dbconvert streams

DBConvert Streams v0.5.0 released.

We are pleased to announce the first public release of DBConvert Streams v0.5.0. DBConvert Streams (DBS) is a new event-driven data replication platform for database administrators who require zero downtime database migration and continuous data replication as workloads move to the clouds and more data needs to be

dbconvert streams Featured

Event Driven real-time Replication between MySQL and PostgreSQL.

DBConvert Streams is our new "cloud-first" distributed platform. Benchmark test proves that it takes about 12 seconds to replicate 1 million records between the source and destination database.

parallel migration

DBConvert Studio 3.0 released. Incredible conversion speed!

New parallel migration engine of DBConvert Studio speeds up data migration between the most popular databases and clouds by splitting database tables into multiple parts and processing them in parallel.

Change Data Capture Featured

PostgreSQL Change data capture (CDC) + golang sample code.

PostgreSQL offers Logical Decoding Method to make log-based change data capture possible. Setup and run CDC in several steps.

JSON Featured

JSON Lines format: Why jsonl is what you need for data streams?

JSON Lines is appealing format for data streaming. Since every new line means a separate entry makes the JSON Lines formatted file streamable.

stream processing

Data stream processing.

What is Data Stream processing? Collect, process and extract real value from data sources in real-time . Deliver data much faster than ever before.

Change Data Capture

Change Data Capture (CDC): What it is and How it Works?

Change Data Capture (CDC) captures incremental changes in the original database so that they can be propagated to other databases or applications in near real-time.

database synchronization

Trigger-based database synchronization

Trigger-based database synchronization reflects changes from one database to another in distributed heterogeneous database environments.

database synchronization

Bidirectional Database synchronization

DBSync database synchronization tools support bi-directional synchronization and keep data up-to-date between different databases. This article demonstrates how the bi-directional sync pattern works.

database synchronization

What is Database Synchronization?

This article illustrated different database synchronization types.

sql server

Migrate data from SQL Server to PostgreSQL. Open source tools vs. DBConvert.

In this article, we will compare several ways of converting from SQL Server to PostgreSQL.

docker

How to build docker images for Windows desktop applications.

This article describes how to create docker images for Windows desktop applications.