#Postgresql
2 notas · última:
Life Altering PostgreSQL Patterns
The post collects PostgreSQL patterns that reduce operational pain: UUID keys, timestamps, restrictive foreign keys, schemas, enum tables, soft deletes, status logs, special rows, careful use of views, and JSON queries.
Why and How Marten is a Great Document Database
The post shows how Marten stores and loads C# objects as JSON in PostgreSQL, creates missing database objects on demand, and fits the .NET host model while keeping ACID transactions and rich document features.