Generally, I try to frown on Domain-Specific Languages. Often, a tidy set of related functions, or a group of class definitions with a few decorators can create something that's every bit as expressive as a DSL in native Python syntax.

There are a few cases where a DSL can be …

Recently, we talked about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book. This is a description of what comes next after the "low-level" conversion. Warning: it's complicated.

BLUF: Take the time to get rid of SQL processing.

We're talking about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

We're talking about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

We're talking about extracting data from complex relational databases. This is -- in a way -- another case study for my Unlearning SQL book.

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

In the process of writing Unlearning SQL, I had a need to extract SQL blocks from Python programs. Of course, I tried grep. It wasn't ideal.

Modern Python Cookbook — with lots and lots of recipes — is something you might need. Find the results of checking all these recipes here: https://www.amazon.com/Modern-Python-Cookbook-updated-techniques/dp/1835466389

I (reluctantly) switched from using mypy to using pyright to check all of these recipes carefully. The type alias (PEP …

Book Announcement:

https://www.packtpub.com/en-us/product/modern-python-cookbook-9781835466384

There are about 130 recipes in here. Some new. Some revised. All examined (and tested) for Python 3.12.

For the Python folks who are just starting as well as those looking to pick up some more skills, this is for …

See Synthetic Data.

I've updated the repository with a "Noisy Data" feature.

This will generate bulk data with invalid field values.

It helps with testing ETL pipelines to be sure they will scale to the expected volumes.

Clone https://github.com/slott56/DataSynthTool

Read https://slott56.github.io/DataSynthTool/_build …