変数に関するメモ。 💤がついてるのはzsh 固有のもの。

• シェル変数 → 子プロセスに継承されない
• 環境変数 → 子プロセスに継承される

環境変数登録

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

WSL2 uses a random network from the 172.16.0.0/12 RFC1918 private IP address block. And our VPN uses that address block, too, with a route metric of 1 (= most preferred.)

This breaks networking for WSL2. Meh!

While messing around with the interface/route metric of the VPN network may work around the problem, it also reduces the priority of the VPN. We do not really want this. Additionally, changing the interface metric does not seem to be permanent, so it requires more work when it breaks again.

This is a guide of how to install unsupported macOS and OS X versions on your Unsupported Mac. This information is also available in the #faq channel in the Unsupported Macs Discord Server.

• macOS Versions
• Mountain Lion (10.8)
• Mavericks (10.9)
• Yosemite (10.10)
• El Capitan (10.11)
• Sierra (10.12)

There are multiple options how to install MS Office on Linux.

VM-based - Integrate Windows apps running in a Windows virtual machine as native-looking in Linux

1. Winapps, based on KVM, QEMU, Docker/Podman and FreeRDP. Still actively maintained (getting Github commits). Decribed below
2. Cassowary, based on KVM, QEMU, libvirt/virt-manager, and FreeRDP. Has a helpful GUI and apparently can auto-suspend the VM when no Windows app is in use. Last release in Feb 2022 and seems to be abandoned.

The VM-based options means can run Office 2021 or Office 365 including all apps, but while the Windows apps themselves run flawlessly (as they're running on real Windows) there's various freerdp-related bugs you may encounter.

In this tutorial, we will setup GUI in WSL2. No additional software outside WSL (like VcXsrv or GWSL) is required. You will find this tutorial very similar to the one that replaces Xorg with Xvnc. Indeed, it's pretty much the same tutorial, with some few changes.

The key component we need to install is the desktop metapackage you want (GNOME, KDE, Xfce, Budgie, etc), and after that, replace the default Xorg by a script that calls Xwayland instead.

For this setup, I will use Ubuntu 24.04, and install GNOME Desktop. Unfortunately older versions of Ubuntu lack some fundamental things, so we cannot reproduce it in older versions (at least not fully). Since the key components aren't bound to Ubuntu or GNOME, you can use your favorite distro and GUI. Check the [Sample screenshot

PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural language used to write functions, triggers, and stored procedures within the PostgreSQL database. It extends SQL by adding control structures such as loops, conditions, and error handling. This allows developers to write more complex database operations and business logic inside the database itself.

Unlike SQL, which is primarily used to query and manipulate data, PL/pgSQL allows for procedural control over how and when those operations occur, making it ideal for tasks such as automation, batch processing, and integrating complex business logic into your database operations.