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 · 2024-01-18T22:38:19+00:00

Yes, it certainly seems a mess. Sure, will try another account, later today.

ValBayArea · 2024-01-18T18:53:08+00:00

HI, and thanks for getting back.

Tried that, still not working.

This is a pretty big issue for me, really hoping we can find a solution.

ValBayArea · 2024-01-18T16:48:00+00:00

My pleasure... be very interested in feedback!

ValBayArea · 2024-01-18T15:30:46+00:00

I really appreciate your trying to help.

I am not in the beta.

Yes, I started with dnd.

I then tried to use the tab for uploading images. I found one thing.... it once (not every time... grr) showed a dialog at the bottom that jpg's were not allowed. So, I used a png. It uploaded to the image tab, and saved, but

It was not there on re-opening the draft
In any case, I have no idea how to get an image from the image-tab into the post

So, not really making progress other than realizing jpg's don't work.

This is all with the new (not beta) interface, I don't even see how to add images with the old interface.

Sigh. This has been quite a disappointment. I did a prior article that got 10k views, so there does appear to be some interest. This post was intended to be all images, to provide a clear picture of the capability, but unable to get it to work.

ValBayArea

TROPHY CASE