What's up in the python and tech environment? - Issue #109
Welcome to issue #109 of What’s up in the Python and tech environment?
This newsletter is mainly intended for developers and those passionate about computers.
This week we will discuss Django, ORM, Cloudflare open-source network library, SQL, Fly Kubernetes, and more! 🤓
From the Python world
The White House (USA) published a report on memory-safe programming languages to use. And guess, what is the only dynamic programming language listed? Python of course! 😎
White House recommends use of memory-safe languages like Python
A nice project similar to MicroPython, a lightweight version of the Python programming language targeting embedded devices.
A deep dive into the prefetch_related
concept in Django ORM.
In this article, you will learn three ways to interact with (relational) databases in Python.
Python — 3 Ways to Work with Databases (SQL, ORM, Query Builder)
Django users switching to SQLAlchemy will be interested in this article where some of the main differences are explored.
A good introduction to Django sessions.
An interesting article that reminds us not always to believe benchmarks, especially those comparing GPU and CPU performance of some libraries. It also explores cost constraints.
Beware of misleading GPU vs CPU benchmarks
In this blog post, the author shows how numpy arrays differ from classic Python lists.
Why Can't I Just Use A List? • Understanding NumPy's `ndarray` (A NumPy for Numpties article)
A nice guide explaining the request lifecycle in Flask.
How Are Requests Processed in Flask?
Here are different ways to read Excel files in Python.
Fastest Way to Read Excel in Python
From the Web
The developer team at Cloudflare, a leader in Content Delivery Network, shared their work on a network library written in Rust.
Open sourcing Pingora: our Rust framework for building programmable network services
StackOverflow and Google Cloud announced a partnership to include Gemini features in StackOverflow and allow Google Cloud to use their data. What do you think?
In this article, you will learn some advantages modern IDEs bring to the developer and discover an AI plugin by StackOverflow for Visual Studio Code at the end of the article.
IDEs and the developer workflow – Stack Overflow’s Industry Guide to AI
Fly, a leading Platform-As-A-Service (PAAS) announced support for managed Kubernetes in beta.
A developer shares his experience with Electron and Tauri to build desktop applications and explains why he chose Tauri.
Why I chose Tauri instead of Electron
A little reminder of the order of query execution in SQL.
SQL — order of query execution
For those involved in Bash scripting, here are some tips and tricks for you 🙂
6 Bash Scripting Tips and Tricks
For the brave, here is a technical article explaining how to optimize the SQL query plan for those developing or maintaining databases.
What I Talk About When I Talk About Query Optimizer (Part 1): IR Design
Here is a deep dive into BigQuery SQL query plan.
I spent 4 hours figuring out how BigQuery executes the SQL query internally. Here’s what I found
Bonus
Here is a satirical article against Single-Page Applications. It made me laugh hard, to be honest. 🤣
What Is A Single-page Application?
To start the week well I am sharing with you the following picture.
This is all for this week. I hope you enjoy it and if that is the case, don’t hesitate to share it on your social media.
Take care of yourself and see you soon! 🙂