Category: Database
-
PostgreSQL Database Upgrade Guide for Docker Environments
A comprehensive guide for safely upgrading PostgreSQL databases in containerized environments Overview This guide covers the essential principles and steps for upgrading PostgreSQL databases in Docker environments. The…
-
-
Understanding JWT Token Transformation: Bridging OAuth2 and PostgREST
TLDR: Here is the github repo to pull and try (you will need your own oauth2 provider like google etc) https://github.com/jcianci12/Client-Server-postgrest-jwt-demo 🍒 In modern web applications, authentication and…
-
Understanding JWT Authentication with PostgREST
TLDR: Here is the example you can spin up in docker to test: https://github.com/jcianci12/jwt-postgrest-example Introduction PostgREST is a powerful tool that automatically creates RESTful APIs from PostgreSQL databases.…
-
Setting environment variables for postgres running in docker
When running PostgreSQL in Docker, setting environment variables correctly is crucial, especially for sensitive data like API keys. After extensive testing, here’s the solution that worked for us:…
-
Real-World Use Case: Tracking the Most Recent Changes in Customer Data
Scenario Imagine you are working for a company that needs to track changes in customer information over time. The company has a table named CustomerAudit that logs every change made…
-
-
Resolving EF Migration Errors with a Separate Database Project
As developers, we’ve all been there – stuck on a seemingly insurmountable error, with no clear solution in sight. Recently, I encountered an issue while trying to run…
-
[Solved] Entity framework – Violation of PRIMARY KEY constraint ‘…’. Cannot insert duplicate key in object ‘dbo…’ the duplicate key value is (…). The statement has been terminated.
If you are struggling to create a new record in a sql db when using entity framework and you are ending up with an error that looks like…