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?

At over 600 comments and over a month old, v1 of the questions thread is due for retirement. Here’s a new, fresh one for all the users we are continuing to get.

We have a lot of new users joining the site. Welcome to Tildes!

This thread is for you to ask any question you have about the site, from “what is the moderation philosophy?”to “what does that blue line next to some comments mean?” to “what is the general vibe like here?” Tildes has a lot of documentation, history, and embedded social norms that can be daunting or opaque at first glance, so here’s your opportunity to get help with anything you need.

Questions about anything and everything are fair game. Follow-up questions are encouraged! No question is too simple.

Also, a quick note: the only person who can speak in any official capacity on Tildes is our admin @Deimos. Everyone answering who is NOT him is just a helpful community member!

It is perfectly okay to ask any question — even if you think it’s been asked before, or even if you didn’t search for an answer beforehand. Just ask away, and someone will answer you!

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.

The first three episodes didn't quite hit the mark for me, but this felt like proper TOS style Star Trek.

Starfleet messing up the Prime Directive. A villain who is actually a victim. Spock is challenged on feelings versus logic. The overall theme of exploring the importance of personal memories and the straight forward metaphor of fascist regime controlling the people, didn't feel as hamfisted as I have found some of the other newer trek episodes. It does stand on its own as a well rounded singular trek story. I do however still have a bit of a problem with how newer trek seems to like hand to hand combat violence so much. Feels unnecessary in most cases.

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)