<HebaruSan[m]>
Oh! So treating 'update' as a version
<HebaruSan[m]>
You know what, who cares about mods named `download`. Let's just go with the easy and obvious format and forget `//`
<DasSkelett[m]>
Yes, and it doesn't exist, so 404.
<DasSkelett[m]>
I guess FLask goes through the URL segment by segment and for each segment if first checks whether there is one path with with the segment value hardcoded.
<DasSkelett[m]>
Yes, and it doesn't exist, so 404.
<DasSkelett[m]>
I guess FLask goes through the URL segment by segment and for each segment if first checks whether there is one path with the submitted segment value hardcoded.
<VITAS[m]>
btw hows that seeding working?
<DasSkelett[m]>
Paused the work on it.
<VITAS[m]>
because of our uhm discussion?
<HebaruSan[m]>
Sshhhh, he's doing code review on my PRs, don't distract.... 😉
<VITAS[m]>
uh oh
<VITAS[m]>
dont want to waltz into your date
<VITAS[m]>
:P
<VITAS[m]>
< migrated his nextcloud instance to 20 lts and bind mount today
<VITAS[m]>
so hopfulyl that will not break down anymore and be usefull
<VITAS[m]>
(in case you guys ever need space on it....)
<DasSkelett[m]>
Mostly because I didn't do any coding work at all, had to reduce my Netflix backlog ;-)
<DasSkelett[m]>
Now I first want to review the bunch of open PRs from HebaruSan, he's waiting long enough.
<DasSkelett[m]>
But for when I continue work on it, can you take a look at the database and tell me how many mod versions and how many download events there are?
<HebaruSan[m]>
Did alpha's db get reset? I can't log in, and all the games and mods seem to be gone
<HebaruSan[m]>
I guess it's a new instance because the secret got shared?
<DasSkelett[m]>
Yes, it's currently pointing to a empty one.
<HebaruSan[m]>
OK
<DasSkelett[m]>
It's the one VITAS gave me to test the db upgrading during the prod upgrade.
<DasSkelett[m]>
We should probably switch back to the old one, but we need a new secret for that.
<VITAS[m]>
that involves me setting a new pw doesnt it?
<DasSkelett[m]>
Yes, for `spacedock_testing`
<VITAS[m]>
i should also rename the dbs
<VITAS[m]>
i find them confusing now
<VITAS[m]>
like spacedock_alpha and beta
<VITAS[m]>
can you stop alpha and beta sd quick?
<DasSkelett[m]>
Okay
<DasSkelett[m]>
Done
<VITAS[m]>
so alpha db is now spacedock_alpha
<VITAS[m]>
same for user
<VITAS[m]>
and analog for beta
<VITAS[m]>
you have the pw
<VITAS[m]>
:)
FireStriker[m] has quit [Quit: Client limit exceeded: 6]
HebaruSan[m] has quit [Quit: Client limit exceeded: 6]
DasSkelett[m] has quit [Quit: Client limit exceeded: 6]
DasSkelett[m] has joined #spacedock
<DasSkelett[m]>
Python gives the shape of braces too much relevance
Pheonix_Dev[m] has joined #spacedock
<Pheonix_Dev[m]>
How do I download a KSP mod?
<Pheonix_Dev[m]>
How do I download a KSP mod?
<DasSkelett[m]>
Go to spacedock.info, search for the mod you want, then click the big "Download" button on the right.
<DasSkelett[m]>
Go to https://spacedock.info, search for the mod you want, then click the big "Download" button on the right.
<DasSkelett[m]>
Uhm, for some reason alpha is throwing database authentication errors now.
VITAS[m] has quit [Quit: Client limit exceeded: 6]
HebaruSan[m] has joined #spacedock
<HebaruSan[m]>
BTW `/` on prod scans 20258 rows in the Game table to find the two active ones, why isn't it slower?
<HebaruSan[m]>
`Game.active` should probably be indexed
<DasSkelett[m]>
Maybe because it's just checking a simple bool?
<HebaruSan[m]>
Does postgresql cache certain queries when tables don't change?
<HebaruSan[m]>
20258 simple bools 🙂
<HebaruSan[m]>
I guess it keeps the Game table in memory
Pheonix_Dev[m] has quit [Quit: Client limit exceeded: 6]
<HebaruSan[m]>
I'm trying to decide whether it's worth it to take the plunge into multi-column indexes
<HebaruSan[m]>
At this point single columns seem to be doing OK for SD
<DasSkelett[m]>
Also regarding #295, had pretty much the same thoughts. I'm trying to find a way to remove the DownloadEvent table all together without breaking the "Downloads over time" graph.
<HebaruSan[m]>
Probably had to route Matrix -> IRC -> Matrix -> ICQ -> Matrix -> Discord to get to us
VITAS[m] has joined #spacedock
<VITAS[m]>
i could make them faster
<VITAS[m]>
and i thought github would be usefull
Github[m] has quit [Client Quit]
<DasSkelett[m]>
<span class="d-mention d-user">VITAS</span> if you have some spare time, can you look at the database and tell us the row count of ModVersion and DownloadEvent ?
HebaruSan[m] has quit [Quit: Client limit exceeded: 6]
KineticSloth8StoneBlue[m] has joined #spacedock
<KineticSloth8StoneBlue[m]>
mebbe different channel for Github notifications?... lots of other servers do it that way
VITAS[m] has quit [Quit: Client limit exceeded: 6]
HebaruSan[m] has joined #spacedock
<HebaruSan[m]>
SpaceDock is one channel to rule them all
<DasSkelett[m]>
Well that's an "interactive" bot that posts links to PRs you mentioned. Doesn't really make sense if you move it into another channel.
<DasSkelett[m]>
Very rough estimate: Assuming there's one DownloadEvent row per mod per hour it existed (thanks to the bug attributing downloads to the wrong DownloadEvent/ModVersion), and assuming a linear increase of the mod count, we have around 50.000.000 DownloadEvents.
<HebaruSan[m]>
More of an upper bound, right? Lots of mods aren't downloaded frequently
<HebaruSan[m]>
Also, my awesome `.with_entities`/`func.sum`/`.group_by` query is going away
<HebaruSan[m]>
F
<DasSkelett[m]>
Yes. On the other hand, the mods probably didn't increase linearly, but more hyperbolic (likely with a huge jump start from KerbalStuff and). Hard to do a good estimate.
<DasSkelett[m]>
Yes. On the other hand, the mods probably didn't increase linearly, but more hyperbolic (likely with a huge jump start from KerbalStuff). Hard to do a good estimate.
VITAS[m] has joined #spacedock
<VITAS[m]>
on prod?
<DasSkelett[m]>
Yes
<VITAS[m]>
sec
<VITAS[m]>
14509
<DasSkelett[m]>
That's ModVersion I guess, and DownloadEvent?
<VITAS[m]>
yes
<VITAS[m]>
10328064
<VITAS[m]>
i still think dl count per mod for everyone and detailed stats from matomo for the mod autrhor would be a good solution
<DasSkelett[m]>
Thanks! 10 million, had the right order of magnitude with my estimation. That is a lot, indeed.
<HebaruSan[m]>
Pls don't drop DownloadEvent until I import it into ModVersion.download_count 🙂
<DasSkelett[m]>
Haha, I for one didn't plan to.
KineticSloth8StoneBlue[m] has quit [Quit: Client limit exceeded: 6]