WebSockets.

Using role claims to target WebSockets

This article explains a (fairly) simple solution on how you can grab role claims – or any other claims with some tweaking – and use them as the basis for targeting your WebSocket messages. Very nifty, if you ask me, without all the enterprisiness of SignalR. Talking about SignalR, another way to implement pretty much the same thing, but with all of the enterprisey goodness of SignalR, is described in this blog post: How to access claims of a SignalR user in ASP.NET Core? That…Continue reading Using role claims to target WebSockets

Everything is broken (a delicious lego meme)

The simplest fixes to “500 (Internal Server Error)” from Azurite

This quick blog post explains a couple of very simple fixes – essentially, user errors – to a simple problem that you might run into with Visual Studio when developing the latest of your cool Azure bits. Well, to be fair, a few simple fixes and one heavyweight. A final ditch effort to learn to live with Azurite. But we’ll get to it. So, let’s embark on a journey, to try and make some sense of the whole Azure Storage emulating/exploring a side of things…Continue reading The simplest fixes to “500 (Internal Server Error)” from Azurite

SOLVE ALL THE ERRORS!

How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Have you run into this puzzling error? It comes in a couple of flavors, but it boils down to you failing miserably when you run the create_hypertable() function on your PostgreSQL TimescaleDB database server! Annoyingly, it might mean that the whole function is missing (extension is not installed or loaded) or that your parameters are not properly parsed (an issue with your command). I know, that it sucks. I have been there. That’s why I wrote this article! Problem You’re trying to transform your PostgreSQL…Continue reading How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

PostgreSQL everywhere

How to configure Azure PostgreSQL to allow Cloud Shell connections?

I was setting up a PostgreSQL database in Azure, to be used by a cutesy little Azure Function storing telemetry from a bunch of Azure IoT Edge Devices. But when everything was (supposed to be) configured successfully, my Azure Function failed to store anything anywhere because of a missing database… Oh, right. Entity Framework can’t create PostgreSQL databases, as the connection is made to an existing database – so it can’t be instantiated if the database doesn’t exist on the server already. So, what do…Continue reading How to configure Azure PostgreSQL to allow Cloud Shell connections?