Issue #450

ORMs, Numerical Precision, PyQt and SQL, and More

Dec. 8, 2020

ORMs, Numerical Precision, PyQt and SQL, and More
#450 – DECEMBER 8, 2020 VIEW IN BROWSER
The PyCoder’s Weekly Logo
Why Should You Use an ORM (Object Relational Mapper)?
Budding web developers learning Model-View-Controller frameworks are taught that they should use an Object Relational Mapper (ORM) to interface with their databases. But the “why” is often brushed aside or omitted entirely, leaving a fledgling programmer with burning questions like ”What are ORMs, anyway?” and “What problems do they solve?”
KARIM MARZOUQ • Shared by Karim Marzouq

Does Reducing Numerical Precision in Python Affect Real World Datasets?
Reducing numerical precision is a way to save memory in pandas, but does it make a difference to the conclusions that we might draw from real-world datasets?
MARTIN JONES • Shared by Martin Jones

Spend Less Time Debugging, and More Time Building With Scout APM
Scout APM uses tracing logic that ties bottlenecks to source code to give you the performance insights you need in less than 4 minutes! Start your free 14-day trial today and Scout will donate $5 to the OSS of your choice when you deploy →
SCOUT APMsponsor

Handling SQL Databases With PyQt: The Basics
In this step-by-step tutorial, you’ll learn how to use PyQt’s built-in SQL support to create GUI applications that effectively manage SQL databases.
REAL PYTHON

Make Printed Links Clickable Using the TensorFlow 2 Object Detection API
Learn how to turn your phone’s camera into a link detector on printed media using Tensor Flow 2’s Object Detection API.
OLEKSII TREKHLEB


Discussions


What Do You Automate With Python at Home?
A good mix of genius, boredom, and absurdity
REDDIT

What Is the Longest Piece of Code You Can Write to Print “Hello World” on the Terminal?
An inspiring thread of how not to write code
REDDIT


Python Jobs


Advanced Python Engineer
RESEARCH AFFILIATES 📍 NEWPORT BEACH, CA, USA

Python Developer / Software Engineer
THERMONDO GMBH 📍 BERLIN, GERMANY

Sr. Engineer II
CROWDSTRIKE 📍 SUNNYVALE, CA, USA

Software Developer Lead
PNC FINANCIAL SERVICES GROUP 📍 PITTSBURGH, PA, USA

More Python Jobs >>>


Articles & Tutorials


Real Python’s Office Hours: Learn With Python Experts in Real Time
Come learn with Python experts at the Real Python Office Hours, a weekly video call that offers Real Python members the chance to get help with Python-related questions, meet new Pythonistas, learn about new and trending topics in the community, and get feedback and tips on Python code and projects.
REAL PYTHON

How To Set Up Tailwind CSS In Django On Heroku
Have a Django app on Heroku and want to use Tailwind CSS? In this tutorial, you’ll see how to configure Tailwind for a Django project and set up Heroku to build your CSS file.
MATT LAYMAN • Shared by Matt Layman

How to Build a Full Stack Vehicle Sharing App in Python With SQLAlchemy ORM
In this Free Course For Python Developers, you’ll build a full stack vehicle sharing app in Python using SQLAlchemy and CockroachDB. You’ll gain experience deploying clusters, designing schema, performing transactions, and optimizing queries for fast performance →
COCKROACH LABSsponsor

Looping With enumerate() and Python GUIs With PyQt
If you’re coming to Python from a different language, you may not know about a useful tool for working with loops, Python’s built-in enumerate function. This week on the show, David Amos is here, and he has brought another batch of PyCoder’s Weekly articles and projects. Along with the Real Python article covering the details of the enumerate function, we also talk about another article about constructing Python graphical user interface elements in PyQt.
REAL PYTHON podcast

Announcing the Atheris Python Fuzzer
Get started with fuzzing, a technique for automatically finding bugs in Python code by repeatedly trying various inputs to your program, using Google’s newly open-sourced Python fuzzer called Atheris.
IAN ELDRED PUDNEY

Storing a list in an int
For a fun exercise, learn how you can leverage Python’s unlimited integer precision to encode and store lists of any size as a single integer. Because, why not?
IAN TAYLER

Profile, Understand & Optimize Code Performance
You can’t improve what you can’t measure. Install in minutes. Profile and understand code behavior and performance (Wall-time, I/O, CPU, HTTP requests, SQL queries). Browse through appealing graphs. Supports all Python versions.
BLACKFIREsponsor

Reproducible Builds with Bazel
Learn how to identify sources of non-determinism in your project and to use Bazel to create reproducible, hermetic builds with Python.
GASPARE VITTA • Shared by Gaspare Vitta

High-Throughput Game Message Server With Python Websockets
Learn how to create a message server using the Python WebSockets library capable of handling over 12,000 messages per second.
EDAQA MORTORAY

Building a Markov-Chain IRC Bot With Python and Redis
Looking for a fun project to tackle? Learn how to build an IRC bot!
CHARLES LEIFER


Projects & Code


Brought to you by Real Python for Teamssponsor
Online Python training created by a community of experts. Give your team the real-world Python skills they need to succeed →

bodywork-core: ML-Ops Framework
GITHUB.COM/BODYWORK-ML

atheris: Python Fuzzing Framework
GITHUB.COM/GOOGLE

PyTCP: Functional TCP/IP Stack in Python
GITHUB.COM/CCIE18643

Skybolt: Rendering Engine and Aerospace Simulation Tools
GITHUB.COM/PIRAXUS

irc: A Made-From-Scratch Irc Library in Python
GITHUB.COM/COLEIFER

📆🐍 Upcoming Python Events


Real Python Office Hours (Virtual)
December 9, 2020

PyCode Conference 2020 (Online)
December 11 to December 13, 2020

PyCon Tanzania 2020
December 14 to December 16, 2020
Happy Pythoning!
Copyright © 2020 PyCoder’s Weekly, All rights reserved.