Sessions - Open Source

2019 Sessions will include:
  • Using Db2 and SQL with Open Source Languages on IBM i 
  • Open Source Programming Languages on IBM i 
  • Openi – Exploring Open Source Solutions on IBM i 
  • Introducing Node.js on IBM i 
  • Turn On the LAMP – please! 
  • Oh C.R.U.D. (Create, Read, Update, Delete)





Using Db2 and SQL with Open Source Languages on IBM i (Alan Seiden)


Db2’s ever-expanding capabilities can simplify development in open source languages such as PHP, Ruby, Node.js, and Python. These languages, known for their ease in building web and mobile applications, can run most types of SQL, but why complicate them with repetitive database code that distracts from their power and simplicity?


This talk shows examples of how to reduce tedious coding by using such Db2 structures as Views, User Defined Functions, stored procedures, Row and Column Access Control (RCAC), LIMIT/OFFSET, exciting new Db2 Services, and more. Security, performance, and ease of maintenance in the open source scripting languages will be the result of the recommendations and techniques given in this talk.


Learning Objectives


1.Learn Db2 techniques that improve security, performance, simplicity
2.Understand how coding in open source scripting languages can be made simpler and more powerful by use of Db2’s modern capabilities



Open Source Programming Languages on IBM i (Erwin Earley)


Recently there has been a significant expansion in the Open Source Programming Languages available on IBM i. This session will explore several of these including PHP, Python, Node.JS, and Ruby. We will discuss the strengths (and weaknesses) of each language as well as their typical usage/application. We will also take a look at understanding the syntax of the language as well as the integration capabilities that each languages has with regard to IBM i – including DB2 access and ILE integration and toolkits that are available for each language.



Openi – Exploring Open Source Solutions on IBM i (Erwin Earley)


Open Source solutions continue to be in vogue for businesses large and small and you might be surprised at the wealth of open source solutions that are available for you to leverage directly on the IBM i platform. This session will explore IBM’s adoption of open source packages and repositories as well as open source solutions available on IBM i including PHP, SAMBA, node.js, Python, and Ruby. Along the way we well also explore how to install/enable tools such as bash, git, zip, perl and others in the PASE environment. This session will open your eyes to what is possible on your IBM i.



Introducing Node.js on IBM i (Erwin Earley)


One of the newer open source languages on IBM is Node.js. Node.js provides the ability to execute java-script on the server-side. This opens up a world of serverless and microservices solutions. This session answers the question “what is node.js” – additionally we will take a look at how Node.js can be used in an IBM i environment and the integration of Node.js with DB2 and ILE. Additionally, we will take a look at the syntax of the language and how solutions in Node.js can be daemonized to server multiple simultaneous requests. Come to this session to learn more about this exciting open source language that is now available on IBM i.



Turn On the LAMP – please! (Erwin Earley)


The computer world is full of light, or so it seems with the proliferation of LAMP-based applications, and the good news is that you have all of the components on your IBM I needed to leverage the large ecosystem of LAMP-based applications. This session will explore the definition of LAMP and the components of IBM I that support LAMP applications. From there we will provide an overview of some of the more popular categories of LAMP applications, including CRM, WIKI, eCommerce, and others. Along the way we will walk through live installations of several LAMP applications on IBM I to show how easy it is to leverage open source solutions on the i platform.



Oh C.R.U.D. (Create, Read, Update, Delete) (Erwin Early)


This session will explore how PHP along with phpGrid can be used to rapidly implement a full functioned CRUD (Create, Read, Update, Delete) application for your DB2 resident data and provide a web presence for the same. As part of the session we will look at how with just a few lines of a code a CRUD application can be implemented and then we will explore how functions such as PDF generation. If the idea of modernization makes you feel like CRUD – this is the session for you!