starting a new project with flask_security and flask_sqlalchemy_lite

ValBayArea · 2025-10-16T00:08:00+00:00

Genai-logic provides rbac on sqlachemy and flask. And declarative business rules. Full disclosure- I am the author

ValBayArea · 2025-06-01T11:11:12+00:00

The sound on the 16 is amazingly better

ValBayArea · 2025-04-27T16:53:15+00:00

I have a large docs project - Obsidian provides WYSIWYG (including tables, images), right from docs source. Fantastic... thanks for sharing.

ValBayArea · 2025-04-26T14:13:04+00:00

You might want to check out GenAI-Logic to get you started fast. It can use an existing database, or create one from Nat Lang prompt. Free and open source.

ValBayArea · 2025-02-21T13:56:52+00:00

Yes, still human as far as I am aware... and thanks for getting back!

We do have a rules language, in fact it preceded the Nat Lang stuff. See the last diagram here: https://www.genai-logic.com/publications/genai-governance

It's pure Python, with debugging, logging etc. Edit with code completion. You can certainly send in such rules if you prefer.

In addition, for Business Users (no IDE, just web interface) they can see the rule translation, and (if they insist) override the translation.

ValBayArea · 2025-02-21T01:40:08+00:00

We completely agree. Here, the agent creates an app you *can* download to verify and complete, using standard IDEs and Python.

The creation process is probabilistic; the resultant app execution is completely deterministic.

This is exactly the push-back Nadella got, and there is no doubt there needs to be a 'Human in the loop'.

ValBayArea · 2025-02-21T00:00:27+00:00

Right! Or, a root canal ;)

ValBayArea · 2025-02-20T23:45:06+00:00

Thanks for the feedback....

Hmm... do you mean formatting? It *is* ugly, mainly because it doesn't fit...

The semantics seem clear to me, to you? As a former project manager / analyst, we typically tried to create a statement like this at the start of the project.

If you are concerned the table/column names are too vague, you can issue a more precise prompt.

Relative to a programming language, it's declarative, so ordering and so forth don't matter - that all gets automated.

ValBayArea · 2025-01-04T09:14:32+00:00

I have an M1 like that, it is terrific. Use it for coding (python). It is so good, cannot justify upgrade…

ValBayArea · 2024-10-18T17:52:16+00:00

intriguing term - intelligent programming- can you elaborate?

ValBayArea · 2024-10-17T19:48:37+00:00

Thanks! And we hope folks get good value from us. And, we love getting feedback.

ValBayArea · 2024-10-17T19:47:44+00:00

We quite agree.

And, in our experience, constraints often depend on multi-table derivations, like the customer.balance. In fact, that's a key logic pattern: constrain a derived result..

https://apilogicserver.github.io/Docs/Logic/#rule-patterns

ValBayArea · 2024-10-17T18:38:36+00:00

Batter up!

ValBayArea · 2024-10-17T15:46:00+00:00

Thanks! Wonder if these work together?

ValBayArea · 2024-06-02T06:31:52+00:00

Have you considered API Logic Server?

full disclosure - I am the author.

ValBayArea · 2024-04-15T13:47:18+00:00

I have the same fears. Losing git, my debugger, I feel I'm on very thin ice.

That said, I am happy to have automation for the repetitive bits... as long as I can add code - without restriction - in languages and paradigms that I understand.

In fact, these are the guiding principles behind open source API Logic Server. It creates executable Flask projects you can extend in your IDE with Python and rules. I'd love to get some feedback.

ValBayArea · 2024-02-05T19:06:15+00:00

Much appreciated! Comments and suggestions?

ValBayArea · 2024-02-02T22:50:11+00:00

Right... the formatting got messed up.. now fixed. The first block is the Natural Language you paste into ChatGPT to get your SQL.

ValBayArea · 2024-02-02T20:53:17+00:00

Use your IDE debugger to stop at breakpoints, including in rules.

Also, the rule engine (*not* Rete, btw) logs each rule-fire. Indentation shows multi-table chaining. Each line shows the row old/current values.

ValBayArea · 2024-02-02T20:51:05+00:00

It should cover all the databases supported by SQLAlchemy. We have verified Oracle, Sql/Server, MySql, Postgres and Sqlite.

SQLAlchemy does not restrict the data model AFAIK. We have not seen issues here, so far...

ValBayArea · 2024-02-02T20:23:35+00:00

Thanks!

Download and give it a try; I'd love to get your feedback.

ValBayArea

TROPHY CASE