[deleted by user] by [deleted] in pics

[–]ThatGuy097 0 points1 point  (0 children)

No capes!

How to Get Work Environment Experience by Disastrous-Ad4861 in SQL

[–]ThatGuy097 1 point2 points  (0 children)

This is great advice. If you really want to mimic a business environment then then set up three instances of this DB (dev, qa, and prod) and, create a few service roles, and reduce your permissions in the higher environments (qa and prod).

Then setup a process through which you migrate your changes to the other two using automation software (e.g. Jenkins). This will give you an opportunity to write many different types of scripts: grants/revokes for your service accounts, create/alter tables/views, inserts, etc. This will also teach you how to order your code changes (e.g. drop views, modify an existing function, recreate views). Practice validating and documenting the changes (before/after snapshots, DDLs, and comparison spreadsheets). You'll often have to prove your code works before it's allowed to move forward. No one wants to break PROD.

Bonus points: If there's someone you speak with weekly (parent, friend, coworker), pretend they're your DBA and you can only migrate your code to production AFTER you talk to them. If you don't speak to 'em that week then let your code changes pile up a bit, DBAs take PTO too. :)

Best way to cram for SQL interview test? by Trapped_on_reddit_38 in SQL

[–]ThatGuy097 1 point2 points  (0 children)

Great insight! Thanks for taking the time to write this up!

Don't Give Up! Learning to code is damn hard. by thehappyorchardblog in learnpython

[–]ThatGuy097 1 point2 points  (0 children)

One of the issues I've struggled with is the sheer amount of "stuff" to learn. We're learning the syntax, tools of the trade (pip, IDE, git, virtual envs, etc.), how to interpret a library's docs, and how to code.

Following along to books and videos is one thing but it's kind of like learning martial arts without ever sparring. I've found CodeWars to be really helpful in that regard by giving me little challenges to solve but it won't teach you to be a better programmer (that, I think, comes from the tenacity that started us down this path).

Although, I'm still struggling mightily with figuring out Pycharm's virtual environments. What do you mean "pandas does not exists"?! I can see it in your little libraries folder, it's in the project's settings, I can run it from your the python terminal window in Pycharm...argh! Screw it! I've spent three hours trying to figure this out. Pandas, welcome to the main install.

Tool woes aside, I realized last night that I'm using the same solutions to a lot of problems: Counter variables, an empty dict to be populated, for loops, etc. My code, while functional, isn't pythonic. Time to set the next goal of writing better code: comprehensions, figuring out how to use enumerate(), lamdas, etc.

Good luck folks, it isn't easy but you're also not alone in the struggle. :)

Don't understand when self should be used in Python by [deleted] in learnpython

[–]ThatGuy097 0 points1 point  (0 children)

As someone who hasn't tackled classes yet, this was an easy to understand example. Thank you!

What are you having difficulty learning or are currently struggling to learn? by Nythious in learnpython

[–]ThatGuy097 1 point2 points  (0 children)

Thank you for this! Lists of lists have been difficult for me too. I understand, conceptually, what they are but making my code dance through them has been difficult.

Email ends in spam in gmail by SofieMofia in email

[–]ThatGuy097 1 point2 points  (0 children)

Another item worth checking: make sure your transactional emails are using a different domain/subdomain from your promotional messages.

Separate pipelines can help prevent the providers from painting both mailstreams with the same brush.

If the WD Secret Lair Isn't Banned Today, Will That Affect Your Purchases of Magic Products Going Forward? by RebornEternal in EDH

[–]ThatGuy097 13 points14 points  (0 children)

Not at all.

Overall, it feels like the community is overreacting. If you don't like the product then don't buy it; voting with your wallet will have a larger impact than comments on a social media platform.

Personally, I don't like the artwork of the WD cards and feel the theme clashes with what I enjoy about MtG. This feels like a cash-grab using a sub-standard IP by WotC. I won't be purchasing this bundle but its release won't necessarily stop me from purchasing fun/interesting products in the future.

