I’m slowly getting into warhammer 40k but feel pretty disconnected from the broader 40K universe.

Are there any active communities where people discuss 40K? Discussion about new models, balancing, rule changes, painting show cases, etc.

Right now I’m just painting alone listening to PoorHammer on YouTube 😅.

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

What are those programs that you used back in the day (or even recently!) that you look back on fondly and think about how they once were-- or worse, programs that seemed to have just up and disappeared?

What made me think of this question, for me, was Opera. It had everything: browsing, RSS, and torrenting all in one browser. However, a lot of sites loved to break in it since it was the least supported and I eventually moved to Firefox (then Chrome, then Firefox...). Looking at the browser now-- and unsure if I'm just picky or its a case of enshittification, or both-- I'm just "meh."

Yesterday I recorded myself setting up PhotoPrism on an old laptop to document the journey. Everything went pretty smoothly which was great. In the past, I've used several different mainstream providers which ended up not working for me:

• Google Photos (been trying to move away from Google products for a while)
• One Drive (I'm not sure if this is widespread but my connection to One Drive servers are so slow. This is super evident right now as I'm trying to pull all my photos from it and it's taking forever)
• iCloud (This works pretty well but it doesn't feel great when I'm on my non-Apple devices)

I'm pretty excited to have local hardware running flexible software to host my things. I still need to figure out how I want to expose the computer so I have access to it away from home (I'm thinking of using Cloudflare Tunnel?).

Next up is finding software to stream videos to my TV so I can start getting rid of some streaming services.

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

Please let me know if this has already been answered - request in title.

I'm looking for it because of this post, and I'd also like to make the logo the android-homescreen shortcut for going on the tildes.net frontpage via mobile browser.

Hi everyone, I'm quite new to working the cross-server world of the Fediverse. Is there a way to search the Fediverse in one place, instead of just my server / instance?

For example, being able to search for #cats in not just my Mastodon server / instance, but on the others as well? And if it can search Lemmy and others as well, that would be AMAZING.

Hey Reddit enthusiasts! Revanced has recently extended its support to some of the most popular Reddit apps out there. The list of supported apps now includes Boost, Infinity, rif is fun, Relay, and Sync.

For those who are new to Revanced, this means you can patch these existing apps with your own oauth-client-id, allowing you to continue enjoying them seamlessly.

Quick tutorial:

1. Go to https://www.reddit.com/prefs/apps in your web browser.
2. Create a new app by giving it a name of your choice.
3. Tick the "Installed App" option and fill in the redirect URI field. The specific URI depends on the app you're using. For example, for rif, the URI would be redditisfun://auth. You can find the required redirect URI in the app's corresponding section on GitHub.
4. Copy the client ID string that appears for the app you just created.
5. Create a text document named "reddit_client_id_revanced.txt" and place it in the root directory of your phone's storage (e.g., /storage/emulated/0/<file here>). Paste the client ID into this document.
6. Install the latest version of ReVanced Manager on your device.
7. Open the Patcher tab in ReVanced Manager and select your app.
8. In the Patches section, enable the "Change OAuth Client ID" patch.
9. Apply the patch and install the modified app (Note: If you already have the app installed, you may need to delete it first and then click Install once ReVanced finishes creating the new APK.)

Following these steps will help you navigate through the process of obtaining a private client ID and applying the necessary patches to enjoy Reddit using ReVanced.

Guides with screenshots:

1. https://gist.github.com/decipher3114/4423a2671dc3ce4401025b737d5c89f4

2. https://docs.google.com/document/u/0/d/1wHvqQwCYdJrQg4BKlGIVDLksPN0KpOnJWniT6PbZSrI (Thanks to @kobew50 on Discord)

If you encounter any difficulties during the process,head over to ReVanced Discord server to seek assistance.

Reddit applications that have available patches or modified versions.

➡️ Platform: Android 🤖

➡️ Platform: iOS 🍎

*Shout-out to WefWef - a Lemmy client not only inspired by Apollo, but which is aiming for feature parity. (GitHub)

I am going to be in the market for a vehicle soon enough. My 2003 car is starting to show its age. Unfortunately my family still requires two cars often enough that I will need to find a replacement.

I have been bouncing the idea around in my head of getting an electric car.

As it stands, my 2003 has not gone over 50 miles in a single day more than a handful of times since we got a hybrid three years ago, and I don't see that changing soon. To me, this seems like an excellent opportunity to get a used electric vehicle that might not be getting the range that it once had. A vehicle that got 150 miles on a charge off the lot that now only gets 75 miles might be a problem for the original buyer but might not be for me.

My question to the users of Tildes - have you bought an "old" (I use this term very loosely) electric car for a similar use case? Are there problems with used electrics that don't have an ICE equivalent? Are you generally happy with the decision?

Alternative title(s) Sorcery Fight, JJK
Genres Action, Drama, Supernatural
No. Episodes 23
Information MyAnimeList AniList AniDB

Synopsis

The second season of Jujutsu Kaisen.

The past comes to light when second-year students Satoru Gojou and Suguru Getou are tasked with escorting young Riko Amanai to Master Tengen. But when a non-sorcerer user tries to kill them, their mission to protect the Star Plasma Vessel threatens to turn them into bitter enemies and cement their destinies—one as the world’s strongest sorcerer, and the other its most twisted curse user!

^{(from AniList)}

Discussion rules

BEWARE OF SPOILERS. Since all episode discussions are within a single thread, here are some rules to ensure revisits are safe from spoilers.

Direct links to each mini-thread

Episode discussion (main)

| Ep1 | Ep2 | Ep3 | Ep4 | Ep5 )

General discussion (extra)
| General chat || Season 1, Source material,

^{P/S: See here for more ongoing show discussion threads this season.}

This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.