Hi Karl,
Alternate databases is an interesting topic.
I wouldn't necessarily recommend replacing DB2 for applications, but here's something I've done that works better together with RPG & Opensource.
For example:
-Let's say you're creating a new mobile app.
-That app needs to be offline part of the time
-How to cache data for the app ?
-One approach is to read DB2 data and place in to a SQLite database in the IFS. (In my case I did it with Python)
-Then the file gets distributed to any mobile device for offline usage.
-When data comes back to IBMi it can either be posted to a web service or the file itself could be posted and then read from an RPG app calling a Python script to read the SQLite database.
Anyway I'm certainly not an advocate for replacing DB2, but I know if I was writing a new document management or workflow product today I would definitely be considering NoSql for its flexibility.
For that matter SQLite is a really flexible file based database, just not for super high scale apps.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 4
date: Sat, 5 Mar 2022 09:28:54 +0100
from: "LOGIC IT: Karl FRITZ" <k.fritz@xxxxxxxx>
subject: AW: Calendar entry generator
Richard,
I agree with you in most cases, but from this perspective we should've talk about the database as well.
Why using thousands of entities and views, when I can solve a complex database with a nosql db much easier and more modern?
An then, ultimate question: Why should customers still use an IBM i?
It's not the topic I know, but I thought I should mention it.
Karl
-----Urspr?ngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] Im Auftrag von Richard Schoen
Gesendet: Samstag, 5. M?rz 2022 00:14
An: rpg400-l@xxxxxxxxxxxxxxxxxx
Betreff: Re: Calendar entry generator
Nothing against your tools, but much of the functionality you provide and I used to provide is drop dead simple to implement in open source languages.
Then any open source dev or open minded RPG dev can maintain those apps or APIs. And they integrate nicely to RPG/CL.
Of course you offer the comfort of support for your apps which is often important.
There's definitely value in RPG based apps, but I don't relish my years of having to hammer together odd code structures in RPG, CL and C to get complex things done when I could have used Python, Node, Java or PHP to do some of those things easier with the plethora of integration samples available.
It's all a matter of perspective.
But I respect yours and Jon's position.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 3
date: Fri, 4 Mar 2022 15:18:42 -0600
from: Brad Stone <bvstone@xxxxxxxxx>
subject: Re: Calendar entry generator
On Mar 4, 2022, at 1:04 PM, Richard Schoen
<richard@xxxxxxxxxxxxxxxxx>
wrote:
I'm much less fond of using RPG directly these days to do stuff that
is
better suited to the opensource APIs such as:
-Web service calls
-Spreadsheet exports
-Data importing
-Sending email
-Receiving email
-Interacting with Office365
etc.
Most of these are available to RPG ILE... And I'm adding things all the time when customers request specific interfaces to Google or Office 365 (or other platforms).
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
------------------------------
Subject: Digest Footer
--
This is the RPG programming on IBM i (RPG400-L) digest list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com
------------------------------
End of RPG400-L Digest, Vol 21, Issue 81
****************************************
midrange.com
