× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



If you really want to do all of those things, you may want to take a look at ORM's (Note: this is not an RPG thing but is a tool used by most other languages like Java/C#).

The only language I know of that has brought ORM methodology to the "next level" though is .NET as they have LINQ (Language Integrated Query) which allows you to query any object as if it was a SQL table using familiar constructs.

This is just a short example of linq: https://mathewrphillips.wordpress.com/2012/02/17/why-linq-is-awesome/

A recent project we did, where by we removed all SQL querys and instead transferred it an ORM and utilize LINQ reduced our C# code base for that one project by 34.5%! We now do not have a single line of SQL code in those programs as the ORM generates all the SQL querys on the fly based off of your data model that you define once, and can reuse everywhere. That is developer productivity! Want to change your model? OK, when you do you will get compile time checking of every LINQ query and it will tell you if anything is wrong BEFORE you run your program. How many times did you put a typo in your embedded SQL in RPG? That is a thing of the past with ORM's.

NOTE: You do loose a bit of performance, but it is negligible. For the millions you will save in consultant / developer hours you can buy those new shiny SSD's you've always been wanting to make up the performance drawback.

-----Original Message-----
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Friday, September 15, 2017 2:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Database I/O Modernization

On Fri, Sep 15, 2017 at 12:51 PM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

May I remind you about the topic, we are discussing: "Database I/O
Modernization"!!! It was your choice, not mine. RLA might be the right
tool for some job (I suspect it is) but it is by far not the right
tool for Database modernisation!!!


Different people will have different definitions for "modernization". My definition would include anything that improves applications. The improvement may come in the form of better performance, more programmer productivity, making applications more adaptable to change, improving the modularity or readability of code.

You shouldn't exclude RLA from modernization.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.