I have a preliminary reaction to py4web, which I've been kicking py4web around for the last couple of weeks. A few years back, I had wanted to use web2py but did not have a project for it. Then a couple of months back, our company needed a CRUD app for manufacturing statistics, so I thought I would use a no code/low code platform.
I looked at every open source solution I could find because I'd been trapped by proprietary solutions before. I looked at: nocodb, saltcorn, budibase, baserow, tooljet, django, etc. Many were actually freemium apps, so we moved on. They are all much bigger platforms than py4web, and you can do a lot as long as you have, one or two table-at-time needs. Where they all fall down is when you need to do more complicated joins, or subsets via a sub-select or where clause.
To me, this means that they are good for simple data models, and if you don't mind all the pointing and clicking that their UIs require. But the more complex models become very hard or impossible to do without figuring out how to bypass their database abstraction layers. i.e., simple things are simple, complex things are very hard or impossible to do.
In a complex manufacturing environment where needs change or evolve, relational databases allow for growth and exploratory data modeling as long as the model is fully normalized. New needs will call for new tables of some kind, and getting what you need later is mostly a question of joining more tables and writing the correct queries. This is where the no code and low code platforms don't do so well, but web2py/py4web do.
py4web is quite small and unobtrusive so that it is relatively easy to guess what is going on. The pyDAL database abstraction layer isn't an ORM, and allows one to write raw SQL, which is a huge plus when it comes to exploratory work.
Getting started with py4web is slow due to the lack of exhaustive documentation. There are some decent examples and tutorials from Massimo himself, Luca de Alfaro, Jim Steil, and others. You'll need their supplementary material for sure.
Anyway, just my thoughts. Thank you to Massimo, Luca, Jim, and others for this very nice platform and tutorials.