Hardys hardyscc

Docker on Windows

Ubuntu on WSL

First make sure uninstall all of the old Ubuntu installation under App & Features.

Install Windows Subsystem for Linux under App & Features > Optional features > More Windows features, then

wsl --update

Stored Procedure on Spring Boot

Executing stored procedures in Spring Boot using the @Procedure annotation provides a convenient way to interact with database procedures. By annotating a method with @Procedure and specifying the procedure name, you can easily call stored procedures, pass parameters, and handle result sets, simplifying the integration of stored procedures in your Spring Boot application.

Demostrations

Convert JPA Specification to Stored Procedure

Selected Function to Convert

Windows 11 Setup

Recommended Packages

winget install chrisant996.Clink

winget install Git.Git
winget install GitHub.cli

Podman on Windows

Prerequisite

Windows Subsystem for Linux
- First ensure Windows Subsystem for Linux has been installed under System > Optional features > More Windows features.
OpenSSH

echo "import java.net.InetAddress; \
public class HostnameFromIp { \
    public static void main(String[] args) throws Exception { \
        var startTime = System.currentTimeMillis(); \
        System.out.println(InetAddress.getByName(args[0]).getHostName() + \
                \" - \" + (System.currentTimeMillis() - startTime) + \"ms\"); \
    } \
}" > HostnameFromIp.java

Setup MicroK8s

Install microk8s

sudo apt-get update
sudo apt-get upgrade -y

sudo snap install microk8s --classic --channel=1.31/stable
sudo microk8s status --wait-ready

Sonarqube on MicroK8s

https://docs.sonarsource.com/sonarqube/9.9/setup-and-upgrade/deploy-on-kubernetes/deploy-sonarqube-on-kubernetes/

helm repo add sonarqube https://SonarSource.github.io/helm-chart-sonarqube
helm repo update
kubectl create namespace sonarqube
helm upgrade --install -n sonarqube sonarqube sonarqube/sonarqube \
 --set ingress.enabled="true" \

Podman on Mac

Install

brew install docker-compose kind podman podman-desktop

	#!/bin/sh

	# Usage: export JAVA_TOOL_OPTIONS=`get-java-opts-proxy`

	local_http_proxy=${HTTP_PROXY:-$http_proxy}

	if [ -n "$local_http_proxy" ] ; then
	if [ $? -eq 0 ]; then # If variable has username and password, its parse method different
	http_proxy_host=$(echo $local_http_proxy \| sed 's/http:\/\/.@\(.\):.*/\1/')
	http_proxy_port=$(echo $local_http_proxy \| sed 's/http:\/\/.@.:\(.*\)/\1/' \| tr -d "/")

	--Create user xxx_dba
	create user xxx_dba with encrypted password 'Dba12345';

	--Create app user
	create user xxx_user with encrypted password 'User12345';

	--Create xxx database (db owner = xxx_dba)
	create database xxx with owner xxx_dba;

	--Change db to xxx without change user