In this series, Aisha is comparing the many different facets of these two open source, freely available RDBMS products.

Aisha Bukar in Databases

MySQL vs PostgreSQL: JSON Data Types

MySQL and PostgreSQL both support JSON, but they handle it in very different ways. This article compares their JSON data…

02 December 2025 22 min read 21

Aisha Bukar in MySQL

MySQL vs. PostgreSQL: Date and Time Data Types

Date and time data types are important because they help track and manage time-based information in databases. This includes things…

03 June 2025 21 min read 1

Aisha Bukar in MySQL

MySQL vs PostgreSQL – String Datatypes

A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents….

20 March 2025 22 min read 2

Aisha Bukar in MySQL

MySQL vs. PostgreSQL: Character Sets and Collations

When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared…

17 March 2025 18 min read

Aisha Bukar in Databases

MySQL vs PostgreSQL: Numeric Datatype Comparison

When you think of how to store data in a database, you think of data types. A data type represents…

15 November 2024 18 min read 2

Aisha Bukar in MySQL

MySQL vs PostgreSQL: Which Open-Source Database is right for you?

When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL…

12 August 2024 12 min read 31