[09:17:55] <legoktm>	 On Libera, #wmhack will now forward to this channel
[09:18:10] <legoktm>	 (ty to [1997kB] for the help :))
[09:18:30] <[1997kB]>	 np :)
[09:54:41] <wm-bb>	 [telegram] <Thecladis> To #wikimedia-hackathon or what is it now?
[09:59:31] <wm-bb>	 [telegram] <Nikki> am I right in thinking it's not possible to add things to the mobile menu on wikimedia wikis?
[15:50:28] <wm-bb>	 [telegram] <bd808> @Thecladis yes, the libra.chat channel is #wikimedia-hackathon. The name change happened as part of the migration over to libra.chat. It was done so that the channel would fit with the "channel namespace" concept that libra.chat uses to give our group contacts default control of things related to Wikimedia.
[16:50:49] <bd808>	 Coolest Tool Award live stream starts in 10 minutes -- https://www.youtube.com/watch?v=cdnwhDAdrxE
[16:58:35] * legoktm waves
[16:59:52] * dcaro_away waves back
[17:01:00] <AntiComposite>	 if the countdown has not started, you may have to refresh the page
[17:01:22] <wm-bb>	 [telegram] <bd808> https://tools-static.wmflabs.org/bridgebot/e441e032/file_10507.webp
[17:02:57] * AntiComposite wonders what the YouTube rules on bridging a livestream chat to IRC are...
[17:03:33] <legoktm>	 does matterbridge support YouTube premieres? :D
[17:03:36] <taavi>	 try it and find out?
[17:04:44] <wm-bb>	 [telegram] <andreklapper> Welcome to the Coolest Tool Award watching on Telegram, I guess! :)
[17:08:02] <legoktm>	 congrats Magnus!
[17:08:43] <samwilson>	 wikishootme is so great :-)
[17:10:28] <wm-bb>	 [telegram] <mahir256> *shudders at adjusting coordinate without adjusting reference on it*
[17:11:38] <legoktm>	 ooh 100%
[17:11:51] <legoktm>	 Quarry is awesome
[17:12:15] <wm-bb>	 [telegram] <Nikki> I'm pleased to see the video has subtitles
[17:12:30] <wm-bb>	 [telegram] <jhsoby> just wish it came with an SQL tutorial for those of us who don't know SQL at all 😜😂 (re @wmtelegram_bot: [irc] <legoktm> Quarry is awesome)
[17:12:49] <wm-bb>	 [telegram] <jhsoby> (j/k of course)
[17:12:51] <wm-bb>	 [telegram] <Jan_ainali> or better search for existing queries (re @jhsoby: just wish it came with an SQL tutorial for those of us who don't know SQL at all 😜😂)
[17:12:51] <tanny411>	 Aye!! Quarry is super Awesome!
[17:13:29] <wm-bb>	 [telegram] <bd808> @yuvipanda congrats!
[17:14:01] <legoktm>	 ^^ congrats Yuvi and everyone else who worked on Quarry over the years!
[17:14:11] <wm-bb>	 [telegram] <Nikki> I just need a big map of the tables, I have no idea where anything is :P (re @jhsoby: just wish it came with an SQL tutorial for those of us who don't know SQL at all 😜😂)
[17:14:33] <wm-bb>	 [telegram] <mahir256> I thought there was one (potentially out of date) (re @Nikki: I just need a big map of the tables, I have no idea where anything is :P)
[17:14:37] <wm-bb>	 [telegram] <bd808> https://www.mediawiki.org/w/index.php?title=Manual:Database_layout/diagram&action=render
[17:14:56] <dcaro>	 might be nice to add a link to it from quarry xd
[17:14:58] <wm-bb>	 [telegram] <bd808> https://www.mediawiki.org/wiki/Manual:Database_layout
[17:14:58] <legoktm>	 just about to link to that too
[17:15:10] <wm-bb>	 [telegram] <Nikki> that image doesn't make much sense to me, nothing is linked to anything
[17:15:12] <AntiComposite>	 Quarry links to Category:Database layout
[17:15:40] <wm-bb>	 [telegram] <jhsoby> huh, how come i didn't know about action=render until now (re @bd808: https://www.mediawiki.org/w/index.php?title=Manual:Database_layout/diagram&action=render)
[17:16:15] <legoktm>	 whee, go DannyS712!!
[17:16:42] <wm-bb>	 [telegram] <bd808> https://tools-static.wmflabs.org/bridgebot/3081aea6/file_10508.webp
[17:16:59] <AntiComposite>	 https://www.mediawiki.org/wiki/Manual:Parameters_to_index.php#Actions
[17:18:09] <wm-bb>	 [telegram] <bd808> https://www.mediawiki.org/wiki/Humaniki
[17:18:47] <legoktm>	 ooh, this is pretty neat
[17:19:33] <wm-bb>	 [telegram] <Nikki> so... is there anything that actually shows how the tables connect to each other and isn't just a list of tables?
[17:20:15] <wm-bb>	 [telegram] <Nikki> 'cause I can't find anything on those pages mentioned
[17:20:24] <wm-bb>	 [telegram] <mahir256> that's actually what I thought existed at one point, but perhaps I hallucinated it?
[17:21:02] <wm-bb>	 [telegram] <Nikki> last time I looked, I found a really old diagram, but it was so old the tables had changed too much for it to be any use :(
[17:22:05] <AntiComposite>	 we've got way more interconnected tables now it would have to be interactive
[17:23:21] <legoktm>	 I think an older version of the diagram had lines connecting all the foreign keys
[17:23:55] <legoktm>	 I hadn't seen depictor before, looks very cool!
[17:25:05] <AntiComposite>	 ooh, that looks interesting
[17:25:17] <wm-bb>	 [telegram] <Jan_ainali> Congrats @jhsoby !
[17:25:24] <wm-bb>	 [telegram] <lucaswerkmeister> \o/
[17:25:38] <wm-bb>	 [telegram] <jhsoby> yay :D
[17:27:18] <legoktm>	 woah, diffedit is something I've always wanted
[17:27:35] <legoktm>	 congrats jhsoby!
[17:27:58] <wm-bb>	 [telegram] <jhsoby> thanks!
[17:31:43] <wm-bb>	 [telegram] <lucaswerkmeister> congrats @JeanFred for Wudele!
[17:32:38] <wm-bb>	 [telegram] <JeanFred> Ah shoot this was today. I’m still at work :-( (re @lucaswerkmeister: congrats @JeanFred for Wudele!)
[17:34:03] <legoktm>	 go PAWS!
[17:35:23] <wm-bb>	 [telegram] <Jan_ainali> 🐾
[17:40:10] <legoktm>	 Earwig!
[17:41:54] <legoktm>	 My favorite part about this tool is that people just call it "Earwig" when that's his username, not the tool naem
[17:42:34] <AntiComposite>	 "Earwig says it's a copyvio" "Earwig: I said what?"
[17:43:04] <legoktm>	 :D
[17:45:06] <legoktm>	 congrats everyone :) really great tools
[17:48:20] <wm-bb>	 [telegram] <andreklapper> Thanks everyone!
[17:54:03] <dcaro>	 congrats! \o/
[17:54:47] <legoktm>	 thanks to the Academy as well for putting this together :)
[18:13:21] <wm-bb>	 [telegram] <Neslihan> Thanks to everyone especially the deveopers of this cool tools <3
[19:27:46] <wm-bb>	 [telegram] <Lucas811825> 🏅 SportsCollective ($SPORTS) provides fans with unique opportunities to collect NFTs curated by their favorite sport athletes. 
[19:27:46] <wm-bb>	 [telegram] <Lucas811825> Live the dream of every sports fan through SportsCollective. 
[19:27:48] <wm-bb>	 [telegram] <Lucas811825> $SPORTS is launching on the 18th of Jan on Uniswap at 2PM UTC!
[19:27:49] <wm-bb>	 [telegram] <Lucas811825> The platform aims at creating a “once in a lifetime” experience for fans by connecting them to their favourite stars through NFTs🎖 
[19:27:51] <wm-bb>	 [telegram] <Lucas811825> Elevate your everyday sports experience with $SPORTS!
[19:27:52] <wm-bb>	 [telegram] <Lucas811825> Join the Community!
[19:27:54] <wm-bb>	 [telegram] <Lucas811825> 🏐Telegram: Sports_Collective_International
[19:52:38] <AntiComposite>	 is there really no free JS library for entity relationship diagrams?
[19:56:04] <AntiComposite>	 there's plenty of commercial options, but nothing FOSS
[23:02:49] <wm-bb>	 [telegram] <lucaswerkmeister> I don’t think that information exists in the source code anymore? (re @Nikki: so... is there anything that actually shows how the tables connect to each other and isn't just a list of tables?)
[23:03:17] <wm-bb>	 [telegram] <lucaswerkmeister> the old postgresql schema had it, but since the migration / unification of the SQL schemas I don’t think we have any foreign key constraints in MediaWiki core anymore
[23:03:29] <wm-bb>	 [telegram] <lucaswerkmeister> so you’d have to infer the table connections from the column names, or manually maintain them somewhere
[23:03:58] <wm-bb>	 [telegram] <Nikki> ah :/ no wonder I'm always so lost when trying to use sql then
[23:16:26] <wm-bb>	 [telegram] <Nikki> I've basically given up on sql queries. I used quarry quite a bit years ago but whenever I try these days I end up spending several hours trying to get one query to work before giving up in frustration. I don't know how people do it without a diagram
[23:17:25] <wm-bb>	 [telegram] <mahir256> anyone doing cross-wiki database joins has also given up afaict
[23:23:08] <wm-bb>	 [telegram] <Jan_ainali> I mostly just use page, actor and revision, and those are fairly easy to join (re @Nikki: I've basically given up on sql queries. I used quarry quite a bit years ago but whenever I try these days I end up spending seve...)
[23:28:18] <wm-bb>	 [telegram] <Nikki> I often want labels or descriptions (since the query service can't search by language, and the dump is far too big now) 😬
[23:58:55] <wm-bb>	 [telegram] <Thecladis> Why would you need a diagram? (re @Nikki: I've basically given up on sql queries. I used quarry quite a bit years ago but whenever I try these days I end up spending seve...)
[23:59:13] <wm-bb>	 [telegram] <Thecladis> Although for something like wb tables perhaps...
[23:59:39] <wm-bb>	 [telegram] <Thecladis> But for something like revision, user, page and such it is quite straightforward...