Home » PostgreSQL
Okay, that’s a title and a half. But let’s see – what are we actually doing and why? In my particular case, I had to store a Dictionary<string, string> in a Postgres database. By default, that’s not something Entity Framework handles. But as usual, there’s a way around that – and the same concept we’ll take a look at below should work for other complex data types or objects too!…Continue reading How to store a complex object as JSON in a PostgreSQL database using Entity Framework (Npgsql)?
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…Continue reading How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?
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…Continue reading How to configure Azure PostgreSQL to allow Cloud Shell connections?
This article will explain how to run your arbitrary SQL commands against a Postgre SQL database running in a Docker container in Windows. That should be super simple, but since I never remember anything like this by heart, I had to google it – and turns out, either I didn’t know how to google this properly or people haven’t bothered to document this. So, let’s fix that. But first, why…Continue reading How to run SQL commands in a Postgre SQL Docker container?