jae

you may remember that about a month ago (i think???) we made it so that all shares are hidden from the main tag pages. this was a quick, temporary response to prevent users from sharing with an unrelated tag to put a post in front of an audience OP did not intend.

changes are for sure going to include:

shares made by OP will show up in tag pages still
shares with content made by a different user will only show up in tag pages IF they are using a tag that OP also used (for example: if i share a post that OP tagged #dwarf fortress, and i am also tagging it #dwarf fortress, it will show up in the #dwarf fortress tag. but if i share it tagged #fortnite, it will not show up in the #fortnite tag.)
shares without content will still not appear in tag pages.

this will likely not ship today BUT i like sharing what i'm working on

#cohost meta

jae @jkap12/12/2022, 5:50 PM

my favorite thing in the world is when i freestyle a giant-ass sql query that i'm pretty sure is gonna run like shit but at least works, plug it into the query planner, and get back a cost/time that's infinitely better than i expected and within Acceptable Bounds.

also, following @vogon's post about the adult content decision tree, here's the tag search decision tree

#devlog

You must log in to comment.

in reply to @jkap's post:

matthew r.f. baloušek @mrfb12/12/2022, 4:46 PM

exciting! thanks for your hard work. are you planning on a signifier between the two tag behaviors? (not to feature creep/request, just curious)

jae @jkap12/12/2022, 4:51 PM

unsure what you mean by the two tag behaviors

matthew r.f. baloušek @mrfb12/12/2022, 5:17 PM

i.e., the normal behavior and the... stealth? behavior that doesn't put the tag in the feed

James Munns @jamesmunns12/12/2022, 5:24 PM

This sounds awesome, thank you :)

in reply to @jkap's post:

ralsei chuffin back a fat dart @avril12/12/2022, 6:26 PM

regarding the "tag we're querying was used by OP" question, does that only look at the original post, or tags that might've shown up in other versions of the post? for example, let's say I make a post where I say "apples are round," and then I share my own post and say "by the way, the same thing is true about oranges," and I tag that share with #oranges. if someone else shares that post and says "another fact about oranges is they're orange," and tags their share with #oranges, will it show up in the #oranges tag? and what if someone shares my original apples post (not the version with oranges) and tags it with #oranges?

jae @jkap12/12/2022, 7:10 PM

no to both cases. for the former, checking the entire share tree is Very Expensive so we want to avoid it if we can; for the latter, since oranges isn't in the original post it isn't considered.

ralsei chuffin back a fat dart @avril12/12/2022, 7:37 PM

I've gathered through context clues that the term "expensive" is being used here to generally mean "requires a lot of time and resources," but I also get to hold the image in my head of a server refusing to do a more difficult task until you fork over another $50. which I guess isn't completely wrong, actually

jae @jkap12/12/2022, 7:40 PM

yeah realized that was some Jargon lmao. in a sense it is both, though, as computationally intense queries also become more money expensive as we scale

Piper Thunstrom @pathunstrom12/12/2022, 7:08 PM

That feeling of "I'm beginning to speak the language the SQL optimizer expects" is a weird feeling. Like, it's amazing but also so few people value that skill?

jae @jkap12/12/2022, 7:11 PM

my favorite thing when i'm query-golfing is when i rearrange a bunch of stuff to change the Core of how the query works (same inputs and outputs) and the planner spits out the exact same plan. outsmarted. also a reminder that the planner is really fucking good at optimizing

Piper Thunstrom @pathunstrom12/12/2022, 7:21 PM

It's so incredibly good. I'm the resident SQL expert on my team and I basically just tell juniors "the the important things to know: Table scans are the most expensive, the earlier you can remove data the better, everything else is going to be very query and data specific that I don't want to give you general advice."

Kindly Wizard @KindlyWizard12/12/2022, 8:24 PM

My SQL guru taught me early "Until you are good, the optimizer is smarter than you." He was right, and nowadays I'm good (not great). But it took a number of shite queries until I got there.

D @pinstripeowl12/12/2022, 10:55 PM

sneak peeks into development bits (of anything, really) are so interesting, thank you for sharing!

waffle @wffl12/13/2022, 7:06 PM

sorry for asking, but I was wandering, what did you use to draw this diagram? 👀

jae @jkap12/13/2022, 7:07 PM

figjam! it's part of figma, which we use for design mockups

Pinned Tags