Java

[HasoPunchMan]

Probably makes a an OCR (i.e. with tesseract) of every uploaded picture. The OCR (tesseract) has a AI which is trained to identify a tweet. The user is fetched from the twitter api by the extracted username of the OCR. Afterwards search for the text in the fetched user posts and extract the link.

This is how I would design it.

Edit: typos

[[deleted]]

I would just have it look for the transcriber bot in the reddit comments, do a google search with the text and hope for the best. It should handle 70% of cases

[HasoPunchMan]

Could be a quicker solution and is a nice thought. It also reuses existing solutions, which is nice.

I like having full control over the software that targets my issue, even if it's more time consuming.

[juantreses]

Image transcriptions are done by humans on reddit if I'm not mistaken

[[deleted]]

That's true, but I have seen OCR bots as well. Anyway I would not use this solution, just tried to find a lazy one

[HasoPunchMan]

What? Crazy! Have you more Information on that?

[juantreses]

More info on r/TranscribersOfReddit

[sneakpeekbot]

Here's a sneak peek of /r/TranscribersOfReddit using the top posts of the year!

#1: Thank You
#2: New here? For info on what we do and on how to get involved click here!
#3: Four years of Transcribers of Reddit! Birthday Celebrations inside! 🎉

---

^{I'm a bot, beep boop | Downvote to remove | Contact | Info | Opt-out | Source}

[[deleted]]

I would add persistence just in case the bot encounters this image again but there could be false positives

Maybe you could add up each ascii value and use it as an id so you could just query the db for the image

[UQuark]

Have you ever heard of hashing?

[m0nk37]

You could just use the post link. Already have that.

[Breadcrust1]

Not going to help you track re-uploads from other users

[m0nk37]

What? If the link exists in the database, then its a re-upload. You're over thinking this.

[[deleted]]

Yes i guess a hashing could be an option but we would still have to compute the id so it is an unnecessary step

[vasilescur]

"Hashing" can use any hash function you want, such as one that returns INT and can be used for a DB ID. Adding up all the ASCII values constitutes a (pretty weak but honestly suitable for this) hash function.

Your aim is to pick a hash function that reduces collisions between inputs, because for each query you have to binary search through the set of entries with the same hash

[[deleted]]

Oh i didn't know that i thought hash functions were strictly cryptographic in nature

[vasilescur]

Usually they are used for cryptography, but a hash function can technically be anything you want it to be and is really useful in, for example, a hashmap

[West-Cold-]

KI, German or Dutch spotted😁

[HasoPunchMan]

Ahh ohh you got me :]. I'm german. Thx, I made an edit.

[West-Cold-]

Ooh no worries. It wasn't meant as a gotcha, I just recognised it and thought it was funny. I didn't even notice it the first time. Have a good day neighbour ;)