Banjos & Such @mayor@banjo.town

Trying to visualize an offset SG style guitar but, like, somehow a little less politely offset than the LTD Viper

I wish I still had Illustrator (or a day job excuse to need graphics enough to actually learn Inkscape)

but, it's probably good to be forced to be more mindful about how much related data one actually needs and where

Oof, so if you make a (relational DB) query with prisma and say "Include records from this relationship" it does so by doing a separate query

I think that's the default behavior in Django too but Django has options that let you explicitly specify that a table should be joined, or doing a 'select from [related table] where related_id in [ids from the main query]' instead of doing n+1 queries everywhere all the time

I mean I know this stuff is hard, especially when you're supporting multiple backends, but the response to tickets asking about joins seems to pretty much be "queries are cheap lol"

I have been very spoiled by Django's ORM

All of that being said, #trpc is some next-level shit once you start to wrap your head around it https://trpc.io/

...I also have a stubbornly hard time with the whole "better to load a page incrementally than for a user to suffer the grave indignity of having a page take more than a hundredth of a second to respond" thing

like, try surfing the internet on a noisy 56k AOL internet connection and *then* talk to me about page loading times

One of the hardest shifts for me to make as someone who learned how to build web stuff when most people were still on 56K dial-up connections is the modern "just indiscriminantly make a bunch of HTTP requests to load the various parts of a page, whatever 🤷" philosophy

Since I decided to implement my own generic foreign keys for things like tagging, it means I lose the ability to do prisma queries that automagically return collections of related objects, which means that I either need to write a bunch of extra code to achieve that server side, or just give in and make multiple requests (and, in turn, multiple db queries) to load that data sequentially on the client side. It's not a _ton_ of extra requests but it feels so... inelegant

Ah yep! https://codeberg.org/forgejo/forgejo

has there been an official “keep the code, ditch the new corporate crypto owners” community fork of gitea yet? I set up my own instance like a month before the takeover and it’s been nice having my own code vault, but I feel increasingly skeevy using it

Hey fediverse: Does there exist an audio equivalent of https://picsum.photos/ ? IE, hit a url or a web api and get a random audio file? I’m at the “need to populate the database with a bunch of fake data” stage and I know I *could* just use files I’ve got kicking around locally but real-world randomness is always better.

(Boosts welcome)

This plus Wi-Fi and cheap ubiquitous low-power LED lighting is the low-key sci-fi future stuff that genuinely blows my old 20th century self away… I mean, a wifi repeater and a little propane space heater and 💥

I’m once again daydreaming about the studio shed I’d like to build in the woods behind my house and holy shit, it looks like ~$500 is enough to get set up with a solar panel + battery powerful enough to power a guitar amp for hours 👀 https://paniquejazz.com/2019/03/20/use-any-guitar-amp-without-a-power-outlet/

Anyway, it occurs to me that if I’m using UUID primary keys then I shouldn’t need to worry about data types in a hypothetical “I just want m2m tagging without umpty join tables” scenario, at least from one side of the join. I could still kluge a ‘type’ field into the join table to be able to query by tag + type if I needed to

TypeORM doesn't solve the polymorphism problem, but it feels better than prisma, but (and maybe this is a me problem) it suffers from the "has lots of documentation that doesn't really explain how anything works if you aren't already familiar with it" problem

@Laser https://www.theonion.com/man-who-bought-34th-anniversary-reissue-of-fleetwood-ma-1819574597

Bought a couple of Udemy songwriting courses