Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL

In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. While the reasons to use nullable or non-nullable columns may seem obvious at first, there are pitfalls associated with each decision that either affect development velocity, affect application performance, or cause downtime. Let's start with definitions. Nullable […]
The post Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL appeared first on SQLServerCentral.

Introducing the MySQL common table expression

As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation language (DML) statement. You can join multiple tables in a single query or add subqueries that pull data in from other tables.
The post Introducing the MySQL common table expression appeared first on SQLServerCentral.

Dealing with Mutually Dependent Databases in Flyway

How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS.
The post Dealing with Mutually Dependent Databases in Flyway appeared first on SQLServerCentral.
© 2025 Hometown Computer Services
Site Powered By WordPress