PostgreSQL is the best database for Aspire

[Kralizek]

Maybe it's me, but I get to use Aspire with MSSQL, PostgreSQL and even CosmosDB, and PostgreSQL is the one working the best.

Maybe because its container is super fast, but I never have an issue of the database not being ready when the backend starts.

The CosmosDB emulator takes forever to start so if you want EF to run an "EnsureCreated" block in your Program.cs, it will always fail.

The MSSQL one is not as slow, but slow enough that even the WaitFor extension from the Aspirant package fails every now and then.

Yesterday I was working on a PoC for some work. I wanted to use CosmosDB but I was getting problems on starting everything up. Eventually I gave up and switched to the PostgreSQL component to get some real work done.

I know this post might seem like a rant (and partially it is) but I hope Microsoft does something to improve the startup time of its containers because its not even funny how slow they are.