Issue #409

Django SQL Vulnerability, PEP 584 Got Merged, Python in Production, and More

Feb. 25, 2020

Django SQL Vulnerability, PEP 584 Got Merged, Python in Production, and More
#409 – FEBRUARY 25, 2020 VIEW IN BROWSER
The PyCoder’s Weekly Logo
Analysing NBA Assists: How to Visualize Hidden Relationships in Data With Python
Using basketball as the background setting, the author discusses several different strategies for uncovering relationships and producing beautiful visualizations with Python.
JP HWANG

PyCon US 2020 Packaging Summit: Registration and Topic Proposal
Registration is open for the PyCon US 2020 Packaging Summit. Topic proposals are also being accepted. Both registration and topic proposals close on March 7, 2020.
PYTHON.ORG

Python Developers Are in Demand on Vettery
Vettery is an online hiring marketplace that’s changing the way people hire and get hired. Ready for a bold career move? Make a free profile, name your salary, and connect with hiring managers from top employers today →
VETTERYsponsor

Django Security Vulnerability: CVE-2020-7471
Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows SQL Injection if untrusted data is used as a StringAgg delimiter (e.g., in Django applications that offer downloads of data as a series of rows with a user-specified column delimiter).
MITRE.ORG

Working With PDFs in Python
In this step-by-step course, you’ll learn how to work with a PDF in Python. You’ll see how to extract metadata from preexisting PDF files. You’ll also learn how to merge, split, watermark, and rotate pages in PDFs using Python and the PyPDF2 library.
REAL PYTHON video

Python in Production
Hynek Schlawack feels that discussions of Python web applications in production are missing from Python conferences. He is offering to mentor people who are interested in proposing conference talks on the subject
HYNEK SCHLAWACK

Null in Python: Understanding Python’s NoneType Object
Learn about the NoneType object None, which acts as the “null” in Python. This object represents emptiness, and you can use it to mark default parameters and even show when you have no result.
REAL PYTHON

PEP 584 PR Merged (Dictionary Union)
This will add the following dictionary operations: dict1 | dict2 (copy + update) and dict1 |= dict2 (update). See PEP 584 for example use cases.
GITHUB.COM/PYTHON


Discussions


Scene From Werner Herzog’s “Programming in Python” ;-)
“I see the lie in front of me – import time, and I am appalled – how can a machine offer such a promise, such a lie, the ability to import time as if it were a simple commodity. Once again, the vile snake has bitten me.”
TWITTER.COM/MVATTUONE


Python Jobs


Senior Python/Django Software Engineer (London, UK)
ZEGO

Python Developer (Malta)
GAMING INNOVATION GROUP

Senior Python Software Engineer (London, UK)
TESSIAN

Senior Software Engineer Backend (Denver, CO)
CYBERGRX

Senior Python Software Developer (Vancouver, BC, Canada)
ABCELLERA

More Python Jobs >>>


Articles & Tutorials


Pycel: Compiling Excel Spreadsheets to Python and Making Pretty Pictures [2011]
Author describes how he compiled Excel spreadsheets with formulas into Python code in order to optimize the calculations and visualize results. Very interesting read!
DIRK GORISSEN

Better Python Tracebacks With Rich
“I’ve never found Python tracebacks to be a great debugging aid beyond telling me what the exception was, and where it occurred. In a recent update to Rich, I’ve tried to refresh the humble traceback to give enough context to diagnose errors before switching back to the editor.”
WILL MCGUGAN

Monitor Python Application Metrics and Distribute Traces in Real Time With Datadog APM
Datadog’s APM generates detailed flame graphs that will help your teams identify bottlenecks and latency. If an error is spotted, you can easily pivot to related logs and metrics in seconds to troubleshoot without switching tools or contexts. Visualize Python metrics end-to-end with a free trial →
DATADOGsponsor

Introduction to Python SQL Libraries
Learn how to connect to different database management systems by using various Python SQL libraries. You’ll interact with SQLite, MySQL, and PostgreSQL databases and perform common database queries using a Python application.
REAL PYTHON

A Brief Network Analysis of Symbolism in Blake’s Poetry
The author explains how she used the spaCy and NetworkX libraries to analyze William Blake’s 18th century poetry collection The Songs of Innocence and of Excellence.
MARTA PALANDRI

Python Packaging Metadata
“Since this topic keeps coming up, I’d like to briefly share my thoughts on Python package metadata because it’s – as always – more complex than it seems.”
HYNEK SCHLAWACK

How Python Became the Popular Choice
“With the popularity of Python with programmers still growing, we tried to understand how it became one of the most impactful languages in the world.”
JUN WU

How to Add a robots.txt to Your Django Site
robots.txt is a standard file to communicate to “robot” crawlers, such as Google’s Googlebot, which pages they should not crawl.
ADAM JOHNSON

Automate Your Dating Life With 100 Lines of Python
Author used a Python-based man-in-the-middle proxy to deconstruct network calls made by the Hinge app and then built a service to automatically “swipe right” on dating profiles.
ELI MERNIT

Learn Python for Data Science in 4 Weeks
Learn the foundational Python programming and statistics skills needed for a job in data science in as little as 4 weeks. Work 1:1 with a data science mentor to master the skills needed to get started in your journey to a data science role. Enroll in Springboard’s data science career track prep course today.
SPRINGBOARDsponsor

Managing Kindle Highlights With Python and GitHub
Author writes a Python script to build a GitHub repo for storing Kindle book highlights in an organized way.
DUARTE O.CARMO

How to Cheat at Unit Tests With Pytest and Black
Some tips for quickly writing rough initial implementations for test cases and then iterating on them.
SIMON WILLISON

Introduction to Image Processing in Python With OpenCV
MUHAMMAD JUNAID KHALID


Projects & Code


PayloadsAllTheThings: List of Useful Pentesting/CTF Payloads
GITHUB.COM/SWISSKYREPO

Carnets: Standalone Jupyter Notebooks Implementation for iOS
HOLZSCHU.GITHUB.IO

Pycel: Compile Excel Spreadsheets to Python Code & Visualize Them
GITHUB.COM/DGORISSEN

darknet.py: TOR Proxy Written in Python
GITHUB.COM/MULTIVERSECODER

dg: A Python With a Haskell Syntax
PYOS.GITHUB.IO

HiPlot: High-Dimensional Interactive Plots Made Easy
FACEBOOK.COM

Django Security: PyCharm Python Security Plugin
PYCHARM-SECURITY.READTHEDOCS.IO

DeepSpeed: Deep Learning Optimization Library
GITHUB.COM/MICROSOFT

📆🐍 Upcoming Python Events


⋅ JupyterCon 2020 August 10–14 in Berlin, Germany.

⋅ Python Vienna Meetup February 29, 2020

⋅ Python Mauritius User Group Meetup February 29, 2020

⋅ PyDelhi User Group Meetup February 29, 2020

⋅ Melbourne Python Users Group, Australia March 2, 2020
Happy Pythoning!
Copyright © 2020 PyCoder’s Weekly, All rights reserved.