postgresql - DBConvert blog

Sign in Subscribe

postgresql

A collection of 10 posts

DBConvert Products Now Support Firebird 4!

DBConvert Products Now Support Firebird 4!

We are excited to announce that DBConvert now supports Firebird 4! Enjoy enhanced multithreading, improved SQL syntax, and advanced security features. Seamlessly migrate and synchronize between Firebird 4 and popular databases like Access, SQL Server, MySQL, and PostgreSQL. Upgrade today!

How to Migrate from Oracle to PostgreSQL

How to Migrate from Oracle to PostgreSQL

Here is described a case of migration from Oracle server to PostgreSQL server for large supplier of goods. This article covers each stage of migration, potential issues, and ways to solve them. In most cases, companies switch from Oracle to PostgreSQL to reduce costs. Oracle licenses are paid and quite

MySQL and PostgreSQL for Advanced Full-Text Search.

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 vs Postgres in 2024.

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.

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

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.

Data Synchronization Made Easy: A Step-by-Step Guide for Oracle and PostgreSQL sync.

database synchronization

Data Synchronization Made Easy: A Step-by-Step Guide for Oracle and PostgreSQL sync.

Learn how to synchronize data between Oracle and PostgreSQL databases effectively. Understand the synchronization strategy, perform initial data copy, and implement synchronization mechanisms.

MySQL vs PostgreSQL in 2023.

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.

Streaming data from MySQL to Postgres.

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.

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

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.

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

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.