~pycoders | Bookmarks (455)

How to Debug Your Textual Application Textual is a great Python package for creating a lightweight, powerful, text-based user interface. Debugging TUIs can be a challenge though as you no longer can use print() and the application may not even run in your IDE’s terminal interface. This post talks about how to debug a TUI. MIKE DRISCOLL

Reactive Notebooks and Deployable Web Apps in Python What are common issues with using notebooks for Python development? How do you know the current state, share reproducible results, or create interactive applications? This week on the show, we speak with Akshay Agrawal about the open-source reactive marimo notebook for Python. REAL PYTHON podcast

Demystifying ODBC With Python Open Database Connectivity (ODBC) is used to connect to various databases. This article aims to help you understand ODBC better by implementing database communications from scratch only using Python. PRESTON BLACKBURN • Shared by Preston Blackburn

What the PSF Conduct WG Does In the past week Brett has had two different people tell him what the PSF Conduct Working Group did, and both were wrong. This post tries to correct what might be common misconceptions. BRETT CANNON

Speeding Up Data Retrieval From PostgreSQL With Psycopg Formatting and concatenating query result columns on the PostgreSQL side and then parsing them in Python might sometimes be faster than fetching the columns as separate values. ALIAKSEI YALETSKI • Shared by Tiendil

Django Application Performance Optimization Checklist “Improve the performance of your Django application by understanding, testing, and implementing some common optimization techniques.” SANKET RAI

Managing Dependencies With Python Poetry Learn how Python Poetry can help you start new projects, maintain existing ones, and master dependency management. REAL PYTHON course

Avoid Counting in Django Pagination Django’s Paginator class separates data into chunks to display pages of results. By default, underneath it uses a SQL COUNT(*) call which for large amounts of data can be expensive. This article shows you how to get around that. NIK TOMAZIC

Working With TOML and Python TOML is a configuration file format that’s becoming increasingly popular in the Python community. In this video course, you’ll learn the syntax of TOML and explore how you can work with TOML files in your own projects. REAL PYTHON course

Categories of Leadership on Technical Teams Understanding the different types of technical leadership can help you better structure teams and define roles and responsibilities. This post talks about the various types of technical leaders you might encounter. BEN KUHN

Quick Prototyping With Sqlite3 Python’s sqlite3 bindings makes it a great tool for quick prototyping while you’re working out what it is exactly that you’re building and what kind of database schema makes sense. JUHA-MATTI SANTALA

Django Performance and Optimization “This document provides an overview of techniques and tools that can help get your Django code running more efficiently - faster, and using fewer system resources.” DJANGO SOFTWARE FOUNDATION

Python Dependency Management Is a Dumpster Fire Managing dependencies in Python can be a bit of a challenge. This deep dive article shows you all the problems and how the problems are mitigated if not solved. NIELS CAUTAERTS

Under the Microscope: Ecco the Dolphin This article shows the use of Ghidra and Python to reverse engineer the encoding scheme of the Sega Dreamcast game Eccho the Dolphin. 32BITS

Threads Beat Async/Await Further musings about async & await and why Armin thinks virtual threads are a better model. ARMIN RONACHER