Databases
4 articles
Repositories and Unit of Work Don't MixThere is a trend in the .NET space of trying to abstract EF behind a Repository. This is a fundamentally bad idea and hopefully I'll explain why.
Virtual, Computed Columns in PostgreSQL 12PostgreSQL 12 introduced a feature I've long wished for: computed columns that are indexable and stored on disk! They're amazing and in this post I'll show you how they work and how things kind of go...
Simple Monthly Reports in PostgreSQLWorking with dates and series of dates is easy in PostgreSQL, especially using generate_series
It's Time To Get Over That Stored Procedure Aversion You HaveThere is a lot of opinion about stored procedures out there that are just...



