This document discusses infusing PL/SQL with Java best practices and design patterns. It covers topics like design by contract with encapsulation, assertion and decoupling. Dependency injection is presented as a way to reduce coupling. JSON and caching across sessions using a central cache are shown as techniques for cross-session communication. Finally, using Java stored procedures is proposed as a way to unlock additional capabilities in PL/SQL by leveraging Java.
This document provides an overview of regular expressions (regexes) and grammars in Perl 6. It discusses key concepts like rules, tokens, and capturing matches. Regexes allow matching patterns in strings, while grammars parse strings according to defined rules and tokens. The document gives examples of grammars for search queries and dates that capture city, country, from and to dates, and guest numbers. It demonstrates parsing strings and accessing captured values to retrieve individual fields.
Apex 5 plugins for everyone version 2018Alan Arentsen
Do you think it's hard to create your own plugin? Never took the time to look into it? Or just don't see the added value of using plugins?
Then this presentation might be the place to be for you!
In this session I will explain what plugins are and why you should use them. After that I will lead you the way in creating your own simple plugin. When you leave the conference room you will be able to start using plugins. And I know you will!!
This document discusses making PHP applications more reactive and asynchronous using ReactPHP principles. It covers:
1. The benefits of using a reactive programming approach with ReactPHP including increased performance from non-blocking I/O.
2. How to build a reactive Symfony application using ReactPHP by splitting the application into asynchronous framework, server, and domain layers.
3. The Symfony Async Kernel and ReactPHP Symfony server packages that facilitate building reactive Symfony applications on ReactPHP.
4. Benchmarks showing the ReactPHP approach outperforming traditional PHP and PHP-PM implementations for concurrent requests.
One of the most prolific parts of Zend Framework 2 is the Service Manager. Its many nooks and crannies dictate much of what happens inside our Zend Framework 2 applications and is incredibly powerful. Let's look into exactly what the Service Manager allows us to do and how we can take advantage of it for cleaner, and faster, code.
The document provides an introduction and overview of AngularJS including:
- How to tell Angular which HTML elements comprise the application and how templating works
- How Angular bootstraps and compiles the application
- The MVC pattern in Angular with controllers, views, and models
- Core Angular concepts like filters, ordering, promises, dependency injection, routing, and multiple views
The document discusses regular expressions (regex) and strategies for optimizing performance when using regex. It provides examples of different regex implementations for a custom word checking function and compares their performance. The key points are:
- Implementation #1 using regex is slower than #2 iterating through characters or #3 using string functions like isalpha()
- When writing regex, be careful of repetitions, wildcards, and long target strings as they negatively impact performance
- Strategies like avoiding unnecessary capturing groups, ordering patterns, and minimizing repetitions can improve regex performance.
focuslight-validator validate sinatra application - validation night at LINE ...Satoshi Suzuki
This document summarizes a presentation about the focuslight-validator gem for validating data in Ruby applications. It introduces built-in validation rules for data types, custom lambda rules, specifying multiple rules, and different validation types for single values, arrays, and combinations of parameters. Examples are provided to demonstrate validating data types, length restrictions, and default/optional values.
The document discusses how to write unit tests for PHP code using the PHPUnit testing framework. It provides an example of testing a Math class that contains a sum() method. It demonstrates creating a test case class called MathTest that extends PHPUnit's test case class. The MathTest class contains a testSum() method that asserts the expected output of calls to Math::sum() using PHPUnit's assertion methods. It also shows how to use a data provider method to pass multiple sets of parameters to the test method.
The document summarizes new features and improvements in Zend Framework 1.10, including new components like Zend_Barcode and Zend_Feed_Writer, improvements to existing components, new services like LiveDocx and DeveloperGarden, and updates to the documentation.
The document is a spool file that shows SQL commands and PL/SQL blocks executed for training Oracle students. It includes examples of inserting records into tables, updating salaries and commissions, checking for data validity, rolling back transactions, and deleting records while learning Oracle database concepts and skills. The spool file demonstrates interactive training sessions for students on SQL, PL/SQL, DML commands and transactions.
Building Maintainable Applications in ApexJeffrey Kemp
The document is the agenda for a talk on building maintainable applications in Apex. It discusses maintainable PL/SQL and using an MVC architecture. It also provides examples of unclear and clear code and emphasizes consistency, readability, and writing code that future maintainers will appreciate. The document includes controversial statements, quotes, and code examples to illustrate techniques for writing maintainable code.
The document provides information about Laravel 5.5 including:
- Laravel 5.5 will require PHP 7.0+ and is the next long term support release after 5.1.
- It demonstrates features in Laravel 5.5 such as route helpers, Blade directives, mail previews, fresh migrations, and custom exceptions.
- The document ends by covering validation rules, trusted proxies, packages, vendor publishing, request data from validation, job chaining, and exception throwing helpers.
This document discusses strategies for dealing with legacy PHP code, including separating controllers and views, removing dependencies on global variables, refactoring procedural code to be object-oriented, and untangling nested require statements. Specific problems in legacy PHP code are said to include mixing of PHP and HTML, overuse of requires instead of method calls, and excessive use of global variables. The document provides examples of refactoring code to address these issues.
If you thought Monads are a mystery, then this demonstration would show you how to evolve your code towards a Monad without knowing about it. This demo will neither go into any Category Theory nor begin with monadic laws. Instead, we will start with typical code that you see in your daily life as a developer, attempt to DRY (Don't Repeat Yourself) it up and eventually use Monad to remove duplication and verbosity. You'll also see how Monads make your code more declarative and succinct by sequencing the steps in your domain logic.
Also, we know in Java8 Checked Exceptions + λ == Pain! To be more precise, we will evolve a Try<t> (exception handling monad) which is missing in Java8, similar to one found in Scala.
The road to continuous deployment (PHPCon Poland 2016)Michiel Rook
As presented at PHPCon Poland 2016
It's a situation many of us are familiar with: a large legacy application, limited or no tests, slow & manual release process, low velocity, no confidence.... Oh, and management wants new features, fast.
But how to proceed? Using examples and lessons learned from a real-world case, I'll show you how to strangle the legacy application with a modern service architecture and build a continuous deployment pipeline to deliver value from the first sprint. On the way, we take a look at testing strategies and various (possibly controversial!) tips and best practices.
Abstract: Oracle released a feature in 10g Release 2 they thought worthy of facilitating in previous versions via patch sets - so I thought it was worthy enough for a closer look.
Conditional compilation isn't a foreign concept in the programming world, and for the developer aficionado it's a wonderful paradigm to explore.
Conditional compilation was designed with the main intention of being able to create database version specific code. With the recent advent of 11g, developers can actually start adding 11g features to their 10g code today!
However it provides the savvy PL/SQL developer to enhance their code in more ways than just gearing up for the next release… Dust of your software engineering hats and discover how to utilise conditional compilation to explore concepts such as latent self tracing code; latent assertions; and enhanced prototyping for your unit tests.
This seminar will illustrate several examples of conditional compilation that will open your mind; ultimately benefit your users; and can be implemented as far back as 9.2!
Review unknown code with static analysisDamien Seguy
Review unknown code with static analysis
Code quality is not just for christmas, it is a daily part of the job. So, what do you do when you’re handed with a five feet long pole a million lines of code that must be vetted ? You call static analysis to the rescue. During one hour, we’ll be reviewing totally unknown code code : no name, no usage, not a clue. We’ll apply a wide range of tools, reaching for anything that helps us understand the code and form an opinion on it. Can we break this mystery and learn how everyone else is looking at our code ?
Default function parameters allow parameters to be initialized with default values if no value is passed when calling the function. Default parameters can be destructured and the default values can be functions that are evaluated at call time. An example shows a function that returns an employee ID with a default value if no ID is passed, and another function that returns a full name using default first and last name values if not passed.
ODTUG Technical Journal - The Reusability Test - Fusion Column July 2010Lucas Jellema
This article discusses reuse. Why would we want reuse and what do we have to do to realize the potential benefits of reuse? What are important considerations around reuse that we should pay attention to? How does a structural approach to reuse impact our organization? Which types of reuse should we discern? And which mechanisms are available to us in general and in Oracle Fusion Middleware (FMW) in particular? We will take a close look at the ADF Taskflow - one of the primary vehicles in FMW for achieving reuse.
PL/SQL applications do not live on an island - any longer. Increasingly, applications need relate to the rest of the world. Either to make themselves and the services they provide accessible to external parties - that may not speak PL/SQL at all - or to access information or enlist help from external services.
Fortunately, PL/SQL can do much more than invoke other PL/SQL applications or execute SQL. PL/SQL - sometimes in conjunctions with other components in the Oracle RDBMS - provides many inbound and outbound channels for such interactions. This session discusses and demonstrates a number of channels - when and why to use them and how to use them.
The presentation discusses how to publish data to consumers via HTTP, using both XMLDB and the Embedded PL/SQL Gateway - for example to deliver HTML, XML or RSS or to provide REST-style (web)services that are much in demand. The session also discusses the importance of email as a vehicle for human-application interaction, demonstrating how to send and how to act on received emails. An important topic is how to engage in queue based interactions (for example with a SOA infrastructure) and it concludes with how through utl_http or XMLDB and (simple) middleware, the world of SOA, REST and even the internet is ours as well. It includes a demo on 'chatting from the database' (database triggers that send out IM alerts to human agents).
Java power to the SOA developer (ODTUG Kaleidoscope 2010)Lucas Jellema
For a long time, the perception of using Oracle's SOA Suite was that its usage required deep XML knowledge. This has changed dramatically with SOA Suite 11g and the supporting tools. This talk will introduce you to the extended and enhanced Java capabilities all across the platform, the native support for Spring components inside composites, and the WebLogic SCA for Java container. Learn how to transparently leverage existing Java code, and let the platform worry about serialization and XML generation.
It's happening - on Event Driven SOA, Part Two (EDN patterns, ADF BC integrat...Lucas Jellema
When should a process start or a service be activated? The trigger can be a requirement in an application, process, or service that then invokes the service or process. However, frequently the link is not that straightforward. When 'something happens' (a business event!), that should lead to the start of other actions or the continuation or redirection of running processes. However, whose responsibility is it to determine that a business event has taken place, and even more importantly, who to notify? The process instance that happens to produce an event should not bare the burden of finding out who needs to be notified—especially as the list of interested parties can be hugely dynamic. Nor should the event be presented to any service, composite application, or process to check out whether perhaps it wants to consume it.
This session discusses Event-Driven SOA—an architecture where applications, processes, and services can produce business events, and interested consumers are notified of those events—through the mediation by the SOA Suite 11g Event Delivery Network (EDN). In this session, we will see how business events are defined across the enterprise, and how an interest in specific types of business events (with specific payloads) can be registered. The session demonstrates how events can be produced, how they are processed by the EDN, and handed to the interested parties. Special attention is given to the correlation of events, ensuring that the correct composite instance is provided with the event. We will discuss how the events can not only originate within the SOA Suite, but also outside of it, through AQ, PL/SQL and Java, ADF BC, and JMS. As a last step, we will discuss Complex Event Processing (CEP) as a potential source of business events. CEP will handle large volumes of small, usually insignificant events. However, by filtering, aggregating, and analyzing for deviations and threshold transgressions, CEP will occasionally find business events that are subsequently sent to the Event Delivery Network. This session has many demonstrations (end-to-end).
The AMIS Report from Oracle Open World and JavaOne 2011 - Part OneLucas Jellema
The first part of the report from the AMIS team on their findings of Oracle Open World 2011 and JavaOne 2011. With the major announcements, the roadmaps, highlights and disappointments, some gold nuggets and personal bests and a general impression of where Oracle, the industry trends and the technology are going.
What is the Oracle PaaS Cloud for Developers (Oracle Cloud Day, The Netherlan...Lucas Jellema
The promise of the cloud is substantial. Oracle's public cloud promise goes beyond the generic promise. This presentation describes the promise of the Oracle Public Cloud specifically for developers. It describes the current state of the PaaS Platform, the actual and coming services and what they could mean to a developer. From same platform, different location (DBaaS, JCS) to cloud native stack (ICS, MCS) and services for Citizen Developers, the presentation touches upon virtually all services relevant to developers. The presentation concludes with first the steps enterprises can start taking to move to the cloud and second the steps individual developers could and perhaps should take in order to conquer the clouds.
Exploiting the newer perl to improve your pluginsMarian Marinov
The document discusses techniques for improving Perl plugins, including using jQuery, JavaScript::Packer, and JSON::XS for frontend development and queuing systems like Gearman and RabbitMQ for backend processing. It also covers caching with Memcached and Redis. The presenter, Marian Marinov, encourages attendees to take a survey for $20 in return.
Developing A Real World Logistic Application With Oracle Application - UKOUG ...Roel Hartman
This document summarizes the development of a real-world logistic application using Oracle Application Express (APEX) for a client. It describes enhancing the existing application by replacing forms with APEX, including adding direct validation, replacing the calendar with jQuery, showing descriptions for codes, and improving the list of values functionality. The presentation provides examples of implementing these enhancements in APEX.
JUDCon London 2011 - Bin packing with drools planner by exampleGeoffrey De Smet
The document discusses using Drools Planner, an open source optimization tool, to solve planning problems like bin packing processes on cloud servers. It describes how Drools Planner models planning problems, defines score rules to evaluate solutions, and uses optimization algorithms like first fit, tabu search, and simulated annealing to improve solutions. It provides an example of using Drools Planner to optimize assigning processes to servers on a cloud to minimize costs while meeting constraints. The document advocates that organizations can benefit from using tools like Drools Planner to optimize their planning problems.
This document introduces the Database.com SDK for building Java applications that interact with Salesforce data. It discusses the key components of the SDK including the JPA provider, API connector, and OAuth authentication. It also provides an overview of how to deploy Java applications to Heroku, including using Git for deployment, configuring dynos, and other Heroku features.
Arpad Ray's PHPNW08 slides:
Looking at websites from the perspective of potential attackers is a useful technique not only for security professionals.
This talk demonstrates how to use simple PHP scripts to exploit many common security holes in PHP applications, hopefully giving developers a deeper understanding of what it is they are protecting against.
* Getting around common precautions against SQL injection
* Free spam with SMTP injection
* Making a malicious website to exploit PHP sessions
* The holes every attacker hopes for
* Making use of a newly exploited website
The document provides an overview of PHP (Hypertext Preprocessor), a popular server-side scripting language. It discusses key PHP concepts like variables, data types, operators, forms, and functions. Some key points covered include:
- PHP code is embedded within <?php ?> tags and can output and interact with HTML
- PHP supports common variable types like integers, floats, strings, and arrays
- Operators allow performing tasks like math operations and comparisons on variables
- Forms allow user input and are submitted via GET or POST methods to PHP scripts
- Functions help organize and reuse code when called within a PHP program
Oracle - Program with PL/SQL - Lession 09Thuan Nguyen
This document discusses procedures in PL/SQL, including:
1. How to create procedures using the CREATE PROCEDURE statement and define parameters.
2. The different parameter modes: IN, OUT, and IN OUT.
3. How to handle exceptions within procedures.
4. How to invoke procedures from other procedures, scripts, or applications.
5. Best practices for developing reusable procedures.
This document provides an introduction and overview of Windows PowerShell. It discusses what PowerShell is, how it works, and how it can be used for administration tasks and extended to work with other products. The document covers PowerShell concepts like verbs, nouns, pipelines, and cmdlets. It also provides examples of using PowerShell for ad-hoc tasks and developing PowerShell scripts and cmdlets for production environments.
Yapc::Asia 2008 Tokyo - Easy system administration programming with a framewo...Gosuke Miyashita
Punc is a framework for building system administration applications. It allows users to select target hosts, connect to them securely, run modules on them to retrieve information or make changes, and reuse code via a module programming model. Modules run commands and return structured data like scalars, hashes and arrays. Punc uses JSON-RPC over HTTPS to call modules securely on target hosts. It detects operating systems using Pfacter to use the right module for the target system. The framework is open source and development is ongoing to support more modules and features.
The document discusses execution plans in Oracle databases. It provides information on how to view predicted and actual execution plans, including using EXPLAIN PLAN, AUTOTRACE, and querying dynamic views. It also describes how to capture execution plans and bind variables from trace files using tools like TKPROF.
This document provides an overview of the history and development of Perl web development, introducing the Common Gateway Interface (CGI) model and its limitations. It describes how mod_perl helped address these issues but lacked portability. The PSGI specification and Plack implementation are presented as a solution, providing a common interface between Perl web applications and web servers. Key aspects of building PSGI applications, such as templates, user input handling, and middleware, are demonstrated. Major frameworks and servers supporting PSGI are also noted.
Slides from my Lonestar Ruby Conf 2011 presentation.
*** Video of presentation: http://confreaks.com/videos/2531-lsrc2011-testing-javascript-with-jasmine ***
Agenda:
- Briefly cover why you should unit test
- Discuss what Jasmine is and isn't
- Show syntax with comparisons to RSpec
- Jasmine with:
- Vanilla JavaScript
- Jasmine with jQuery
- Jasmine with Ruby (not Rails)
- Jasmine with Rails
- Evergreen
- capybara-webkit
- Where does CoffeeScript, node.js, etc. fit in?
- Other helpful libraries/Wrap-up
The document discusses an upcoming Spring Framework workshop. It provides an agenda for the workshop that includes discussions on why Spring, new features in Spring 3.0, the Spring core container, Spring JDBC, AOP, EhCache, Spring Web MVC, and basic workshop requirements. It also lists some source code resources and example applications to use during the workshop.
Serverless is the most clickbaity title for an actually interesting thing. Despite the name, Serverless does not mean you’re not using a server, rather, the promise of Serverless is to no longer have to babysit a server. Scaling is done for you, you’re billed only for what you use. In this session, we’ll cover some key use cases for these functions within a Vue.js application: we’ll accept payments with stripe, we’ll gather geolocation data from Google Maps, and more! We’ll make it all work with Vue and Nuxt seamlessly, simplifying how to leverage this paradigm to be a workhorse for your application.
PHP frameworks provide reusable code and standardized structures for developing applications. The Zend framework is a popular open source PHP MVC framework that offers features like database abstraction, forms, validation, routing and more. It provides a modular architecture that allows applications to scale easily while maintaining code quality and organization.
The document discusses building a lightweight web module to inject content from one site into another cross-domain using JSONP. It covers topics like same-domain callbacks using hidden proxy iframes, API design using configuration objects, minimizing JavaScript size through techniques like removing comments and whitespace, and evolving code through patterns like the immediate function pattern. The document provides examples of minimizing code size through techniques like short variable names and replacing methods with equivalent but shorter alternatives.
FOSDEM 2012: Practical implementation of promise theory in CFEnginedottedmag
The document discusses the implementation of promise theory in CFEngine, including reports, processes, packages, and variables. It explains how each concept achieves convergence, embraces errors, and remains autonomous through keeping promises occasionally without relying on other agents.
Introduction to web application development with Vue (for absolute beginners)...Lucas Jellema
In this slide deck I show you how you can easily and quickly create quite rich web applications with Vue 3 – without having to study complex concepts or understand many technical details. I have only recently learned how to work with Vue 3 myself and now is the best time for me to share my learning experience (and my enthusiasm) with you. I know what I found essential to understand and what most got me excited in these early steps (what was a little bit hard to grasp). I believe that I can present my steps and guide you to experience the same fun and have a similarly gratifying experience. I am not an expert in this subject – I have barely learned how to walk and that is why I can help you with these first steps with Vue.
In this deck, I do not explain how Vue works. I do not really know that. I will show you how to work with it and how to create web applications that are functional, appealing, fast and responsive.
The approach I am taking is straightforward:
• I will tell you a little bit about web development, browsers and reactive frameworks
• I will show the hello world of Vue applications
• I will explain about components and nesting, events, data binding and reactive behavior and demonstrate these concepts
• I will introduce Vue UI Component libraries – and with no effort at all we will launch our application to the next level – with rich components to explore, manipulate, visualize data collections
• We will publish the web application from our development environment to where the whole world could see it – using GitHub Pages
• As bonus topic – we discuss state management
At the end of this session you will be able to quickly create a simple yet rich web application with Vue 3. You have a starting point to further evolve your skills with the many online resources I am convinced that you will enjoy your newfound powers and the simplicity and power of Vue 3.
Note: a tutorial accompanies this slide deck - see https://github.com/lucasjellema/code-face-vue3-intro-reactiive-webapps-aug2023/blob/main/README.md
Making the Shift Left - Bringing Ops to Dev before bringing applications to p...Lucas Jellema
The document discusses bringing operations considerations into the development process earlier, referred to as "shifting left." It advocates designing applications with operations in mind from the beginning. This includes understanding operational objectives, constraints, and service level agreements. Application telemetry and monitoring are also important to incorporate from the start. The document provides examples of how to implement operational practices like deployments, health checks, and incident response processes in a shifted left model where development and operations work more closely together.
Lightweight coding in powerful Cloud Development Environments (DigitalXchange...Lucas Jellema
The document discusses lightweight coding in powerful cloud development environments using Gitpod. It describes Gitpod as providing a preconfigured Linux development environment in the browser or on local machine. The document outlines key Gitpod features like open source project collaboration, costs which are free for 50 hours per month, and benefits like clean environments and efficient resource usage. It also briefly mentions other tools like GitHub Codespaces.
Apache Superset - open source data exploration and visualization (Conclusion ...Lucas Jellema
Introducing Apache Superset - an open source platform for data exploration, visualization and analysis - co-starring Trino and Steampipe for providing SQL access to many non-SQL data sources.
CONNECTING THE REAL WORLD TO ENTERPRISE IT – HOW IoT DRIVES OUR ENERGY TRANSI...Lucas Jellema
Enterprise IT systems are deaf, blind and highly insensitive. They do not know what is going on in the outside world. Through Internet of Things technology, we provide eyes, ears and hands that allow enterprises to learn about and react in real time to events in the physical world. The energy transition at a major Dutch energy company (Eneco) is powered by IoT technology – to steer and sometimes curtail windmills and solar farms and to coordinate local energy production and trade. This session shows you how the physical world was connected to the customer portals and apps, asset management systems and Kafka platform through the Azure cloud based IoT Hub en Edge, digital twin, serverless functions, timeseries datastores and streaming data analysis. It is a story about technological innovation on top of existing foundations and of a vision for business and our society at large.
Help me move away from Oracle - or not?! (Oracle Community Tour EMEA - LVOUG...Lucas Jellema
I hear this aspiration from a growing number of organizations. Sometimes as a quite literal question. This however is merely half of a wish. Apparently, organizations want to quit with one thing — but have not yet stipulated what they desire instead. What is the objective that is pursued here? Only to get rid of Oracle? It will become clear why you should give a considerable thought about dropping Oracle, or any other vendors’ technology, when you’re not pleased with your current IT situation. You need to focus on the actual problems and objectives and define the suitable roadmap to fit your real needs. It turns out that the quest is usually for modernization and flexibility - and Oracle can very well be a part of that future.
Organizations with decades of investment in Oracle technology sometimes (and increasingly) express a wish to move away from Oracle. In this session, we will first explore where the desire to move away from Oracle might come from. Then we describe what the term Oracle represents — more than 2.000 products on all layers in the technology stack and in different business areas. Finally, we map out what the ‘moving away from’ consists of: defining where you ‘move to’ and subsequently actually going there.
It will become clear why you should give considerable thought about dropping Oracle, or any other vendors’ technology, when you’re not pleased with your current IT situation. You need to focus on the actual problems and objectives and define the suitable roadmap to fit your real needs. It turns out that the quest is usually for modernization and flexibility - and Oracle can very well be a part of that future.
Original storyline in this Medium Article: https://medium.com/real-vox/what-if-companies-say-help-me-move-away-from-oracle-ffbbc95afc4f
IoT - from prototype to enterprise platform (DigitalXchange 2022)Lucas Jellema
In 2019 the company started a small scale IoT project: smart meters in consumer homes, a cloud based IoT platform for device management, metrics collecting, monitoring and real time data processing. From the initial 12 devices and this single use case, the initiative has rapidly scaled, to tens of thousands devices - including entire wind parks and solar farms - and seven substantial business cases, not just for harvesting data but increasingly for real time actuation. The IoT Platform is feeding the brain at the heart of the enterprise - through an event streaming platform and an API platform. It supports complex operations with anomaly detection on metrics streams and device and communication monitoring. This session tells about the eye catching business cases - what are business objectives and results - and explains the journey since the start. It continues the story presented at DigitalXchange 2020 - discussing technical challenges and solutions as well as organizational aspects. Areas of particular interest: edge processing, data analytics and machine learning.
Who Wants to Become an IT Architect-A Look at the Bigger Picture - DigitalXch...Lucas Jellema
Pitch: The movie The Matrix made it clear: The Architect is powerful. How to be(come) and IT architect? What do you do, what do you need to know, is it fun and why? Using real world examples, core principles and useful tools, this session introduces the subtle art of designing and realizing flexible IT architectures. </p><p>Taking a step back to get and create an overview, frequently asking why to get to the real intention, bringing aspects such as cost, scale, time and change and business strategy into the design and bridging the gap between business owners, process managers and technical specialists. One way to define the responsibility of an IT architect. In this session, we will discuss what is expected of the architect and what you need to do for that and what you could use to get it done. How do you get started as an architect, how to grow in that role? We discuss a number of real life architectural challenges and solution design. And discuss a number of architecture principles, patterns, and powers to apply. Never stop programming - but perhaps rise to the architecture challenge too.
Notes: Many IT professionals aspire to become architects. Many architects wonder what it is they have to do. After 27 years in IT I find I have slowly and steadily moved into a role that I can probably use the label architect for, although still with some reluctance. What exactly does that mean - IT architect? While I may not have all answers and the ultimate truth and wisdom, I do have many architectural challenges to discuss and some core principles to share and a number of tips, tricks and tools to recommend that will help anyone get started or grow in a role as architect for software and IT systems. Elements that make an appearance include cloud, agile, DevOps, microservices, persistence, business, powers of persuasion, diagramming, cost, security, software engineering, data.
Outline: - two real world examples (one new business initiative, one running and struggling project) and how to approach them with an architect's mind - core principles to apply , patterns to us, what to unearth (the power question of WHY) - architecture products: what do you deliver as an architect; how do you ensure agility? - how to be effective? bringing your design to life - communication with stakeholders/powers of persuasion, monitoring adherence, being pragmatic but not lose grip; - anecdotal evidence from several small and large product teams - the good and also the ugly (architectural oversights and the consequences)
some specific answers to address - how much technical knowledge and programming skills does an architect require? What other knowledge is required and how to stay on top of your game? how to get going: first steps towards be(com)ing and architect?
Steampipe - use SQL to retrieve data from cloud, platforms and files (Code Ca...Lucas Jellema
Introduction to Steampipe - a tool for retrieving data and metadata about cloud resources, platform resources and file content - all through SQL. Data from clouds, files and platforms can be joined, filtered, sorted, aggregated using regular SQL. Steampipe offers a very convenient way to get hold of data that describes the environment in detail.
Automation of Software Engineering with OCI DevOps Build and Deployment Pipel...Lucas Jellema
Automation of software delivery has several advantages. Prevention of human error is certainly one. Consistent and complete execution of tried and tested build and deployment tasks as the only way to apply changes in the live environment. Once the pipelines have been set up, the engineers can focus on the software and applying the required changes to it. To bring that software all the way to production is a breeze. Oracle Cloud Infrastructure offers the DevOps service, introduced in the Summer of 2021. This service comes with git style code repositories, build servers and build pipelines, artifact repositories as well as deployment pipelines. This session introduces OCI DevOps and demonstrates how software can be built and deployed on OKE Kubernetes, Compute Instance VMs and Oracle Functions. From simple source code an application is put in production without manual intervention in the build and deployment process.
Introducing Dapr.io - the open source personal assistant to microservices and...Lucas Jellema
Dapr.io is an open source product, originated from Microsoft and embraced by a broad coalition of cloud suppliers (part of CNFC) and open source projects. Dapr is a runtime framework that can support any application and that especially shines with distributed applications - for example microservices - that run in containers, spread over clouds and / or edge devices.
With Dapr you give an application a "sidecar" - a kind of personal assistant that takes care of all kinds of common responsibilities. Capturing and retrieving state, publishing and consuming messages or events. Reading secrets and configuration data. Shielding and load balancing over service endpoints. Calling and subscribing to all kinds of SaaS and PaaS facilities. Logging traces across all kinds of application components and logically routing calls between microservices and other application components. Dapr provides generic APIs to the application (HTTP and gRPC) for calling all these generic services – and provides implementations of these APIs for all public clouds and dozens of technology components. This means that your application can easily make use of a wide range of relevant features - with a strict separation between the language the application uses for this (generic, simple) and the configuration of the specific technology (e.g. Redis, MySQL, CosmosDB, Cassandra, PostgreSQL, Oracle Database, MongoDB, Azure SQL etc) that the Dapr sidecar uses. Changing technology does not affect the application, but affects the configuration of the Sidecar. Dapr can be used from applications in any technology - from Java and C#/.NET to Go, Python, Node, Rust and PHP. Or whatever can talk HTTP (or gRPC).
In this Code Café I will introduce you to Dapr.io. I will show you what Dapr can do for you (application) and how you can Dapr-izen an application. I'll show you how an asynchronously collaborative system of microservices - implemented in different technologies - can be easily connected to Dapr, first to Redis as a Pub/Sub mechanism and then also to Apache Kafka without modifications. Then we do - with the interested parties - also a hands-on in which you will apply Dapr yourself . In a short time you get a good feel for how you can use Dapr for different aspects of your applications. And if nothing else, Dapr is a very easy way to get your code with Kafka, S3, Redis, Azure EventGrid, HashiCorp Consul, Twillio, Pulsar, RabbitMQ, HashiCorp Vault, AWS Secret Manager, Azure KeyVault, Cron, SMTP, Twitter, AWS SQS & SNS, GCP Pub/Sub and dozens of other technology components talk.
How and Why you can and should Participate in Open Source Projects (AMIS, Sof...Lucas Jellema
For a long time I have been reluctant to actively contribute to an open source project. I thought it would be rather complicated and demanding – and that I didn't have the knowledge or skills for it or at the very least that they (the project team) weren't waiting for me.
In December 2021, I decided to have a serious input into the Dapr.io project – and now finally to determine how it works and whether it is really that complicated. In this session I want to tell you about my experiences. How Fork, Clone, Branch, Push (and PR) is the rhythm of contributing to an open source project and how you do that (these are all Git actions against GitHub repositories). How to learn how such a project functions and how to connect to it; which tools are needed, which communication channels are used. I tell how the standards of the project – largely automatically enforced – help me to become a better software engineer, with an eye for readability and testability of the code.
How the review process is quite exciting once you have offered your contribution. And how the final "merge to master" of my contribution and then the actual release (Dapr 1.6 contains my first contribution) are nice milestones.
I hope to motivate participants in this session to also take the step yourself and contribute to an open source project in the form of issues or samples, documentation or code. It's valuable to the community and the specific project and I think it's definitely a valuable experience for the "contributer". I looked up to it and now that I've done it gives me confidence – and it tastes like more (I could still use some help with the work on Dapr.io, by the way).
Microservices, Apache Kafka, Node, Dapr and more - Part Two (Fontys Hogeschoo...Lucas Jellema
Apache Kafka is one of the best known enterprise grade message brokers – created at LinkedIn, donated to the Apache software foundation and used in an ever growing number of organizations to provide a backbone for asynchronous communication. This session introduces Apache Kafka – history, concepts, community and tooling. In a hands on lab, participants will create topics, publish and consume messages and get a general feel for Kafka. Simple microservices are developed in NodeJS – publishing to and consuming from Apache Kafka.
Dapr.io has support for Apache Kafka. Using Kafka through Dapr is very straightforward as is explained and demonstrated and applied in a second handson lab – with applications in various programming languages. Participants will even be able to exchange events across their laptops – through a cloud based Kafka broker.
Use of Apache Kafka in several architecture patterns is discussed – such as data integration, microservices, CQRS, Event Sourcing – along with a number of real world use cases from several well known organizations. The Kafka Connector framework is introduced – a set of adapters that allow us to easily connect Kafka to sources and sinks – where respectively change events are captured from and messages are published to.
Bonus Lab: Apache Kafka is ran on Kubernetes as is Dapr.io. Multiple mutually interacting microservices are deployed on the same local Kubernetes cluster.
Microservices, Node, Dapr and more - Part One (Fontys Hogeschool, Spring 2022)Lucas Jellema
This session does a quick recap of microservices: why do we want them, what problems do they solve and what are the principles around designing and implementing them? The Dapr.io runtime framework for distributed applications is introduced. Dapr provides a sidecar (almost like a personal assistant to a manager) to an application or microservice, a companion process that handles common tasks such as storing and retrieving state, consuming and publishing messages and events, invoking external services and other microservices as well as handling incoming requests. Participants will do a handson lab with Dapr.io and learn how to quickly implement interactions with various technologies, including Redis and MySQL.
Node(JS) is introduced – a server side JavaScript-based programming language that can be used well for implementing microservices. Some of the main characteristics of NodeJS are discussed (functional programming, asynchronous flows, NPM package manager) as well as common use cases (handle incoming HTTP requests, invoke REST APIs). In the second lab, Node and Dapr are used together to implement microservices that interact with databases and message brokers and each other – in a decoupled fashion.
6Reinventing Oracle Systems in a Cloudy World (RMOUG Trainingdays, February 2...Lucas Jellema
The cloud is changing many things. Even the decision to not (yet) adopt cloud is one to make explicitly. Now is a time for any organization to reconsider the IT landscape. For each system we should make a conscious ruling on its roadmap. The 6R model suggests six ways to move a system forward.
This session uses the 6R model and applies it specifically to Oracle technology based systems: what are the options and considerations for Oracle Database, Oracle Fusion Middleware, custom applications, and other red components? What future should we consider and how do we choose? The paths chosen by several Oracle-heavy users is presented to illustrate these options and the decision making process. Oracle Cloud Infrastructure and Autonomous Database play a role, as do Azure IaaS and Azure Managed Database as well as on premises systems. Latency, recovery, scalability, licenses, automation, lock-in, skills, and resources all make their appearance.
Help me move away from Oracle! (RMOUG Training Days 2022, February 2022)Lucas Jellema
Organizations with decades of investment in Oracle technology sometimes (and increasingly) express a wish to move away from Oracle. In this session, we will first explore where the desire to move away from Oracle might come from. Then we describe what the term Oracle represents -- more than 2.000 products on all layers in the technology stack and in different business areas. Finally, we map out what the 'moving away from' consists of: defining where you 'move to' and subsequently actually going there.
It will become clear why you should give considerable thought about dropping Oracle, or any other vendors' technology, when you're not pleased with your current IT situation. You need to focus on the actual problems and objectives and define the suitable roadmap to fit your real needs. It turns out that the quest is usually for modernization and flexibility - and Oracle can very well be a part of that future.
DevOps is a term used in many places and unfortunately also to mean many different things. This presentation (largely in Dutch) paints the DevOps picture. While it may not give a clear cut definition (there does not seem to be one) it certainly makes clear what DevOps is about, what objectives and origins are and which factors enable and drive DevOps.
Conclusion Code Cafe - Microcks for Mocking and Testing Async APIs (January 2...Lucas Jellema
Microcks is a tool for API Mocking and Testing. In this presentation an overview of the support in Microcks for asynchronous APIs - the event publishing and consuming behavior of services and applications
Cloud native applications offer scalability, flexibility, and optimal use of compute resources. Serverless functions interacting through events, leveraging cloud capabilities for persistent storage and automated operations take organization to the next level in IT. This session demonstrates polyglot Functions interacting with native cloud services for events and persistence (Object Storage and NoSQL Database) and leveraging the Key and Secrets Vault, Monitoring and Notifications services for operational control. A lightweight API Gateway is used to expose APIs to external consumers. Infrastructure as Code is the guiding principle in deploying both cloud resources and application components, through OCI CLI and Terraform. This session leverages many cloud native (enabling) services in Oracle Cloud Infrastructure. The session will introduce concepts, then spend most of the time on live demonstrations. All sources are shared with the audience, to allow participants to create the same application in their own cloud tenancy. What is so great about Cloud Native Applications? How do you create one? I will explain the first and demonstrate the second. On Oracle Cloud Infrastructure, using services that anyone can use for free, I will live create a cloud native application that streams, persists, notifies, scales, monitors Benefits: - get to know many different OCI services - understand the meaning, purpose and benefits of cloud native development - learn how to take your own first steps in OCI - for free!
26. procedure assert (p_check in boolean ,p_msg in varchar2 := null )isbegin if not nvl(p_check,false) -- fail on null input thenraise_application_error ( c_AssertFail, 'Assertion Fail' ||': '||substr( nvl(p_msg, 'No Message') , 1, 200) ); end if;end assert;
27. Validate Inputprocedure proc (...)isbegindbc.assert (p_name is not null ,'The Name must be Filled' );dbc.assert ((p_sal is not null and p_sal > 0) ,'The Salary must be greater than zero' );dbc.assert (p_hiredate >= trunc (sysdate) ,'Hiredate must be in the Future' ); ...end proc;proc.sql
28. -- Description of this procedure---- %paramp_name Name of an Employee-- {*} Requirement Name must be provided---- %paramp_sal Salary of the Employee-- {*} Requirement Salary must be greater than zero---- %paramp_hiredateHiredate-- {*} Requirement Hiredate must be in the Future---- %raises DBC.AssertFail-- When a Parameter does not match the requirement
36. Dependency Injection- Traditional Approach Central Package instead of hard-codingc_mailserverc_interest_ratec_vat_ratec_file_in_namec_log_levelAPP_CONSTANTSPackagePackagePackage
38. From mere Value Injection to Interface InjectionA component can specify it requires some simple configuration values to be injecteddirectory name, email address, discount percentageIt can also stipulate that it wants some ‘helpers’complete functional componentsfor example: a Logger, an Emailer, a Discount Calculation Service, an Order Validation , etc.The component will prescribe the interface the injected helper must haveReuse is promoted through injected dependencies
39. Interface Injection“If you give me a logger, I will write logging”Dependency_InjectorLOGGERlog_message( p_log_level in varchar2 , p_log_origin in varchar2 , p_log_message in varchar2);set_loglevel_threshold( p_log_level in varchar2);set_file_writer( p_file_writer in varchar2HRM_SALARY_RULES/* Logger interface:p_log_level in varchar2 , p_log_origin in varchar2 , p_log_message in varchar2*/set_logger (p_logger in varchar2)
40. Interface Injection“If you give me a logger, I will write logging”Dependency_InjectorHRM_SALARY_RULES/* Logger interface:p_log_level in varchar2 , p_log_origin in varchar2 , p_log_message in varchar2*/set_logger (p_logger in varchar2)NEW_LOGGER_IMPLWrite_trace_message( p_log_level in varchar2 , p_log_origin in varchar2 , p_log_message in varchar2);
70. 1Write Functional Java2Wrap with PL/SQL3Load into Database4Set appropriate Privs5Invoke JSP via PL/SQL InterfaceSummary
73. From Xenophobia to XenogeneticsEstablished best practices in languages like Java can help improve use of PL/SQLDesign by Contract, Encapsulation, Assertion, Reduced Impact of ChangesDependency Injection, Decoupling, ReuseTechnical concepts in Java can have a meaningful counterpart in PL/SQLData and Interaction across sessions
74. From Xenophobia to XenogeneticsDe-facto standards – such as JSON – may make sense in a PL/SQL contextAnd open source PL/SQL libraries may existThrough Java Stored Procedures, PL/SQL can leverage Java capabilities & librariesTo interact through additional channelsTo calculate, process, generate, interpret
… and you don’t want to be sitting here [animation] when someone down here [animation] has already written this solution.
ENCAPSULATION (hide implementation from consumers)Encapsulation: wijziging van implementatiezonderuiterlijkegevolgen; netter organiserenDecoupling: views, pl/sqlapiAssertion: verifieren van afgesproken contract
When developing stored procedures, you agreed upon a specific interface, the signature of the stored procedure. Implicitly you agreed upon a contract. One using the Stored Procedure will know which parameters to supply and what will be returned by the stored procedure.In order to implement the stored procedure you make certain assumption about the supplied values for the parameters.Using Assertions you can make sure that the user of the Stored Procedures is faithful to the contract.Talen: webservices, javaElementen in contractDatatype (aantal, type, eisenaaninhoud)ExceptionsReturn SLA elementen: side effects – transactions/ nietbeschikbaarFunctionelebeschrijving
Deel van assertions is er, datatype
Do nothing or Complain Loudly
This is
Nice and optimistic interpretation:We do not want to burden you with the task(s) ofcalling us, keeping up to date with our latest contact details, being familiar with our internal procedures Let us handle the nitty gritty and just tell you what you need to know when you should know it
EmailDirectoryurllogging
EmailDirectoryurllogging
Background parallel processing; information exchange between different processesWhy would you want cross session communication?Background processes for parallel processingSharing cache resultsInter-user communication…?
Background parallel processing; information exchange between different processes
Javakoffie
Communication across sessions: Options: DBMS_PIPE – serialized in case of Public Pipes, only one session gets the informationQueueing – quite heavy Tables – always need transaction mechanism Application Context- no transaction neededApplication Context: storing name-value pairsKunnenalleen strings in
Communication across sessions: Options: DBMS_PIPE – serialized in case of Public Pipes, only one session gets the informationQueueing – quite heavy Tables – always need transaction mechanism Application Context- no transaction neededApplication Context: storing name-value pairsKunnenalleen strings in
Communication across sessions: Options: DBMS_PIPE – serialized in case of Public Pipes, only one session gets the informationQueueing – quite heavy Tables – always need transaction mechanism Application Context- no transaction neededApplication Context: storing name-value pairsKunnenalleen strings in
Communication across sessions: Options: DBMS_PIPE – serialized in case of Public Pipes, only one session gets the informationQueueing – quite heavy Tables – always need transaction mechanism Application Context- no transaction neededApplication Context: storing name-value pairsKunnenalleen strings in
JavascriptPhpWeb wereld
Very compact, with lots of information.
Same information, now represented in XML – lot more text
Available Open Source projects for JSON in combination with PL/SQL
Available Open Source projects for JSON in combination with PL/SQL
Usually, jobs can only be used for batch programming (no synchronous response). However: a task can be divided up over various jobs – where each job does part of the work – and all jobs report back their result to the original thread (session) through a pipe
The job is scheduled to run every minuteIt calls upon the Java Stored Procedure to retrieve the newly arrived email-messages – in a specific accountFor each message, an email event is enqueue in the AQ Queue. The new email-messages are subsequently removed.A queue listener has been registered on the queue with email eventsEvery email (event) is dequeued and processedThe email can contain query statements – in some form – that the processor knows how to handleThe reply to the query is then sent in an email message that forms the response to the original email messageNote: other listeners could dequeue the email events and process them in other waysIncoming messages from other sources could be retrieved and processed in a similar way as email messages (VOIP, SMS, IM/Chat, Twitter)The database can both send and retrieve messages from such serversNote: Java is much better equipped than plain PL/SQL (that really only has utl_http, utl_tcp, utl_smtp) for customized, flexible, advanced interaction with a wide range of infrastructures and technologies.
Screenshot:Frank sends email to Maggie – with a query on EmployeesAfter some time, a response is sent to this particular email – by the queue listener using the JSP to send(list of employee data, corresponding with “query”)
Java is much better equipped than plain PL/SQL (that really only has utl_http, utl_tcp, utl_smtp) for customized, flexible, advanced interaction with a wide range of infrastructures and technologies.Java libraries can help to generate PDF, create and/or read Word and Excel etc.Through JMS – external Java applications can be accessed in a decoupled way. For example: Complex Event Processor
Write functional JavaFor example in JDeveloperUsing the full richness of the IDE and of the Java Language (and libraries)Wrap with PL/SQL Map Java & PL/SQL data types Load into DatabaseCustom classes and libraries (JAR-files)Set appropriate privilegesInvoke JSP through a normal PL/SQL interface
Look around youThink out of the the boxKeep an open mind
Leverage Java – without the need to buy/install/maintain (middletier) additional infrastructureChannels: receiving emails, Instant Messaging (chatting)Processing/Generating (statistics, Excel, PDF, images, ..)