A friend in the IBM i vendor community asked me about Mapepire from a popularity and security perspective. He had read about Seiden Group’s support for the Mapepire Db2 for i driver. I have provided his questions and edited versions of my answers below.
Using a job queue or scheduler to run PHP scripts helps ensure that PHP-based processes are run successfully and on time.
To make it easy for Seiden PHP+ users to schedule jobs, we provide job scheduler or queue functionality and support with our Seiden PHP+ SmartSupport.
Benefits include the ability to:
Our 2023 article on searching source physical file members using the QShell grep command showed grep’s potential. In practice, while we found QShell grep to be flexible, we also experienced slow performance and occasional errors.
Now, our own Calvin Buckley has built an improved grep command called pfgrep to search traditional IBM i source physical file members. Quick and reliable, pfgrep is also free and open source.
A few years ago I introduced you to my QShell on i utility – QSHONI. QSHONI makes it easy for traditional CL, RPG, and COBOL programs to call Python utilities and other QShell/PASE utility programs (PHP, Node, Java, etc.) and directly use their output. QSHONI opened up a whole new world of integrations to open-source apps from traditional IBM i applications.
I keep thinking I will run out of interesting things to add to the library, but the ideas keep on flowing.
Since IBM announced Yum support for installing the IBM i Db2 ODBC driver, as documented in our 2022 tutorial, users can update their driver more easily.
To help users determine what’s changed, IBM maintains a list of fixes and enhancements for each IBM i ODBC driver release.
Although there are many reasons—including performance—to update to newer PHP releases, the number one reason is to avoid losing security updates.
Each version of PHP (7.4, 8.0, 8.1, 8.2, 8.3, etc.) has three years of support before it is considered end of life. For two years, it gets bug fixes and all security fixes. In the third year, it gets only critical security fixes. After that, nothing!
As we mentioned in our article on installing ODBC via yum, the latest IBM i open source packages require new repositories.
A notable example is Node.js v20. When we hear users say, “I don’t see Node.js v20 listed in available packages, and yum returns ‘No package nodejs20 available‘,” the reason invariably is that the new repositories, ibmi-base and ibmi-release, have not been installed.
A client asked about a vulnerability found in libwebp, which is used by PHP’s image-handling gd extension.
My first step was to find a reputable source for details. According to this trusted article about the vulnerability, the issue affected only libwebp versions 1.3.1 and earlier. I checked our own system and found we had a patched version from IBM, so we were safe. The client was, too.
Here is the procedure you can use for checking the version of this or any other open source package on IBM i. Read more →
From the Seiden SmartSupport mailbag:
One issue I keep coming across is the inability to search for text in source members across all libraries. We use a commercial tool, but it is expensive and cumbersome. Coming from the Linux world, where I can “grep” for anything, I find this a ridiculous restriction.
On December 5, 2023, Alan joins fellow IBM Champions Koen Decorte and Charles Guarino at IBM France for a day-long seminar and networking event focused on IBM i modernization, AI, Business Intelligence (BI), and cyber resilience.
Sponsored by IBM and CD-Invest, the seminar agenda balances educational sessions with opportunities to ask questions and have informal discussions with the presenters and fellow attendees.