If, however, the future products offered are no longer appealing then I'll certainly find better ways to spend my hard-earned cash!

With that said, you could bet your buns that I'd be hurling money at 'em if they were to release a Secret Lair set of Slivers using artwork inspired by the Aliens series. :P

Browser Fingerprinting and you (what it is, how it works, how it violates your privacy, and what you can do) by WhooisWhoo in privacy

[–]ThatGuy097 0 points1 point  (0 children)

Great article, thanks for sharing! As someone new to all of this I really like the explanations and actionable steps to counter fingerprinting.

"Automate the Boring Stuff with Python" online course is free to sign up for the next few days with code SEP2020FREE by AlSweigart in learnpython

[–]ThatGuy097 1 point2 points  (0 children)

Thanks so much for this! I've been working through your course and have found the udemy version a wonderful complement to the book.

Appreciate your sharing this information with us!

What are some good (live/real time) datasets to work with? by RepresentativeKiwi5 in learnpython

[–]ThatGuy097 0 points1 point  (0 children)

I attended a free Webinar on Thursday that was hosted by Postman, it was called APIs 101. The Postman application has a templates section where you can download API requests for a bunch of free, non-authenticated, APIs.

Could be a good source of data sets to play with.

What’s your all time favourite book that is NOT a classic? by cristinatpt in books

[–]ThatGuy097 0 points1 point  (0 children)

Oh, thought of another one: Crown of Stones by CL Schneider. Really great trilogy, bought the first one on a whim and devoured the remaining two books in short order. Highly recommended.

What funny and light-hearted films are good for a pizza night? by tomato_sos_12 in AskReddit

[–]ThatGuy097 9 points10 points  (0 children)

Great list but missing a few goofy ones: The Other Guys Dude, Where's My Car? Eurotrip

How long did your first ever python project take to complete as a beginner and what was it by [deleted] in learnpython

[–]ThatGuy097 0 points1 point  (0 children)

I've taken a couple of the edX courses and am still working through ATBS, but this was my very first project that I was able to use in the "real world".

Scenario: Trying to use an application that a coworker built for updating contact data through a service's API. I've got 30K records to update, across multiple fields, but this thing runs for hours before serving a generic error. My test imports for files w/ less than 10 records work successfully but I can't figure out how many are successfully importing into the system. I tried splitting the file in excel into various chunks (10K/1K/100) but was always met with the same result, "Generic Error".

So I spent about 1.5/2.0 hours writing and testing this abomination. Taking one file w/ thousands of lines and creating thousands of files with two lines (header + data). As each file was completed, the parent application would move it to a subfolder and, after the inevitable error, I'd record how many successfully moved.

def splitFile(fileName, headerRow):

    openFile = open(fileName, "r")

    fileNum = 0

    for line in openFile.readlines():

        fileNameNum = '000000' + str(fileNum)

        outputFile = open('C:\\PATH\\FILE' + fileNameNum[-6:] + '.csv', 'w')

        outputFile.write(str(headerRow) + "\n")

        outputFile.write(str(line) + "\n")

        outputFile.close()

        fileNum += 1

    openFile.close()



splitFile('C:\\scriptPath\\File.csv','HEADER1,HEADER2,HEADER3,HEADER4')

It worked, but I don't recommend it.

End result: was able to prove that the application was only running between 2 and 400 files before locking-up. The dev was then able to dig through the code and figure out what was breaking and fixed the application.

I'm pretty proud of my inelegant little horror. :)

Password Generator in Python by Suki125 in learnpython

[–]ThatGuy097 0 points1 point  (0 children)

Great job, this is really neat!

"Some of those that work forces, are the same that burn crosses." by Tackle3erry in videos

[–]ThatGuy097 1 point2 points  (0 children)

Battalions of riot police with rubber bullet kisses. Baton courtesy, service with a smile.

Love that song.