Microblog

  • https://microship.com/winnebiko/ # Computing Across America (1983-1985)
    2021-08-02 13:13
  • Very much never expected to hear *that* song in an international TV show (at the end of Ted Lasso s02e01)
    2021-07-24 17:21
  • http://www.eusprig.org/horror-stories.htm
    2021-07-23 14:59
  • "Du bist nicht übermäßig schön und nicht exorbitant gscheit" - Anna Mabo, "Der Bär"
    2021-07-23 08:30
  • $vaccinated++
    2021-07-21 06:42
  • First day at the office desktop after ~9 months: I have to do a lot of `git pull` here and sync-stuff there
    2021-06-24 08:36
  • Yesterday I improved the performance of an SQL query by a few 100% by adding several gin_trgm_ops indices to some jsonb. PostgreSQL++
    2021-06-18 07:13
  • $pfizer->inject( $me );
    2021-06-16 07:00
  • I just created issue #2020 in one project. Let's see how it will turn out...
    2021-05-20 09:36
  • "Docker is basically iframes for computers." - https://twitter.com/paulca/status/1392934456244178946
    2021-05-14 10:48
  • Helpful postgres feature of the day: SELECT id FROM user WHERE settings->'colors' ?| array['green','yellow']; -- find all rows where the JSON array 'colors' contains any of green or yellow
    2021-05-12 14:28
  • Very strange requirements for a dev job: 'Must be able to lift objects up to 25 lbs. with or without assistance.', 'Must be able to stand, walk, stoop or crouch while performing daily activities of the job.' https://jobs.perl.org/job/21798
    2021-05-11 08:06
  • ... and the auto-build of the website should now work via a git post-receive hook triggered by this microblog commit
    2021-05-06 20:48
  • Finished my new, greatly simplified tool to create and publish this microblog entries. Now I only need to add a git hook to rebuild the website after a push. And autopost to twitter. And matrix, and IRC, ..
    2021-05-06 19:25
  • Two talks submitted for https://perlconference.us/tprc-2021-cloud/ (one on docker-compose, the other on Koha)
    2021-04-29 20:26
  • things I never wanted to learn #232: PostgreSQL 'concat' and '||' behave differently on NULL: SELECT concat(NULL,'foo'), NULL || 'foo';
    2020-06-23 12:22
  • a = 11nⁿ where n ∈ ℕ and 11 < a < 150
    2020-02-26 20:00
  • Just released https://metacpan.org/release/DOMM/App-TimeTracker-Command-Billing-1.000 - a new TimeTracker plugin to add 'billing points' to tasks: tracker start --issue 123 --billing 2019/Q4
    2019-12-11 19:43
  • After properly learning PostgreSQL CTEs & window functions, I need to write a lot less fixup scripts (because I can now do the fixups directly in SQL)
    2019-11-25 11:25
  • ACAB: All Clouds Are Bullshit!
    2019-09-11 11:56
  • No more teenagers!
    2019-08-27 10:00
  • PostgreSQL query of the day: UPDATE paragraph SET args = jsonb_set(args,'{audio_url}',('"' || regexp_replace(args->>'audio_url','old-host.at','new-host.at') || '"')::jsonb) WHERE type = 'audio' AND args->>'audio_url' LIKE '%old-host.at%';
    2019-05-20 22:15
  • git meta-alias: alias = config --get-regexp 'alias.*' # run 'git alias' to list all your aliases; via davewood
    2019-01-03 12:01
  • things I never wanted to learn #231: to round a value in libreoffice writer, use '=<C6>*24 round 1' not the more obvious '=ROUND(<C6>*24; 1)' from Calc
    2019-01-03 12:01
  • typo of the day: git ci -m 'remove debug outpur'
    2018-11-13 15:45
  • typo of the day: 'Fackend' (pronounce in German, but think English)
    2018-09-28 13:05
  • typo of the day: 'Gitscheincode' # /me blames finger memory
    2018-09-11 11:18
  • Current achievement: replaced three nested for loops and one expensive method call with a simple Common Table Expression. PostgreSQL++
    2018-08-28 15:30
  • things I never wanted to learn #230: Postgres point-based earth distance returns the distance in 'statute miles' (i.e. a 'U.S. survey mile', not the English statute mile of 1593 (which consists of 'eight Furlongs, every Furlong forty Poles and every Pole shall contain sixteen Foot and an half') - why not use metric? https://www.postgresql.org/docs/current/static/earthdistance.html
    2018-06-15 12:25
  • Today I finally removed disqus from https://domm.plix.at and replaced it with my half-finished, read-only (for now) self-hosted solution (which will be the topic of my #TEPC18 talk)
    2018-05-24 22:15