SQL databases, which have traditionally been relational, have evolved to support document-based workloads. This session will explore using SQL and JSON data types as a document database. We will explore using JSON SQL functions directly and tools like FerretDB and Pongo, which provide a MongoDB API on top of PostgreSQL-compatible databases. Additionally, we will discuss indexing strategies for JSON and when storing attributes as relational columns is advantageous. We will demonstrate examples using open-source databases such as PostgreSQL and YugabyteDB.

Developers are debating whether to continue using MongoDB or migrating more use cases to PostgreSQL as SQL databases regain popularity and can now store documents. This session provides insights on how to effectively consider the transition.