Requirement I have 3 Prometheus servers and want to consolidate all of them into 1 Grafana. And one VM (Server C) is in a restricted zone and this zone only allows a special firewall rule from this zone to other zones. Prometheus A pulls (receives) metrics from Prometheus B In this scenario, we use the Federation …

Read More

Requirement Find a bandwidth management tool in OpenWrt to see which application (by interface) uses the most bandwidth. OpenWrt solution There are lots of bandwidth monitor tools in OpenWrt... https://openwrt.org/docs/guide-user/services/network_monitoring/bwmon#available_tools collectd collectd is not just for …

Read More

Notice This solution is only for Android 11 or below!!! Please use Better Open With in Android 12 or above. Requirement Android's default YouTube App is not very convenient, there are lots of Open Source alternatives (YouTube Vanced (removed), NewPipe, ...), although you can install them, if you don't change the …

Read More

Requirement Usually we use SonarQube to check the KPI of projects: You can also check the build history of a project: Use Grafana to Manager SonarQube KPI But there are some SonarQube exporters, they can export SonarQube's KPI to Grafana/Prometheus. Solution 1 Exporter: …

Read More

Change log 2022/10/13: Add some check points. Requirement When there are lots of projects on GitLab, it's not easy to know the overall build status of their CI/CD Pipelines. Use Grafana to Manage GitLab CI/CD Pipelines Solution 1: Use GitLab build-in metrics Exporter: GitLab build-in (reference: …

Read More

Requirement Most cameras' filenames are like 'DC*****' or 'P*****', I want to find a tool that has the following features. Batch change filenames to P[photo capture date]-[camera model].jpg. For example, P20220710-101405-iPhone 13.jpg. Can change the camera model string, for example, I want to change "iPhone …

Read More

I usually use Spotify to listen to podcasts, but because I use Spotify with my children, I want to find another Podcast App for my personal use. And I find Pocket Casts has an interesting feature, it can skip the first or last *** seconds. It means some podcasts have an introduction at the beginning, if you want to …

Read More

If you want to get the 1st record of range records, you can use this SQL command. 1SELECT * FROM 2(SELECT DISTINCT rank() over(PARTITION BY a.username ORDER BY a.update_dt desc) rn, a.* 3 FROM table_name a 4 WHERE a.update_dt > p_cur_timestamp 5 AND a.update_dt <= p_cur_timestamp + C_PERIOD 6 ) 7WHERE rn = 1

Read More

Remind This is for .NET 4.8 or below only!! Precondition You already have a GitLab (GitLab Saas or GitLab self-managed). This document is for .NET 4.X, if you want to build .NET core or .NET 5/6/7/..., you can use docker to run GitLab Runner. Procedure Step 1 - Prepare .NET build environment First, you need to prepare …

Read More

Requirement I want to have daily mail including currency exchange rate information. Mail subject: include the exchange rate in the mail subject. Mail content: Has some links to banks' exchange rate pages. Include some exchange rate history charts. Solution Use ifttt.com Create a new Applet on IFTTT Add a new "If …

Read More