Oh for fuck's sake. They depend on postgresql@16 but in their official documentation they say to use brew install postgresql, which installs 14 as that's the current stable/LTS/whatever in the brew repos.
brew remove postgresql
brew install postgresql@16
brew services start postgresql@16
$(brew --prefix postgresql@16)/bin/createuser -s postgres
And then run the Lemmy db-init.sh script. Now it works.
At least I didn't have to use Docker.
I'd love to help when I have the time. I know a bit of Rust but am fairly confident in TS/React.
I just spent an hour trying to get the backend run locally on my macOS machine without success so far. First, cargo build failed because of a linker error, but that was pretty straightforward. So for anyone running into the same error, just do this:
brew install libpq
brew link --force libpq
cargo clean
cargo build
Then there was an error connecting to the database. Which is strange, because I was pretty sure I had postgres installed. After some digging, it seems that this is a problem with postgresql@14 specifically and does not occur with earlier versions, so I downgraded to 13. With that, cargo run finally executed, but I ran into an actual error here.
>> Error: LemmyError { message: Unknown("Couldn't run DB Migrations: Failed to run 2023-07-08-101154_fix_soft_delete_aggregates with: syntax error at or near \"TRIGGER\""), inner: Couldn't run DB Migrations: Failed to run 2023-07-08-101154_fix_soft_delete_aggregates with: syntax error at or near "TRIGGER", context: SpanTrace [] }
I gave up for now. Debugging database migrations is probably the closest thing to the Basilisk torturing me for all eternity that I can imagine. If anyone knows what this is and how to fix it, I'd appreciate it.
I stand by my opinion that SEO basically ruined the internet. First keyword optimization made me scroll through seventeen paragraphs of someone's life story before getting to a recipe for boiled eggs, and now this.
Why would someone go to the trouble of making a law firm out of NameCheap, stock art, and AI images (and seemingly copy) to send quasi-legal demands to site owners? Backlinks, that's why.
Oof, back in the day all we had to do was write a nice email to get someone to put a backlink to our page into the sidebar of their Geocities page.
I smell bullshit written by spicy autocomplete, or at the very least it has LLM drivel pasted into it in various places.
In Europe, GDPR directives are important drivers which will become more stringent in the coming years. Better decentralization will enable higher security especially in terms of availability for this critical domain.
Lol what? The EPRS has quite unambiguously stated that there are multiple points of tension between blockchain tech and the GDPR, and that "decentralization == security" is a false assumption for various reasons. There's also the elephant in the room that every person maintains the right to all copies of their data at all times (mainly articles 16 and 17 GDPR), which is a problem if it exists in an uneditable distributed ledger.
The conclusion of that study was, and I quote, "that it is not possible to assess the compatibility between 'the blockchain' and EU data protection law", and the only reason why it even might be compatible is mainly because of "the uncertain definition of 'erasure' in Article 17 GDPR". But even then they only admit that there could by hypothetical beneficial use cases but fail to find any with current blockchain tech.
I swear, OpenAI is just a bunch of clowns LARPing as a company from Shadowrun and somehow it works and no one questions it.
I’m actually at a loss of words for this. What the actual fuck …
From here. The article is pretty interesting, though.
He seems to have the same amount of brain cells as a GPT at least.
The fucking comments on the live chat, lol.
I'd like to see him a free man. With his skill-set think of the contribution he could make
I would actually like to see him to less but use his knowledge to help other exchanges and crypto whales
Hope he gets the least amount of time
i feel bad for sam, i don't think he's a threat to society. only thing is they may want to make an example out of him
I suddenly feel like Hackerman because my PGP-encrypted file with Steam backup tokens is infinitely better secured than some crypto bro's detailed confession of crimes that could land them jail for 50 years.
These clowns are so fucking incompetent at being evil geniuses that they need a document outlining their Evil Plan™ and not once think how that might be a stupid idea.
Idk if this even meets the lowest-quality bar, but I just saw something on Reddit's Buttcoin sub, and the fact that this is a real headline is making me question my sanity. The future of finance, everyone.
And the AI-generated image is the cherry on top.
Jesus Christ, this guy read A Modest Proposal and took it as fucking inspiration.
Why is it always eugenics and euthanasia with these chucklefucks? The idea of exterminating large amounts of humans seems to tickle something in some people’s brains.