Microblog

  • 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
  • Coding to pre90ies Beastie Boys is very hard between all the dancing, headbanging and remembering a shockingly large percentage of the lyrics - will have to switch to boring music to get some work done .. but I guess work can wait a bit!
    2018-05-03 12:56
  • things I never wanted to learn #229: Postgres supports Infinity on floats, but not on ints (which makes no sense from a mathematical point of view, but unfortunately does make sense from a database point of view
    2018-04-30 11:37
  • Thanks to the very loud Wien-Marathon-Helis it took me 10 minutes to figure out that I'm not listening to 'Sunny Side Up', but to 'FM4 läuft'. Grr...
    2018-04-22 09:11
  • I just deleted 176 testacounts linked to my email; now expecting much less self-spam!
    2018-03-02 14:48
  • git mining: when committing, try to find a nonce to be included with the commit so that the SHA-1 checksums of all commits are a continuous stream of ever-increasing hex numbers.
    2018-01-23 14:32
  • leicht aus dem Kontext gerissen, aber trotzdem: "[Bitcoin] represents a cryptographic proof of wasted CPU cycles" https://lcamtuf.blogspot.co.at/2017/12/the-deal-with-bitcoin.html :-)
    2017-12-15 11:48