I am running across how to debug data in PostgreSQL, a platform I am not familiar with. Specifically using JSONB_SET. JSONB_SET documentation is the following jsonb_set ( target jsonb, path text[], new_value jsonb [, create_if_missing boolean ] ) → jsonb Returns target with the item designated by path replaced by new_value, or with new_value added if create_if_missing is true (which is the default) and the item designated by path does not exist....

Building foreverawards.com, I have built a basic minter and it works well enough to move to the next level, charging for the service to mint an award that the wallerholder sends to their teammate. Contracts When ever talking about charging, transfering, or components of, we are talking about Contracts, which is on v0.8 at the moment of writing this post in the soliditylang documentation site. Visibility and Getters external, can be used in transactions from other contracts....

Why? My config setup is the following, a free-ish version of GKE autopilot, and a load balancer is my ingress. I want the load balancer to terminate TLS. How Doing some web surfing I found this blog post and it’s literally git clone https://github.com/GoogleCloudPlatform/gke-managed-certs cd gke-managed-certs kubectl apply -f managedcertificates-crd.yaml kubectl apply -f managed-certificates-controller.yaml then kubectl annotate ingress [your-ingress-name] networking.gke.io/managed-certificates=mydomain-certificate UPDATE GKE autopilot changes As of May 2021 GKE removed 3rd party admission webhooks, now you will need to use https://cloud....

I am going to launch foreveraward.com on Kubernetes because why not? I need something to manage the foreveraward container and I am good with Kubernetes. The following checklist is going to be needed. Cluster GKE (1st time building) Helm3 compatible Ingress controller to support the ingress to the react app Launching GKE cluster Creating a cluster Using gcloud the command-line tool for Google cloud, let’s create a cluster with redundancy in us-west-1...

I am attempting to build a dApp. The problem is I do not know modern javascript, nor solidity. I am learning to react as I build the product to ensure that I can hit my overall goal of building foreveraward.com Import curly braces This question is asked on StackOverflow with a great answer Specifically, if I have a statement with the following: import { A } from './A' This is a named import called A and only works if there is a named export called A...

Incident Response Runbook This guide is meant to outline the process for running a common incident response. It ensures that we are working on the right problem, keeping all stakeholders informed, assigning focus roles, and discovering the root cause or at least mitigating the issue. Incident Priorities P0 (Critical Incident) A P0 incident is a complete outage or a severe degradation that affects all customers and requires immediate attention. P1 (Major Incident) A P1 incident refers to a customer-visible outage that interrupts the functionality or behavior of the platform....

Problem An award given should be proveable even if that physical representation of the award was lost, yet if the physical object is lost did the award every really exist. Solution NFT Having a way to represent ownership to digital content on the web is a very powerful feature. The decentralized nature of the blockchain or what I like to call very slow peer-to-peer databases gives that implicit trust that a smart contract was minted and cannot be changed, thus can represent ownership....

Last year I wrote a quick docker image and helm chart to install tailscale into your Kubernetes cluster. My particular use case was reaching devices between multiple colliding networks from the cloud to a physical location someplace around the world. Tailscale is perfect for this use-case, and putting together that project was fun and informative. Today I read this post by Maisem Ali and Maya Kaczorowski. A fantastic combination of features and abilities that make reaching services in a Kubernetes cluster easy....

GitHub pages is new for me and I was not aware that the contents of GitHub pages site can be based on branches and path combos. Using the GitHub action and reading the documentation, the action to build is on main. Main is the default branch. The action also executes hugo and publishes the hugo generated site to the root of the gh-pages branch. As a result, a silent step that was needed to automated this blog post....

In the past, I ran a blog at mysqldba.blogspot.com, but I started to move in different directions away from just the database layer but focused on truely the entire stack. I am doing much more than MySQL, but I still keep up to date and use it in my personal projects. Since I moved into the entire stack, I basically gave up my focus and to an extent my expertise in mySQL....