The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for April, 2020

Zelfbouw verlichting aansturen via Hue – Duurzame Energie & Domotica – GoT

Posted by jpluimers on 2020/04/16

On my research list: [WayBack] Zelfbouw verlichting aansturen via Hue – Duurzame Energie & Domotica – GoT.

via: [WayBack] Tweakers: Ikea komt met leddriver om geïntegreerde verlichting ‘slim’ te maken

–jeroen

 

PS: Lampen van de Action werken ook prima via Tuya. Met Google nest.

Posted in Development, Hardware Development | Leave a Comment »

LBS008AE and LBS005AE-R2, 10-100 Switches USB powered – Black Box

Posted by jpluimers on 2020/04/16

These are cool devices: the [WayBack] LBS008AE and LBS005AE-R2, 10-100 Switches USB powered – Black Box.

Both are the size of a Raspberry Pi and USB powered.

The first is 8-port, the second 5-port. Ideal for a stack of Pis.

There are 5V powered 8-port Gigabyte switches from other vendors as well at around `1A (effectively using ~5W), but they are bigger.

Via: [WayBack] How to Build a Kubernetes Cluster with ARM Raspberry Pi then run .NET Core on OpenFaas – Scott Hanselman

–jeroen

Posted in Development, Hardware Development, Power User, Raspberry Pi | Leave a Comment »

sed double expression: match, replace in one line, overwrite file

Posted by jpluimers on 2020/04/15

A while ago, I needed to conditionally replace in files, so I used sed and a regular expression, though usually I dislike those.

However, since the system had a very basic install, there was not much choice.

Luckily back then, my Google foo returned these:

This allowed me to do a double expression (the first matches a pattern, the second performs the actual replacement within the matching lines).

In case my Google foo in the future fails:

## https://robots.thoughtbot.com/sed-102-replace-in-place
## -i causes no backup to be saved, but does in-place replacement
## since we run under git, we can always restore
## combined with a double expression (the first matches, the second executes) this is very powerful
sed -i -e '/#.*AVOID_DAILY_AUTOCOMMITS=.*$/s/^.//' /etc/etckeeper/etckeeper.conf && git diff | more

–jeroen

Posted in *nix, Development, etckeeper, Linux, Power User, RegEx, Software Development | Leave a Comment »

GitHub – JensBorrisholt/GoogleSpeak: This repository demonstrates how to Use Google for implementing Text to Speech. You’ll find both a Delphi version and a C# version

Posted by jpluimers on 2020/04/15

For my link archive, as I will likely need this one day: [WayBackGitHub – JensBorrisholt/GoogleSpeak: This repository demonstrates how to Use Google for implementing Text to Speech. You’ll find both a Delphi version and a C# version

–jeroen

Posted in .NET, C#, Delphi, Development, Software Development | Leave a Comment »

I am in love with colors and design – UX Planet

Posted by jpluimers on 2020/04/14

Really cool not too long read: [WayBack] I am in love with colors and design – UX Planet:

How to improve human experience through color

[WayBack] “I’m in love with color” – No Google designer currently working at the company ever. Interesting read, btw. Some great examples, too. – Roderick Gadellaa – Google+

–jeroen

Posted in Color (software development), Development, Software Development, Usability, User Experience (ux) | Leave a Comment »

Binary search for finding problematic versions: install a specific version in homebrew and git bisect

Posted by jpluimers on 2020/04/14

I’ve used these excellent posts to find out which youtube-dl version started to exhibit troublesome NPO downloads, then later find the actual failing commit:

Why the effort? I needed an as recent as possible youtube-dl working on as many sites as possible because of some work preparation.

The first link is very important because brew versions and alternatives have stopped working some 6 years ago, even though they turn up high on Google searches for brew install specific version. Hence the quote from the first link:

Installing software packages on Mac is very easy with homebrew. You typically get the latest version, however often in production you do not have the latest version of a software package. Another use case is when you upgrade to the latest and you find out there is bug which blocks you doing something. In this case you would like to downgrade to the previous version until the bug is fixed.In both cases you need to install a specific version of a software package with homebrew on your Mac, which tends to be not that trivial. There is a lot of discussion about this on stackoverflow but some of them are outdated based on brew versions which is not available anymore.

Read the rest of this entry »

Posted in Apple, Conference Topics, Conferences, Development, DVCS - Distributed Version Control, Event, git, Home brew / homebrew, Power User, SocialMedia, Software Development, Source Code Management, YouTube | Leave a Comment »

Quickly See All the Formulas in Excel with This Shortcut

Posted by jpluimers on 2020/04/13

Toggle between regular view and view all formulas in a worksheet via [WayBack] Quickly See All the Formulas in Excel with This Shortcut which I wish I had known years ago:

  • Windows: Ctrl + ` (the acute accent key, found next to the number 1 on your keyboard).
  • MacOS: Cmd + `

Found using image search macos excel show all formulas – Google Search

–jeroen

Read the rest of this entry »

Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, macOS 10.12 Sierra, macOS 10.13 High Sierra, Office, Office 2011 for Mac, Power User | Leave a Comment »

Create a large file filled with zeros on Linux – twm’s blog

Posted by jpluimers on 2020/04/13

Interesting read as there are at least 3 options of which I only knew the first (dd): [WayBackCreate a large file filled with zeros on Linux – twm’s blog.

  • dd (fully allocated storage; zeros, random or another data source)
  • truncate (sparse storage; always gets zeros)
  • fallocate (fully allocated storage; always gets zeros)

–jeroen

via: [WayBack] Sometimes you need a large file for testing purposes or just to take up space that should not be available on the file system. There are several options… – Thomas Mueller (dummzeuch) – Google+

Posted in *nix, *nix-tools, Power User | Leave a Comment »

Schuurmonnikoog, Tuinesië en vele andere vakantiebestemmingen, sommige all-inclusive, tijdens de coronacrisis

Posted by jpluimers on 2020/04/12

Heerlijk al die creativiteit:

–jeroen

Posted in LifeHacker, Power User | Leave a Comment »

SFTP (SSH file transfer protocol) server on Windows

Posted by jpluimers on 2020/04/10

A few links for my archive:

–jeroen

Posted in Communications Development, Development, Internet protocol suite, Security, SSH, TCP | Leave a Comment »