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 …

The typing module includes the mysterious-looking Annotated type hint. See https://docs.python.org/3/library/typing.html#typing.Annotated for details.

What does this do?

Why do I need it?

Where can I see examples?

Here's what's great about Django coupled with the Django-REST Interface : It's almost all model. You define the model, write some tests. Add the URL mappings, write some tests using the built-in Django client.

We're almost there, but this doesn't work out perfectly. To do complete tests, we have to either …

Fundamentally, we need to provide explicit version identification on a schema. This is technically easy, but organizationally nearly impossible.

Technically, we need to use some kind of version control software for our model and the resulting DDL. We need some meta-meta-data to track schema names and version numbers. If we …

I've been asked about the proper location of Stored Procedures more than once. I've come down very strongly in opposition to triggers and stored procedures.

First, PL/SQL is slow . Anecdotally, people claim that introducing PL/SQL made an app faster. I submit that they restructured the application significantly to …

I use the word denormalization heavily, to make a point to a certain class of developers. Other developers object to the term, since it doesn't have a precise meaning.

The point I often have to make this:

1. 3rd Normal Form is for Updates.
2. Data Warehousing is about Insert and Select …

The comment was eaten by Haloscan, but here's the text...

You need to read Rozhenstein on characteristic functions.

select
sum(case when a < .5 then 1 else 0 end) 'A'
,sum(case when a >= .5 and a < .75 then 1 else 0 end) 'B'
,sum(case when a >= .75 then …

First, let me point out that the Data Cartel ("DBA" means Don't Bother Asking) won't release all the information I requested, so some of this is a guess.

We'll look at a number of dumb-as-a-post SQL techniques. This is proof -- if any were needed -- that bad SQL is worse than …

See Michael Hugos "Think about screens and the data on them to simplify system development " for some helpful insight on what an "application" really is -- access to data. Simple transparency is lifted up as a critical value for software.

I liked the "If you don't believe it could be this …