about summary refs log tree commit diff
path: root/users/Profpatsch
AgeCommit message (Collapse)AuthorFilesLines
2024-10-05 r/8771 chore(users/Profpatsch): remove AoC stuffProfpatsch4-269/+0
Change-Id: Ifb134053c0f92dfdb4f2c0a3418c0c6a7a1a8507 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12574 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8770 feat(users/Profpatsch): move eslint & prettier to toplevelProfpatsch8-156/+120
the linters & prettier config should apply to my whole subdir. This is somewhat nasty, you have to `npm` in the toplevel dir before it starts working, otoh dev tooling is dev time and I’m working on these alone. Change-Id: I96721f549b24a40b7ffbb2d310f37a40d2590b2b Reviewed-on: https://cl.tvl.fyi/c/depot/+/12573 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8769 feat(users/Profpatsch/lyric): add tapping & improve silence warningProfpatsch2-18/+67
Add a tapping command that does not quantize the timestamps. For the silence warning, we make it BPM-dependent (defaulting to 120BPM as everywhere else), meaning for slower songs we give a higher possible time difference before we display a warning. Change-Id: Idefc44166639b23c2105a1a810ac22ed84457225 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12563 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-10-05 r/8768 fix(users/Profpatsch/lyric): create new lyric file if not existsProfpatsch1-15/+15
That was the original intention, but I didn’t understand that lua would fail with "r+" if the file does not exist (and "w+" truncates the file, so you have to try "r+" and then fall back to "w+" which will create the file as well.) Change-Id: Ib238f0b73ab403ceeaf035d053a14eba718d1b48 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12562 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-10-05 r/8767 feat(users/Profpatsch/lyric/ext): add lrc upload & ms offsetProfpatsch3-6/+405
This adds support for uploading the lyrics part of an .lrc file to lrclib, see https://lrclib.net/docs I pretty much only used ChatGPT to translate the rust “proof of work” challenge to nodejs and it worked first try lol. Before uploading the lyrics, I construct a webview with a preview of what is going to be uploaded, and then only upload when that is accepted. Pretty sweet. Also adds two commands for increasing/decreasing the current timestamp by 100ms and starting playback from 2 seconds before that, very handy for fine-tuning lines. Change-Id: Ia6adfe26d0c21c62554c8f8c55e97e2caec95d1e Reviewed-on: https://cl.tvl.fyi/c/depot/+/12561 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-10-05 r/8766 chore(users/Profpatsch/lyric): add typescript linting rulesProfpatsch6-89/+140
Change-Id: I9ab0336450519648f7a8edeec94bd64b78e2f05b Reviewed-on: https://cl.tvl.fyi/c/depot/+/12554 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8765 feat(users/Profpatsch/lyric/ext): add bpm on quantizationProfpatsch1-8/+102
If the bpm header already exists, overwrite it with the new value. Also use an existing header as suggestion. Change-Id: If6431e8056504db437c31313d885b5ba0d0e55d5 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12553 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8764 feat(users/Profpatsch/lyric): add .lrc header for new filesProfpatsch1-2/+27
Insert the length and stuff into the .lrc file headers. Change-Id: Id2565c95c516208f1e46b79d5b8da50f3d6bee62 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12552 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8763 feat(users/Profpatsch/lyric/ext): add bpm quantizationProfpatsch3-1/+186
It’s a bit crappy and really depends on the input field opening quickly again (which it often doesn’t really do…), but it was the easiest way I figured how to do it haha. Aligning to eigth notes is pretty much the easiest way to sync everything up after tapping in the timestamps (for most songs). Change-Id: Ibbb072f62b6ee17d983e81b6c1554bc3516fa636 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12551 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-10-05 r/8762 feat(users/Profpatsch/lyric/ext): add lyric shiftingProfpatsch2-7/+137
Change-Id: I1b52e2a295ae81d5d9bf488b1e584dda4d5aac9b Reviewed-on: https://cl.tvl.fyi/c/depot/+/12550 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-10-05 r/8761 refactor(users/Profpatsch/lyric/ext): use document directlyProfpatsch1-14/+12
Change-Id: I6869743727d3b16b74c498b4cd60b33c3ed3997d Reviewed-on: https://cl.tvl.fyi/c/depot/+/12549 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8760 refactor(users/Profpatsch/lyric/ext): move command into fnProfpatsch1-36/+38
Change-Id: I2d38455cdf881e03a390d129f9cee3f9eeca485d Reviewed-on: https://cl.tvl.fyi/c/depot/+/12548 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8759 feat(users/Profpatsch/lyric): add vscode extension & helpersProfpatsch17-0/+643
* tap-bpm: simple CLI program that accepts key inputs and averages a BPM value * lyric-timing-mpv-script: If you press Ctrl+l, mpv attaches the current timestamp to a .lrc file named after the song. This is for manually timing missing songs for uploading them to https://lrclib.net/ * extension: vscode extension for `.lrc` files, currently with the following features: 1. A “jump to LRC position” command which reads an .lrc timestamp from the current line and expects mpv to listen on `~/tmp/mpv-socket` (via `--input-ipc-server`), and will seek to the exact timestamp (down to the ms) in the currently playing song. 2. Some initial linting warnings - A lint that warns if the difference to the next timestamp is more than 10s (which usually means there’s an instrumental and the previous line is stuck) - A lint that checks that timestamps are monotonically increasing Change-Id: I32a4ac0e2c5bbe3d94e45ffcf647f81bc7c08aa0 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12537 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-10-05 r/8758 fix(users/Profpatsch/lyrics): remove special chars from searchProfpatsch1-0/+9
Leaving out any symbol characters improves the search accuracy. Change-Id: I00c993d4099bb8e9701783b53afc9423f1b2f674 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12480 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-10-05 r/8757 feat(users/Profpatsch/lyrics): integrate into an mpv extensionProfpatsch4-58/+149
Slop it together! The mpv script is entirely generated by ChatGPT. Whoooooooooo Change-Id: Ic284d142c2f1fd6d407af6b3571db0e815604051 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12478 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8688 feat(users/Profpatsch/lyrics): fall back to plain lyricsProfpatsch1-4/+13
if there are not synced lyrics. Change-Id: I3e8d452fc63847505886ea0bb01d29dd5dcb56d1 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12477 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-13 r/8687 feat(users/Profpatsch): add lyricProfpatsch2-1/+49
Change-Id: I3171d19f1cd550ef22a3a7e851f9d27d3bf34949 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12476 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8686 feat(users/Profpatsch): add xdg-cache-homeProfpatsch1-0/+14
Change-Id: I0f4efa16426f590cee9332d11c13dd07569b4acb Reviewed-on: https://cl.tvl.fyi/c/depot/+/12475 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8685 chore(users/Profpatsch): remove git-db & rust depsProfpatsch2-102/+0
This never went anywhere. We had problems with `git2` breaking, so let’s remove everything that this pulled in. Change-Id: Ia29d827cd6fc7b97aedca36a37f8418384579c38 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12474 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-13 r/8684 fix(users/Profpatsch/README): typoProfpatsch1-1/+1
Change-Id: I7176289cd7884e795cfe283fc1ec3fcc674acae6 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12473 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8683 fix(users/Profpatsch/.gitignore): add nix resultsProfpatsch1-0/+1
Change-Id: I44322b61b0653220173c3b5008ffa0ff727cfd35 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12472 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8682 feat(users/Profpatsch/MonadPostgres): add unzipPGArray fnsProfpatsch2-8/+75
Change-Id: I47ae3520998c1da7a8ad34231fd5af39240a771d Reviewed-on: https://cl.tvl.fyi/c/depot/+/12471 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-13 r/8681 fix(users/Profpatsch/whatcd-resolver): refresh table on deleteProfpatsch2-7/+19
Instead of serving a stale table when a torrent gets deleted, fetch the whole view again. This is a little wasteful, but torrents shouldn’t get deleted very often, so it’s fine. Change-Id: If33d517270421881852158f27dbc3e7d24880d3b Reviewed-on: https://cl.tvl.fyi/c/depot/+/12333 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8680 fix(users/Profpatsch/whatcd-resolver): also delete db torrent fileProfpatsch2-15/+38
If transmission does not know about a torrent file anymore, we should not only delete our local transmission torrent hash, but also the torrent file. Before, it would always display the old weighted torrent, even after removing it from transmission. Now, it will automatically clear and switch to the new top-weighted mp3 version. Small bug: since we only clean the torrents after already fetching the table data, we get a stale result right after clean-up. Maybe we should re-do the fetch instead. Also logs what gets deleted and only ever deletes if there is something to delete, leading to more obvious traces. Change-Id: I0f6c1dc3669d0f549efaba2c46c34b77c1eb7e33 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12332 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8679 feat(users/Profpatsch/whatcd-resolver): add format to tableProfpatsch2-5/+15
Change-Id: I6ca18ad9f73a8e75e4bfb77156d19604ab27b284 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12331 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-13 r/8678 fix(users/Profpatsch/whatcd-resolver): prefer downloaded torrentsProfpatsch1-1/+5
I changed the seeding weight, so now it would not show already downloaded torrents, prompting me to fetch stuff that I already have in new qualities. Obviously, that’s not the best idea. Kinda surprised it’s this easy to fix heh. Change-Id: I6bbf325672a91d794d144c006ccf3d702a581bce Reviewed-on: https://cl.tvl.fyi/c/depot/+/12330 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-13 r/8677 chore(users/Profpatsch/whatcd-resolver): ignore .ninjaProfpatsch1-0/+1
Change-Id: I1b89161c9b4b763abcf74bd19f03275f987924ca Reviewed-on: https://cl.tvl.fyi/c/depot/+/12329 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8676 fix(users/Profpatsch/whatcd-resolver): set empty faviconProfpatsch1-0/+6
Change-Id: Id1fbcb39579f2d3c68989e4395cdadaa04790cec Reviewed-on: https://cl.tvl.fyi/c/depot/+/12328 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8675 fix(users/Profpatsch/whatcd-resolver): pretty AppExceptionProfpatsch7-70/+84
AppException would be a console-pretty-printed version for http errors, which would print all the escape codes in the jaeger traces of the exception, making it more-or-less unreadable. So instead, let’s make AppException two cases, an ErrorTree case which is printed as-is (no color), and a “Pretty” case which is printed using the pretty module (colors on console, no colors in otel). Somewhat involved, I guess this is temporary until I figure out what is really needed. Change-Id: Iff4a8651c5f5368a5b798541efc19cc7ab9de34b Reviewed-on: https://cl.tvl.fyi/c/depot/+/12232 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-09-13 r/8674 fix(users/Profpatsch/whatcd-resolver/services): dont unset buildersProfpatsch1-1/+1
Change-Id: I3fdf15d7a3a8e04fd73f22ad9c33a2c011609e3e Reviewed-on: https://cl.tvl.fyi/c/depot/+/12231 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-13 r/8673 feat(users/Profpatsch/whatcd-resolver): adjust seeding_weightProfpatsch1-2/+22
* Prefer MP3 versions to save on ratio * Definitely never download 24bit flacs, they are not worth it at all One needs to remove the `seeding_weight` column and restart for it to have any effect (no real migrations yet, but eh) bump Change-Id: I30cc3ea05c4352316e3929f93d90fc27ce833682 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12222 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-09-05 r/8653 chore(3p/sources): bump channels & overlays (2024-09-01)Vincent Ambo1-7/+9
Included changes: * users/aspen: explicitly use open-source nvidia driver This now has to be specified explicitly, otherwise evaluation fails with an error. * users/aspen: nixfmt -> nixfmt-classic * users/aspen: fixes for renamed packages & options * users/tazjin: fixes for renamed packages & options * 3p/overlays: remove cbtemulator patch (merged upstream) * tvix/shell: remove unnecessary patches (merged upstream) * 3p/rust-crates: mark libgit2_sys as broken * users/Profpatsch: mark git-db as broken * 3p/overlays: pick `mypaint` from stable channel * tvix: fix comments that clippy doesn't like anymore * tvix/glue: disable a misfiring clippy lint (applying its suggestion breaks code below) Change-Id: I6d3fc027694bbe7425a2d25dc53d65467a44f3b0 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12403 Tested-by: BuildkiteCI Reviewed-by: aspen <root@gws.fyi> Reviewed-by: Profpatsch <mail@profpatsch.de> Autosubmit: tazjin <tazjin@tvl.su>
2024-08-06 r/8449 fix(users/Profpatsch/whatcd-resolver): reduce json data from dbProfpatsch4-20/+104
We’d transfer the full json data for each torrent from the db instead of just the 2 or 3 fields we need. Adds some more helpers for parsing database values. Adds some better logging events & traces. Change-Id: I5db386c4ea247febf5f9fc3815da2e7f11286d41 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12140 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-08-06 r/8448 fix(users/Profpatsch/whatcd-resolver): fix postgres query logProfpatsch3-104/+109
The queries would not be interpolated anymore, because we didn’t pass the thing down deep enough. Also only init the `pgFormatPool` if we want to use the formatter, this saves on a bunch of subprocesses. Change-Id: I8d69ef5aab4d8eac1cbfb1c3991d4edaacba254f Reviewed-on: https://cl.tvl.fyi/c/depot/+/12139 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-08-06 r/8447 fix(users/Profpatsch/whatcd-resolver): SQL formatting offProfpatsch4-53/+78
It turns out the pg_format thing is just too slow for my use-cases most of the time, even when pooling the mf. Most queries stay 90%+ in the perl script, even though they are very fast to execute on their own, screwing up the traces a lot. So instead I replace the `postgres-simple` quasi-quoter that strips whitespace (and tends to screw up queries anyway) with a simple one that just removes the outer indentation up to the first line. Why did I spend so much time on pg_format haha Change-Id: I911cd869deec68aa5cf430ff4d111b0662ec6d28 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12138 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-08-06 r/8446 chore(users/Profpatsch): park ical-smolifyProfpatsch4-0/+0
Parked projects: I might pick these up again, but don’t want to maintain them right now. Might delete later, or reinstate. Change-Id: Ieb4f51dfaeba33c84820ca804b57c016e05bf566 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12137 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-08-06 r/8445 refactor(users/Profpatsch/whatcd-resolver): continue httpProfpatsch3-6/+7
Ideally there’d be a better generic abstraction of doing basic http calls (with tracing) in the future, but for now just reexport. Change-Id: Id7548739ea62e9172f2773f8db79fe726096b7f1 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12136 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-08-06 r/8444 refactor(users/Profpatsch/whatcd-resolver): start moving http stuffProfpatsch3-62/+70
There’s a bunch of duplication in how http client things are done, let’s move that all to a single module. Change-Id: Ic08c9bce49d562e4fa640a5bdfc15973a28a7bcb Reviewed-on: https://cl.tvl.fyi/c/depot/+/12135 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-07-30 r/8428 fix(users/Profpatsch/whatcd-resolver): make getTorrent no jsProfpatsch1-5/+32
Start of an effort to make the app work without javascript enabled (graceful degradation yay). We use a trick where buttons are nested into a form element, passing their value as input; this should be better than depending on `hx-vals`. If htmx is disabled, just redirect and reload the full page instead of sending back the snippet. Probably depends on the use-case of each snippet though. Change-Id: I6c73e624c4bd29b1cbd5492b2f84f48102edc68b Reviewed-on: https://cl.tvl.fyi/c/depot/+/12056 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-07-30 r/8427 feat(users/Profpatsch/whatcd-resolver): read redacted key from envProfpatsch3-17/+44
Change-Id: I5667710423aeeacfbb8dddf5b0b8750dc8f878aa Reviewed-on: https://cl.tvl.fyi/c/depot/+/12055 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-07-30 r/8426 fix(users/Profpatsch/whatcd-resolver): better show ApplicationErrorProfpatsch1-2/+4
Change-Id: I7a1087afc4000299529a7518f273bfee8d651c72 Reviewed-on: https://cl.tvl.fyi/c/depot/+/12054 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-06-07 r/8224 feat(users/Profpatsch/whatcd-resolver): add <title> to artist pageProfpatsch1-4/+11
Change-Id: I49c4f657b099de806cc310bbf0a17ceba09b4d0f Reviewed-on: https://cl.tvl.fyi/c/depot/+/11760 Reviewed-by: Profpatsch <mail@profpatsch.de> Autosubmit: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-06-07 r/8223 refactor(users/Profpatsch/whatcd-resolver): split table data fetchProfpatsch2-25/+40
Change-Id: Ic9b2f1e6a5ff0c65b93c1662bad75fb41c86bfcd Reviewed-on: https://cl.tvl.fyi/c/depot/+/11759 Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de> Autosubmit: Profpatsch <mail@profpatsch.de>
2024-06-03 r/8209 feat(users/Profpatsch/whatcd-resolver): show album yearProfpatsch1-0/+2
Change-Id: I1ec1b22c83e078f31e56e13c63a92d3a4560e46d Reviewed-on: https://cl.tvl.fyi/c/depot/+/11746 Autosubmit: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-06-03 r/8208 fix(users/Profpatsch/whatcd-resolver): fix torrent linkProfpatsch2-2/+2
The redacted URL needs the torrent group id to go to the album page, not the torrent id. Also open the external link in a separate tab. Change-Id: Ie6d73cb02137855bb388859d2800968cd56ece49 Reviewed-on: https://cl.tvl.fyi/c/depot/+/11745 Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI Autosubmit: Profpatsch <mail@profpatsch.de>
2024-06-03 r/8207 feat(users/Profpatsch/whatcd-resolver): add redacted torrent linkProfpatsch2-7/+9
Change-Id: I9e2cd1935a67260cc7e4b72b247c01495e130949 Reviewed-on: https://cl.tvl.fyi/c/depot/+/11744 Autosubmit: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-06-03 r/8206 fix(users/Profpatsch/whatcd-resolver): db_id -> redacted_idProfpatsch2-10/+10
We’re using the redacted id, not the database id. This is more stable. Change-Id: I4d24e5bc6cc469d811cb1402a83157359576ef77 Reviewed-on: https://cl.tvl.fyi/c/depot/+/11683 Autosubmit: Profpatsch <mail@profpatsch.de> Reviewed-by: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI
2024-06-03 r/8205 fix(users/Profpatsch/whatcd-resolver): add page chrome to artistProfpatsch1-31/+41
Change-Id: Id13553c450603b04c6bba0085d7f3246fe0d54af Reviewed-on: https://cl.tvl.fyi/c/depot/+/11682 Autosubmit: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-06-03 r/8204 fix(users/Profpatsch/whatcd-resolver): speed up table queryProfpatsch1-27/+23
This took a while to figure out, but essentially sorting a thing with one million queries takes a long time, as compared to doing it on a small subset of things and then joining against the final ordering. The generated column helps, too. Change-Id: I1bf283e2be060748eebda92576e3d062c51a6777 Reviewed-on: https://cl.tvl.fyi/c/depot/+/11681 Autosubmit: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>
2024-06-03 r/8203 chore(users/Profpatsch/openlab-tools): warnings & formatProfpatsch1-28/+28
Change-Id: Iab582c4cd9dc623449940920d9ac4864b515b5c8 Reviewed-on: https://cl.tvl.fyi/c/depot/+/11680 Autosubmit: Profpatsch <mail@profpatsch.de> Tested-by: BuildkiteCI Reviewed-by: Profpatsch <mail@profpatsch.de>