On Thu, Jun 8, 2023 at 10:22 PM Nim Li wrote:
> I wonder if anyone in the community has gone through changes like this? I
> mean ... moving the business logics from PL/SQL within the database to the
> codes in NestJS framework, and reply on only the TypeORM to manage the
> update of the
Hi Nim,
well this is a very particular scenario.
In a few words, these projects will never go live for production purposes,
but just to verify some hypotheses.
In this case, could be acceptable to generate schema on the fly, but isn't
easy to automatize each aspect related to optimization
You're gonna lock yourself into SOMETHING, that's why there are still
thousands of COBOL programs still being maintained.
Mike Nolan
On Fri, Jun 9, 2023 at 3:39 PM Ron wrote:
>
> You can be sure that banks and academic research projects have different
> needs. Heck, your University's class
On 6/9/23 11:36, Nim Li wrote:
Hello,
Thank you so so much for all the feedback so far. :D
About this comment:
> "... an application that requires changing the data model does not
seem to be well designed...don't allow model change by the business
logic..."
I work in a science research
People change applications and programming languages all the time.
But change the database? Particularly away from Postgres, which is for nearly
any purpose clearly the best SQL database available?
You have to pick one. Heck, write your triggers and stored procedures in Python
and you can
You can be sure that banks and academic research projects have different
needs. Heck, your University's class scheduling software has different
needs from the research problems that you support.
The bottom line is that putting all of the "business" logic in TypeORM
*locks you into* using an
Hello,
Thank you so so much for all the feedback so far. :D
About this comment:
> "... an application that requires changing the data model does not seem
to be well designed...don't allow model change by the business logic..."
I work in a science research faculity. When researchers start a
Uhm me need to start form 2 concepts:
1. competence
2. Network lag
Competence: usually programmers aren't skilled enough about the
architectures and the actual needs of each layer.
This is a problem, because often programmers try to do something with what
he already know (e.g. perform join
Clearly I'm a 73 year old dinosaur, because I believe in having the
business logic in the database wherever possible. But the development
projects I've been around lately aren't using triggers at all. (And
it should not surprise anyone, certainly not me, that consistency of
data enforcement is
> On Jun 8, 2023, at 8:21 PM, Nim Li wrote:
>
> Hello.
>
> We have a PostgreSQL database with many tables, as well as foreign table,
> dblink, triggers, functions, indexes, etc, for managing the business logics
> of the data within the database. We also have a custom table for the purpose
Hello.
We have a PostgreSQL database with many tables, as well as foreign table,
dblink, triggers, functions, indexes, etc, for managing the business logics
of the data within the database. We also have a custom table for the
purpose of tracking the slowly changing dimensions (type 2).
11 matches
Mail list logo
