Mahatma_Fatal_Error MahatmaFatalError

Making Postgres materialized view refreshes O(delta) instead of O(total)

Many developers assume PostgreSQL materialized views handle incremental updates out of the box. They do not. If you have a materialized view with millions of rows and a single underlying record changes, both native refresh options process the entire dataset.

Because of this limitation, anyone needing immediate maintenance or working with large datasets must abandon materialized views entirely. The standard workaround is to manually maintain a standard table using custom database triggers or application logic.

I've been working on a patch to fix this. It adds an optional WHERE clause to the REFRESH MATERIALIZED VIEW command, letting you scope a refresh to exactly the rows that changed. The patch is currently under review on the pgsql-hackers mailing list.

This approach requires two things. First, the materialized view must have a unique index (the same requirement as REFRESH MATERIALIZED VIEW ... CONCURRENTLY). Second, the

Modulith VS. Microservices

This document contains a tabular comparison of the Modulithic and Microservice Architecture approach under certain aspects. Many of them can be achieved or influenced in both styles, but to different degrees and using different means. No claims of exhaustiveness.

PostgreSQL is Enough

See the new site: https://postgresisenough.dev

Autobahn App API

Das BMVI hat eine völlig nutzlose App gebaut. Eine Autobahn-Info App.

Wirklich völlig nutzlos?

Nein, es gibt jetzt nämlich eine offene API für aktuelle Verwaltungsdaten in Bezug auf Baustellen-Informationen, Webcams, Parkplätze, … - bestimmt für jemand nützlich.

Endpunkte

Hier gibt es eine OpenAPI Spec von @creckord: https://gist.github.com/creckord/a2e09267f5fdfadc2cd75eedb3182b8a

https://verkehr.autobahn.de/o/autobahn/

Memory LIMIT and REQUEST in Containers and JVM

Do you run a JVM inside a container on Kubernetes (or maybe OpenShift)?
Do you struggle with REQUEST and LIMIT parameters?
Do you know the impact of those parameters on your JVM?
Have you met OOM Killer?

Hope you will find answers to these questions in this example-based article.

How to set up JVM Heap size in a Container

How to use PlantUML with Markdown

PlantUML is a really awesome way to create diagrams by writing code instead of drawing and dragging visual elements. Markdown is a really nice documentation tool.

Here's how I combine the two, to create docs with embedded diagrams.

Step 0: Setup

Get the command-line PlantUML from the download page or your relevant package manager.

Comparison of ZSH frameworks and plugin managers

Changelog

update 1: add a FAQ section
update 2: benchmark chart and feature comparison table
update 3:
- improve the table with missing features for antigen
- new zplg times result

	# autobahn-api-to-es
	#
	# Indexes autobahn API metadata into Elasticsearch to use it with Kibana Maps
	#
	# Original API description https://gist.github.com/LilithWittmann/06bd153317b635e7b622651f5cfd95ea
	#
	#
	# MIT License
	#
	# Copyright (c) [2021]

	<!doctype html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<title>Vue test</title>
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"
	integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
	<script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
	<script src="https://cdn.jsdelivr.net/npm/axios/dist/axios.min.js"></script>
	</head>

	publish.dependsOn lookForArtifacts

	task lookForArtifacts {
	group "upload"
	doLast {

	def pomFileName = "${ARTIFACT_ID}-${ARTIFACT_VERSION}.pom"
	def artifactPath = "${ARTIFACT_GROUP.replace(".", "/")}/${ARTIFACT_ID}/${ARTIFACT_VERSION}/${pomFileName}"
	def repositoryUrl = "$MAVEN_SERVER/${artifactPath}"