Difficulty 3 · Intermediate

Difficulty level 3 of 5: Intermediate

The core schema-design principles I follow

Here are the core schema-design principles I follow: Start from the business grain: define exactly what one row represents, e.g. “one trade execution” or “daily account balance per portfolio and currency.” Everything follows from this. Preserve raw data: keep an…

Run static website on Kubernetes

Assuming kubectl is configured. This is how to run default nginx site on Kubernetes. Simple setup = load balancer/no ingress In this example we don’t use an ingress. We just expose the static website behind a loadbalancer, so the static…

Pentesting with AI on a Cloud Server

Strix is an open-source AI pentesting tool that utilises an LLM together with standard tools to pentest software, repos and servers. You can use Strix with most LLMs, such as those served by OpenAI, Anthropic or Ollama. Note, that on…

Agent Code Generation Part 1: Augment Code

Automate a Causal Inference Python Repo from Scratch with Augment Code If you’ve ever wanted to build a clean Python repository for implementing methods from Causal Inference for the Brave and True but didn’t want to do all the setup…

How SSH Nuke in Matrix Reloaded works

In the movie Matrix Reloaded, we see Trinity use SSH Nuke to hack a compromised server. This script exploits the SSH CRC-32 vulnerability, specifically known as CVE-2001-0144, which affected older versions of the OpenSSH software. Here’s an explanation of how…

How to call an API from PySpark (in workers)

Tested in Databricks import pyspark.sql.functions as F import requests # create dataframe pokenumbers = [(i,) for i in range(100)] cols = ["pokenum"] df_pokenums = spark.createDataFrame(data=pokenumbers, schema=cols) # call API def get_name(rows): # take the first item in list (API doesn't…