A co-worker developed for the Object Rexx language a Persistence class architecture to remove writing of SQL queries from code we were developing and build the appropriate SQL on-the-fly.
It was built as an abstract class, and required a subclass to be created where the wiring of fields / datatypes took place, and nothing further.
I contributed to the effort the ability to join multiple tables together introducing JOIN statements to their architecture.
I am poised to start developing a client / server app with a MS SQL Server 2008 back-end and looks to be involving roughly 50 tables. Being new to Pascal, I do not think I can justify going off and creating a Persistence class architecture on my own.
Does something similar already exist for use with Lazarus?
I am thinking to at least ask… back in 2005 I envisioned a client/server Object Rexx RAD environment… barrowing RAD design from Borland’s Delphi, cross platform, OSS/FS. Unfortunately Object Rexx is still not ready enough… progress has been made in the language, but according to one core developer, “still not ready yet.”
Lazarus looks to me like a good realization of that vision. So setting off to learn Pascal.
P.S. It made use of Object Rexx's ability to dynamical create methods in classes on-the-fly. Getters / setters were defined on-the-fly perfectly matching up to the schema defined in the subclass to the abstract Persistence class.
It was also making use of Rexx’s
interpret silver-bullet keyword… to build Rexx code on-the-fly and then execute it.