Is there a tool to convert classic linked postgres tables to Anvil style? And back? Or REST API scaffolding? Or else?

[Tony.Nguyen]

@phm

Anvil is great to quickly develop UI and data together (RAD), but I wonder how it behaves when any load (more clients, more server computation, more data R/W, …) is happening since the jar is serving the client, the server and the database in the same breathe (I know I can split to use external database but is it more efficient?).

At my newbie level, in the current setup, I can’t find a way to say where the bottleneck could be and how to prevent it using cache and throttling for instance, so I tend to think of splitting services to see specific loads. But I might be wrong if, for instance, a REST implementation is too heavy on the server.

Here is my answer:

Django or Anvil? Which One Should I Pick?

If you go to django, flask, laravel, expressjs, hapijs… forum and ask the same question you will get the same answer, the framework of that forum. So, I try to give an unbiased answer. In terms of dev time, nothing beat Anvil. Also, you really feel enjoyable when working with Anvil as well, it just works. But there are few things to be considered. The cloud IDE, which is awesome, is the only place to code. While you can find some way to code without it, it is quite tricky. The cloud host Anv…

==============

The other point is about the database structure itself: How to keep a transferable database to be used by other services? I.E. a postgres database with named tables and FKs.
Once the DB goes the Anvil way (app_storage_tables, app_storage_data) and evolves on it, is there a way to get it back to named tables? and serve them from Anvil? Wit on-the-fly transformation from Anvil to “static postgres”?

I treat my CVS files some kind of noSQL database

=====
@stefano.menci thanks for the info