Why are so many of the posts to /r/python about fairly sketchy scripts?
Half of the posts are keyloggers, questionable scrapers, social media bots and auto-clickers, replacement programs for LONG solved problems with slightly suspect code, etc.
I know python is easy to learn and all, but is this much of the python community really just building scripts for semi-questionable software?
Edit: I almost forgot the "do my homework" posts.
74 comments · 67% upvoted · other discussions
It reminds me of the anecdote of a fella who FINALLY made his way into a data science/programming/IT role (paraphrasing) and he was THRILLED to finally peel back the cover and see a gorgeous, flawless interworking of code his new company was built on. But once inside he saw the reality, popsicle sticks held together by deal tape in a massive trembling structure. His job was constant maintenance, debugging, and identifying next steps for the business.
I supposed the lesson here is, this is not an exact science, mistakes teach faster that perfection, and we can’t let anyone know it’s all just a huge unstable house of sticks we are slowly building to stability
realboabab 5 points · Feb 2019
lol, I think this is the standard experience rather than mere anecdote. back to breakpoint debugging through local code running against live databases for me...
Log2 3 points · Feb 2019
For any programming language, might I add.
c_o_r_b_a 2 points · Feb 2019
I'd be interested to know about someone who joined a company and didn't have this experience.
sh0rtwave 2 points · Feb 2019
Or you see interesting emails, like the one I used to get that showed me: Tables with high identity values.
Just think that one through, and then WHY would I need to know...that?
__deerlord__ 1 points · Feb 2019
Integer overflow maybe?
sh0rtwave 1 points · Feb 2019
Right. On a *table ID column*.
Basically, this means the database has some tables that have almost reached the upper limit for automatically generated record IDs. MS SQL Server. This thing had to have some dude from MS show up weekly to keep it tuned, it was so packed with data.
__deerlord__ 1 points · Feb 2019
Well that makes sense that /someone/ is going to get notified. We've had sequence issues on some of ID columns, its...fun
sh0rtwave 1 points · Feb 2019
The crazy about it, was literally that: "If we don't keep an eye on it, a half-intense sales surge will kill the whole thing".
If it were me, I'd have stashed everything older than a couple of years into some kinda fast, queryable archive (even if it was just another table. Joins make life easier in this regard...)
scooerp 1 points · Feb 2019
Reaching overflow for database id isn't necessarily the sign of bad code or poor design, but just a large system that's been running for a while.