Posts from August 2021

Blog posts published in August 2021

← Back to all posts

Posts from August 2021 (6)

Published on

2021-08-31 6:44 p.m.
Authors

koskila
Tags

git vscode

Visual Studio Code fails when running "git pull" for a new project

This article describes a simple fix to an issue (well... One or many possible issues), where git fails to pull anything from remote, throwing instead an error somewhat like this: fatal: no such branch: 'master' Bah. This stops you from pulling any new changes from remote, and likewise, it will stop you from pushing your new stuff out there. Always something going wrong with git, right? But what is the reason this time exactly? Problem So there I was, just following a guide on docs.microsoft.com.

Read more →
Published on

2021-08-24 4:11 a.m.
Authors

koskila
Tags

ms-sql-server sql sql-query

How to form a parameterized SQL query to find duplicates in a table.

So one day, I needed to quickly check if an identity field in a view in a Microsoft SQL Server was actually unique or not. I was running into weird issues with Entity Framework throwing an error somewhat like this: Store update, insert, or delete statement affected an unexpected number of rows (2) Or somewhat like this: Type: DbUpdateConcurrencyExceptionStore update, insert, or delete statement affected an unexpected number of rows ([row count]).

Read more →
Published on

2021-08-17 4:25 a.m.
Authors

koskila
Tags

aspnetcore json netcore

How to serialize to JSON in camelCase using .NET Core?

This article describes how to configure your .NET Core application to serialize objects in camelCase instead of PascalCase. I guess this is another quick note - something that should be simple, but I couldn't remember how to do it from the top of my head, and the solution turned out to be a bit unintuitive. I guess that makes it worth documenting because I'll definitely run into this again. Anyway - let's take a closer look at the actual issue at hand, shall we?

Read more →
Published on

2021-08-12 4:29 a.m.
Authors

koskila
Tags

homeassistant lovelace

Home Assistant - Quick and dirty fixes

This article documents the quick and dirty fixes and patches that I have found for Home Assistant. I'm trying to document all the things that are not complicated enough to warrant an actual blog post themselves somewhere, and this page is as good a place as any. Hopefully, these tips end up being helpful to someone else as well!

Read more →
Published on

2021-08-10 3:58 a.m.
Authors

koskila
Tags

asp-net dotnet websockets

How to secure your WebSocket connection using .NET Core?

This article explains how to easily authenticate your WebSocket connections using .NET Core and vanilla JavaScript. The same concept probably applies to all sorts of front-end libraries, although some of them might offer some syntactic sugar on top of it. But it's simple, and keeping your implementation simple is generally speaking a good idea. So - this one came up when developing a simple API that'd expose a WebSocket endpoint for seamless notifications to the Web UI.

Read more →
Published on

2021-08-05 2:07 a.m.
Authors

koskila
Tags

climacell homeassistant

No way to renew a ClimaCell API subscription - what to do?

One day I suddenly realized that my Home Assistant's ClimaCell integration had stopped working. That was weird - it had been running just fine for a while. I had signed up for a ClimaCell developer account at developer.tomorrow.io (or whatever the address was before rebranding from ClimaCell to Tomorrow.io - but this is the portal that I used) on the 28th of July, perhaps in 2020, or perhaps 2019. And it had worked brilliantly so far, but suddenly and without warning, it just stopped working.

Read more →