Steffen Gransow graste

https://tilde.zone/@sirwumpus/114585252224070493

For Google searches to get rid of all the extraneous guff in the results, add a new search URL "Google Classic" https://www.google.com/search?udm=14&num=50&q=%s

Similarly "DuckDuckGo Lite" with https://noai.duckduckgo.com/?q=%s

author: @sleepyfox
title: Expertise and interviews
date: 23-Apr-2023

Expertise and interviews

In 2001 Paul Graham, founder of Startup Incubator Y Combinator wrote a blog post about LISP called 'Beating the averages'. I don't want to talk about LISP, or startups, not today anyway.

Git Subtree Basics

If you hate git submodule, then you may want to give git subtree a try.

Background

When you want to use a subtree, you add the subtree to an existing repository where the subtree is a reference to another repository url and branch/tag. This add command adds all the code and files into the main repository locally; it's not just a reference to a remote repo.

When you stage and commit files for the main repo, it will add all of the remote files in the same operation. The subtree checkout will pull all the files in one pass, so there is no need to try and connect to another repo to get the portion of subtree files, because they were already included in the main repo.

Adding a subtree

Let's say you already have a git repository with at least one commit. You can add another repository into this respository like this:

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

There are always 24 hours in a day.
February is always 28 days long.
Any 24-hour period will always begin and end in the same day (or week, or month).

https://x.com/jh3yy/status/1852465034481598662?t=Du7wTV-oMGpensDrwPjBMA&s=19

– translate some letter strips on :hover – vertical letters with word-break/white-space

a:is(:hover, :focus-visible) span {
    transition: translate 0.25s var(--delay) steps(11);
    translate: -50% calc(100% - 1lh);
}

Get WGS84-GeoJSON from WFS with Soldner-Coordinates

The problem: get GeoJSON data from a WFS that uses a projection other than WGS84. This is e.g. true for all geo data in Berlin's FIS-Broker GIS. The data there uses the "Soldner" projection (or EPSG:25833).

Download as XML

You need to know the URL of the WFS you want to get the data from.
Consider Baumbestand Berlin - Straßenbäume - Sachdaten zur Karte - [WFS]:
The URL is https://fbinter.stadt-berlin.de/fb/wfs/data/senstadt/s_wfs_baumbestand.
The last bit of the URL is also the name of the layer: s_wfs_baumbestand.

rechtliches

WCAG

WCAG 2.1 auf Deutsch
Es gibt mittlerweile auch schon die WCAG 2.2
Wirkt sich die WCAG 2.2 aus?
A Roundup Of WCAG 2.2 Explainers
WCAG Cheat Sheets and Checklists

	DELIMITER //

	CREATE FUNCTION BIN_TO_UUID(b BINARY(16))
	RETURNS CHAR(36)
	BEGIN
	DECLARE hexStr CHAR(32);
	SET hexStr = HEX(b);
	RETURN LOWER(CONCAT(
	SUBSTR(hexStr, 1, 8), '-',
	SUBSTR(hexStr, 9, 4), '-',

	// This will use the single-packet attack for HTTP/2, and last-byte synchronisation for HTTP/1
	int NUMBER_OF_REQUESTS = 10;
	var reqs = new ArrayList<HttpRequest>();
	for (int i = 0; i < NUMBER_OF_REQUESTS; i++) {
	reqs.add(requestResponse.request());
	}

	var responses = api().http().sendRequests(reqs);
	var codes = responses.stream().map(HttpRequestResponse::response).map(HttpResponse::statusCode).toList();
	logging().logToOutput(codes);

	CREATE FUNCTION text_to_timestamp(text) RETURNS TIMESTAMP
	LANGUAGE sql IMMUTABLE AS
	$$
	SELECT CASE
	WHEN $1 ~ '^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}(\.\d+)?$' THEN
	CAST($1 AS timestamp without time zone)
	END
	$$;

	CREATE TABLE t (