Let's talk about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

I'm working on revisions to Python 3 Object-Oriented Programming. Meanwhile, I have big news on Packt's end-of-year promotions.

I’m always striving to make the knowledge in Python Real-World Projects, as useful as possible. That’s why I’m so excited about Packt’s $9.99 End-of-Year Sale! This adds …

Starting back in 2011 I was working on a way to manage a variety of spreadsheets in a variety of layouts with a common schema. Over the last 13 years, I've been updating and maintaining this little project. It's not widely used, but it interests me.

Fundamentally, the use of …

Big Announcement: the 2024.8 version of Unlearning SQL, and the 2024.9 version of Pivot to Python are available from booksellers online. Both are revised and all the code tested with Python 3.12.

Book (pre) Announcement:

• KDP - See https://www.amazon.com/stores/Steven-Lott/author/B00HNRSLEK for my author's page.

  https://www.amazon.com/Unlearning-SQL-hammer-every-problem-ebook/dp/B0DDMFMXNW is the book.

• Google Play - See https://play.google.com/store/books/details?id=23WAEAAAQBAJ. Be sure to get the 2024.08 edition; there's a previous …

See https://github.com/slott56/py-web-tool

And https://pypi.org/project/py-web-lp/

I finally made the PyWeb LP tool installable from PyPI.

I need to fix the name of the GitHub repo (some day) to make it also say py-web-lp. I should also fixup my tag cloud to say pyweblp …

This was a surprising thing (for me) to see. Surprising because -- after writing a book about functional programming, I'd forgotten that some of the ideas are actually really new to people.

(I've omitted the source of the quote because I want to reuse this without worrying about link rot. Some …

Central to OO design is "encapsulation." It's so central it is part of several separate principles.

In the S. O. L. I. D. design principles it's the Interface Segregation Principle. And a significant part of the Single Responsibility Principle.

In some cases, Python n00bz -- folks who already know some OO …

Let's reach way, way back. 1989 - 1990. This will let me talk about OO programming and Python Type Hints. (really) And doing OO design for things that are as pervasive (and transparent) as air. Things that need to be part of a design, but don't appear in any documentation.

In …

The question was "Favorite Design Patterns."

This is tricky because -- well -- so many patterns appear and re-appear in software. Picking a few from the vast world of patterns is fraught with difficulties.

Here are some thoughts:

• Code Quality - Which Implementation is "Better"?
• State-Based Object Modeling
• Functional Programming and Finite State …