Requested feature overview description.
The uploader_id field is currently omitted from the posts DB export, it would be nice if it could be included.

I know it was omitted from post pages on purpose to prevent user confusion of who the artist is, but it's always remained available through the API. Not including it in the DB export seems like an oversight, especially since these files are generally only accessed by power users who can find this information anyway.

Why would it be useful?
It would allow for generating statistics relating to posts by users without having to hit the site with hundreds of constant API requests.

What part(s) of the site page(s) are affected?
https://e621.net/db_export/

edit: I'm stupid

Hmm, was looking at comments.json on a post and now this has me wondering if that's included. *time to look at documentation*

https://e621.net/wiki_pages/2425 It doesn't actually say, but from the filenames, I doubt it.

BTW: https://addons.mozilla.org/en-US/firefox/addon/open-tabs-from-clipboard-urls/ Hmm, this has deferred loading of URLs. This helps you avoid getting 503'd, as mentioned in that article.

kora_viridian said:
I have a copy of the posts-2023-05-01.csv.gz file and the uploader_id is present as the second column. I checked a handful of the lowest and highest post numbers in that file and it was populated for all of them.

I'm downloading the latest file, posts-2023-06-27.csv.gz to check... and they still seem to be in there. The latest post in that file is post #4135808 , uploaded by... user 601225 . >_> I also looked for my own user ID in that file, and it seems to be present on all the posts I've uploaded.

Yep. I opened the file I was working with last night again and it's right there, second column.

I'm not sure how I made such a monumental fuck up, to be honest.