Tag: databases
All the articles with the tag "databases".
-
Standardize Data at Write Time, Not Read Time
Why I normalize data from multiple sources when saving to the database, not when displaying it. Using IoT temperature monitoring as a practical example.
-
EF Core Migrations Quick Reference
A comprehensive quick reference guide for managing Entity Framework Core migrations, including common commands and best practices for database schema updates.
-
PostgreSQL Query and Command Snippets
A practical collection of PostgreSQL queries and commands for common database administration tasks, performance tuning, and maintenance operations.
-
PostgreSQL development setup with Docker Compose
A step-by-step guide to setting up a PostgreSQL development environment using Docker Compose, including configuration, persistence, and common troubleshooting tips.
-
Dynamic SQL queries: string concatenation vs SqlKata
A comparison of approaches to building dynamic SQL queries in .NET applications, contrasting string concatenation with SqlKata's query builder for safer and more maintainable code.
-
.NET Database Development with FluentMigrator (Archive, 2014)
A comprehensive guide on implementing database versioning with FluentMigrator in .NET projects, including automated migrations, version control integration, and cross-database provider support.