How to fix a sequence when it goes out of sync in Postgres
Let's learn how to identify and then fix the out-of-sync issue leading to the "duplicate key value violates unique constraint" message error that occurs with PostgreSQL sequences.
Querying GitHub data with SQL: Insights for developers and engineering leaders
In this article, we'll learn about using a tool called MergeStat to query and gain insights from a GitHub repo.
Building two-factor authentication with NestJS and Postgres
Adding an extra layer of security via two-factor authentication can help keep customer data secure from malicious activity. Let's see how to set up 2FA with NestJS.