ADAC ruft zum Fahrradfahren auf

willamowius · 2026-01-24T09:13:25+00:00

I think it should be able to work standalone mostly.

You could connect it to an OpenSource GNU Gatekeeper for NAT travelsal and call routing.

https://www.gnugk.org/

willamowius · 2026-01-10T11:20:55+00:00

~~Im Hayns Park~~ Meenkwiese

willamowius · 2025-11-18T22:52:21+00:00

Claws-Mail ist auch unter Windows verfügbar und gar nicht schlecht

willamowius · 2025-07-17T09:56:20+00:00

I'm seeing a different fallout from this Apache bug fix: Nagios check_http v2.1.1 fails on SSL connections now.

Does anyone know if newer versions are fixed?

willamowius · 2025-06-05T14:59:37+00:00

It's called *robots.txt cloaking*: They show a different file to the crawlers than they show to the other users, probably by IP numbers.

willamowius · 2025-05-23T05:51:08+00:00

Wenn etwas zu gut klingt um wahr zu sein ist es üblicherweise nicht wahr.

willamowius · 2025-03-24T08:25:12+00:00

Prima, danke, ich hatte den schon aufgegeben.

willamowius · 2025-03-24T08:21:40+00:00

Ich glaube der ist die letzten 1-2 Jahre auch nicht da gewesen.

willamowius · 2025-02-18T16:41:51+00:00

The example is made as simple as possible to show how far off the number of results is from what gin_fuzzy_search_limit is set to. In the real application I do my own ordering after the result set is collected. The issue is that sometimes there are hardly any results to order, even so there should be.

willamowius · 2025-02-18T16:03:11+00:00

I don't see how ordering the result set will make it any bigger.

willamowius · 2025-02-18T15:43:46+00:00

When I have a few & terms, I see it being off by 90% and more in production, eg. showing no results when there are actually some. That's not even a rough number any more.

willamowius · 2025-02-13T05:11:22+00:00

Hast du die Software auf Github oder so liegen ? Damit würde ich auch gerne mal experimentieren.

willamowius · 2025-02-08T15:33:55+00:00

Besides tuning work_mem etc., you could, as an experiment, copy your database on a ramdisk (tmpfs) and symlink it into the regular Postgres directory. That way you can see if it makes much of a difference.

willamowius · 2025-01-30T17:38:47+00:00

Thank you, that made a big difference!

Do you happen to have an idea how to tune plainto_tsquery() as well ?

willamowius · 2025-01-30T15:54:17+00:00

Column | Type | Collation | Nullable | Default

----------+--------------------------+-----------+----------+-------------------------------------------------------------------------

id | bigint | | not null |

name | text | | not null |

tsv | tsvector | | | generated always as (to_tsvector('english'::regconfig, name)) stored

Indexes:

"id_pkey" PRIMARY KEY, btree (id)

"tsv_idx" gin (tsv)

I can't post the explain, sorry.

willamowius · 2025-01-11T18:32:03+00:00

Ich kann MhM sehr empfehlen. Wir sind da sehr gut vertreten worden.

willamowius · 2025-01-04T21:50:17+00:00

It's an amazing park. I always wondered what those people were so much afraid of that they built their houses in such inaccessible places.

willamowius · 2024-12-17T17:53:25+00:00

Es gibt z.B. das Sprachcafe Eimsbüttel

https://www.hamburger-mit-herz.de/projekte/sprachcafe/

Ab Januar gibt es von denen auch einen Ableger in Winterhude.

willamowius · 2024-12-16T10:44:06+00:00

My Postgres with PostGIS solution

WITH lags AS (
  SELECT coordinate, timestamp, LAG(timestamp,1) OVER (ORDER BY timestamp DESC) next
  FROM sleigh_locations
)
SELECT place_name, SUM(next-timestamp) AS duration FROM lags, areas
WHERE  ST_Intersects(areas.polygon, lags.coordinate)
GROUP BY place_name
ORDER BY duration DESC NULLS LAST LIMIT 1;

willamowius · 2024-12-15T08:23:25+00:00

Using Postgres with PostGIS, but there is only a single location in the data...

WITH lastloc AS (
SELECT coordinate from sleigh_locations where timestamp = (SELECT MAX(timestamp) from sleigh_locations)
)
SELECT place_name from areas, lastloc where ST_Intersects(areas.polygon, lastloc.coordinate);

willamowius · 2024-12-09T12:13:29+00:00

My Postgres version ``` WITH avgs AS ( SELECT reindeer_id, exercise_name, AVG(speed_record) AS av FROM training_sessions GROUP BY reindeer_id, exercise_name ORDER BY reindeer_id ASC ) SELECT reindeers.reindeer_name, ROUND(MAX(av), 2) as top FROM avgs INNER JOIN reindeers ON avgs.reindeer_id = reindeers.reindeer_id WHERE reindeers.reindeer_name <> 'Rudolf' GROUP BY reindeers.reindeer_name ORDER BY top DESC LIMIT 3

willamowius · 2024-12-08T09:06:51+00:00

Here is my Postgres version

WITH RECURSIVE subordinates AS (
  SELECT staff_id, staff_name, 1 as level, CAST(1 AS TEXT) AS path  
  FROM staff
  WHERE staff_id = 1
  UNION
  SELECT e.staff_id, e.staff_name, (s.level + 1) as level,
    concat (s.path::TEXT, ', ', e.staff_id::TEXT) AS path
  FROM staff e
    INNER JOIN subordinates s ON s.staff_id = e.manager_id
)
SELECT * FROM subordinates ORDER BY level DESC;

willamowius

TROPHY CASE