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.

I subscribe to a YouTube channel called Motorcoach World, which is run by a guy who iworks for a charter company as both a Director of Operations as well as a driver. He's super passionate about busses and has a lot of videos talking about their history and operations.

He's currently trying to do a cross-country trip on a double-decker all-electric bus. The intro video is here, and he's doing most of his daily updates via live stream here.

I've been loosely following along since it's interesting. He's had a lot of issues with charging. Everything from chargers being unaccessible due to use, being down for maintenance/not working, being de-rated to slower speeds, etc. Obviously his issues will be much worse than typical cars due to the needs for a specific charger type and power rating, but I imagine that electric trucks would run into similar issues?

Anyway, thought it was an interesting. He left California about a week ago and as of yesterday, he's made it to Texas.

Does anyone here have any experience with Aspiration or Amalgamated bank? I am interested in opening a new credit account and can't seem to decide which one to pick.

I've picked these two because of their environmental commitments, but I'm leaning towards Amalgamated since it's based in the East Coast.

Edit: Unfortunately, Beneficial is only in the West

Choose one album
that you love
that you think deserves more love

Tell us what it is, and why.

Previous posts in series

Additional Details

I know that a lot of people can only get into gaming as adults, and I have no idea how they do it. I grew up playing all sorts of games, so I'll try/enjoy anything from Harvest Moon to Baldur's Gate 3. But something that's been frustrating for a while is whenever I can't "get" something. An individual game is tolerable; I couldn't get into Stardew Valley the way I could Rune Factory, but oh well.

But shooters and (grand) strategy games feel incomprehensible to me. I enjoy Deep Rock despite being not any good at it, but it's my sole exception and probably because of the focus on PvE. Anything focused on PvP in general feels really unapproachable since I'll probably spend forever staring at a respawn or loss screen (I was just lucky growing up with SSB). I enjoy throwing myself at Dark Souls bosses way too early until I've finally gotten good, but in a team-based game I'd hate to force others into dealing with that. Strategy games are also kind of mind-boggling, but I also have trouble getting in the "conqueror" mindset that they seem to all require.

My friends really like those two kinds of games, so I'd really like to at minimum not zone out whenever they start talking to each other about them. Best case scenario, I could even try some of them myself.