The database layer is one of the most exciting areas in tech today. Yet, it is often overlooked. A number of companies are innovating in this space, including Cockroach Labs, MongoDB, Redis and TiDB.

One of the most anticipated new features in PostgreSQL 17 is native support for incremental backups. Previously, you had to use third-party programs for this; now, it's baked into the server. This ...

The PostgreSQL Global Development Group has officially released Postgres 17, marking another milestone for the community, developers, and EDB, the leading contributor to PostgreSQL code. As the ...

In this post, we will see how to install PostgreSQL on your Windows client computer and how you can connect and use it. PostgreSQL, commonly called Postgres, is an open-source relational database ...

On some of the models we have we have created an unique index. By default the creation of an unique index (on multiple columns) on Postgres was done with ignoring NULL values as unique values. See ...

PostgreSQL continues to improve in ways that meet the needs of even the most complex, mission-critical use cases. It also presents certain challenges. The database market continues to be splintered ...

I noticed that when calling Repository.count(findOptions) the default SQL query generated by Typeorm is a SELECT(COUNT(DISTINCT ...)) query when using Postgres. Postgres has some issues with counts ...