3 ms·
As one of the dozens and dozens of people that not only do CRUD for life but kind of like it: Is almost 94% automated. The name of the tools: Relational Datab
by mamcx 9y ago
As one of the dozens and dozens of people that not only do CRUD for life but kind of like it:
Is almost 94% automated.
The name of the tools: Relational Database System.
You need to "just" describe the data, relations, queries and perform the input of the rows. It automagically give the results you want, and kind of fast most of time!
---
The "Why?" CAN"T BE fully automated (or close to 100%):
How many program you can fit in this description?:
Create
Read
Update
Delete
Like, all of them? (given or taken a few dozen???)
---
The "HOW" we could actually do CRUD more nicely?
You must put aside the OOP model. It could be there, but aside.
The functional neither is. Nor lisp, haskell, or anyyhing similar.
You need a truly relational language (remember how a RDBMS is the answer to your question?).
Probably need to plug a actually nice Tree-manipulator language (exist a relational model, but for trees???). OO is almost there, but not close enough.
You can mix OO and anything else.
This is not a pipe dream or untested. The dbase family operate like this. I code for work in FoxPro and was FAR better than Python, Delphi, .NET(F#) (all I like, but HELL NOT, THEM ARE NOT GOOD DATA LANGUAGES)
The other side of the equation is the form/report builder.
Let me tell you: You ACTUALLY NOT WANT A (auto) FORM BUILDER.
You need a FORM BUILDER DESCRIPTOR and the flexibility of build your UI manually based on this.
THis is not speculation or untested. This was (almost) how FoxPro operate... the descriptor was tables. The tables were used to build the UI. Literally the UI was serialized on tables. Like how cool kids this days use JSON. But potentially better if you discover this (ie: Open the form file and see is just a table!) and then use this for the full effect.
Obviously, FoxPro and other tools were rough like you can expect for "ancient" tech. But similar how Lisp, SmallTalk, APL, Rebol, Pascal, Modula, ML were "rough" and we are rediscovering the potential them have, this is the same with the dBase family.