literally just finished reading both "sled driver" and "skunkworks" and wow, those guys knew what they were about.

PhotoPrism[0] and some ugly plumbing[1] to semantically tag all images in the gallery.

[0]: https://github.com/photoprism/photoprism [1]: https://github.com/marklr/labelizer

otherwise, mrs caveman not like cave.

also, caveman employer not like caveman. replace caveman with Flo since grug feng shui is so easy, even caveman can do it

I was super interested up until the Discord link :(

They have a mirrored room on Element/Matrix as well but it's just the general chat and not the technical etc. sub-rooms. I quit Discord a while ago, probably for reasons similar to yours, and interact with the community using Element instead.

So much for punk and hacker cultures... discord is the windows of chat platforms :(

The cool part is that the backend is open source, I'll be mirroring a few of my favourite subs on my local lemmy instance with this.

Thanks again for posting the link!

I've jumped completely over to lemmy and am mulling writing a bot to replicate external content to my instance (from e.g., unmigrated subreddits);

the UX is fantastic though, tons of original content with almost zero spam. scaling the network seems hard as every event is a POST request (lol) but the community will persevere and overcome this imo

Did you look into https://lemmit.online?

I would encourage you to post that as a separate submission, since I have so many questions (https://news.ycombinator.com/from?site=lemmit.online shows nothing)

Done! https://news.ycombinator.com/item?id=37027946

I mean the posts are hardly what I visit Reddit for. The true value is in the comments. For posts I could simply use RSS instead.

Ok. Supposed I go on to write a service that lets you replicate a selection of your favorite subreddits on lemmy. Would you pay for it?

oh wow, thanks for this!

This still needs a network effect to get started

Yeah true, that's why Reddit doing it would be kinda interesting (they won't).

will they retail globally?

We ship globally to our customers right now but I believe having a distribution channel for global retail would be much wiser. I'm definitely open to it once we get to that point.

This is incredibly hard to accept but is so true!

Wouldn't a single application of a temp table be sufficient?[0]

0: https://brianchildress.co/reorder-columns-postgres/