Azure Functions Kafka trigger in NodeJS programming model V4
Programming model V4 for NodeJS Azure Functions has been out for about two years now, and overall I think it is a great improvement over V3. If you are …
Category: Languages
Retries with backoff in Azure Service Bus
In my current project, we receive messages from Azure Service Bus that we need to deliver to edge devices that are located all over the country. The connections to …
Github Copilot getting started, a practical developer guide
GitHub Copilot has captured the attention of developers worldwide, promising a revolutionary shift in the way we write code. While the concept sounds enticing, many developers are left wondering, …
The Art of Programming– The Advent of Code Programming Puzzle Marathon
Just over three weeks ago, a colleague told me about The Advent of Code 2023. She explained how for 8 years every year in days and weeks leading up …
Graph Database style explorations of relational database with Formula One data– Oracle Database 23c Property Graph
The core Formula One data could be represented in a graph like this: Drivers compete in races that are hosted on circuits. A result is achieved by the driver …
Oracle Database 23c as Graph Database–SQL Property Graph for network style querying
I bet you are used to relational data structures that you query using SQL. And so do I. And there is nothing in terms of data that a good …
Get Going with SQL Developer against Oracle Database 23c Free
In an earlier article, I showed how to quickly get going with an Oracle Database 23c Free instance in a Gitpod workspace – cloud based, ephemeral, quick start, zero …
Quick to run, free and ephemeral RStudio instance on Gitpod
Triggered by an assignment my son had to do for one of his university courses – and given the fairly light weight laptop we have him work with – …
Apache NiFi: JSON to SOAP
Apache NiFi is a powerful open source integration product. A challenge you might encounter when integrating systems is that one system can produce JSON messages and the other has …
Preparation for migrating data to Oracle Virtual Private Database
August 10, 2021
AMIS, Database, Databases, DBA Oracle, Oracle, Oracle 12, SQL, sqlplus, Technology
No Comments
preparation for migrating data to Oracle Virtual Private Database Introduction Recently I was part of a team involved in the preparation of migration data belonging to multiple business …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)
March 5, 2021
Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, DevOps, PL/SQL, Software Development
No Comments
What’s in a name? A title is important and I hope that it describes well what I do want to share with you in this series of articles. It …
SQL–Only Counting Records Sufficiently Spaced apart using Analytics with Windowing Clause and Anti Join
A nice SQL challenge was presented to me by a colleague. The challenges basically consisted of this table. A table contains records that describe login events. Each record has …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (6)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
1 Comment
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)”, I told you about Git, Subversion, Maven and Flyway. In …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)”, I told you about the Oracle SQL Developer Data Modeler. …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)”, I told you about the Oracle Database and Oracle APEX. …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)”, I did show you the database structure. This time I …
How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)
February 26, 2021
DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development
No Comments
Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)”, I gave you an introduction. This time I will elaborate …
Quickly Run NodeJS Demos in Vanilla Windows Sandbox featuring Scoop
TL;DR – this article describes how Windows Sandbox can be used to prepare a well known environment for demonstrations, tutorials, tests etc. Scoop is a great package manager for …
Run Automated Step-by-Step Browser Scenarios for Instruction or Demo from NodeJS applications with Playwright
TL;DR; Run demonstrations or instructions of browser actions. Allow the user to pause and skip acts, and to reset and switch scenarios. Allow the user to interact with the …
How to APIfy WhatsApp – Programmatic interaction with WhatsApp from Node using Playwright
Sending WhatsApp messages from services and applications has been a frequent request from our customers. It also was something I would have liked to use in workshops and demonstrations. …
How to dynamically Schedule EM Blackouts after PatchTuesday
November 7, 2020
Enterprise Manager, AMIS, DBA Oracle, PL/SQL, Platform Technology, Tools
No Comments
In the organization I’m currently working for, the OS-patch schedule depends on PatchTuesday (PT) just as Microsoft, Adobe or Oracle are using. And PatchTuesday is, as you all know, …
Quickest route to Your First Handson Experience with GraalVM – Katacoda Scenario with live environment and step by step tutorial
TLDR: This Katacoda Scenario has a live runtime environment with GraalVM 20.1 prepared for you including an easy to click-through step by step scenario that does a live demonstration …
Azure Pipelines: publish to Azure Artifacts
This article is a follow-up to my previous article about using Azure Artifacts for own NPM modules. In that article I showed how to create a NPM module by …
Using Azure Artifacts for your own NPM modules
Currently I am working on a customer project in which we build a lot of Azure (serverless) functions, mostly in Javascript. Sometime ago we foresaw that we need some …
Override Date.now() based on OS time when Node returns incorrect current date
I was facing a weird issue. In my Node application – version 10.6.3 – running on Ubuntu – 18.04 – I got the wrong value for the current date …
Finally, sftp from an Oracle database using plain plsql
![Finally, sftp from an Oracle database using plain plsql]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Finally, sftp from an Oracle database using plain plsql")
Just a quick blog to get me through the Christmas eve. More than 5 years ago I wrote a blog about FTPS from an Oracle databse. In that blog …
Node JS application running on GraalVM – interoperating with Java, Python, R and more
When you install GraalVM, one of the things you get is a Node runtime environment (GraalVM 19.2.1 is based on Node 10.16.3 – with support for the core Node …
Python application running on GraalVM and Polyglotting with JavaScript, R, Ruby and Java
GraalVM is among other things a polyglot language runtime. It can run applications written in many languages – JVM languages like Java, Scala, Groovy and Kotlin as well as …
Create a Native Image Binary Executable for a Polyglot Java Application using GraalVM – using build time class initializing
GraalVM provides a runtime component that enhances the JVM in several ways. It makes the JIT compilation better. It also allows the JVM to run non-JVM languages such as …
Oracle Database: Write arbitrary log messages to the syslog from PL/SQL
Syslog is a standard for message logging, often employed in *NIX environments. It allows separation of the software that generates messages, the system that stores them, and the software that …
Leverage NPM JavaScript Module from Java application using GraalVM
Interoperability from Java to JavaScript has been an objective for the Java community for quite a while. With GraalVM, there is great way to run JavaScript code from within …
Graceful shutdown of forked workers in Python and JavaScript running in Docker containers
You might encounter a situation where you want to fork a script during execution. For example if the amount of forks is dependent on user input or another specific …
JavaScript Pipelining using Asynchronous Generators to implement Running Aggregates
As of ES 2018 (recent browsers or Node 10), JavaScript support asynchronous generators. Generators are functions that return a set of values, one value at a time. These values …
JavaScript Generators – How functions return a stream of results, yielding one result at a time
It was through inspecting some Python code that relied quite heavily that I suddenly realized the beauty of the ES6 concept of generators and the yield keyword. A generator …
Building a Conference Session Agenda with Oracle APEX – notes on Pivot, Modal Popup and jQuery
AMIS is part of the Conclusion ecosystem of over 20 companies, each with their own specialty and identity. Several times per year, we organize Conclusion on Stage – a …
Some neat APEX tricks while building a Session Like application for our Conference
AMIS is part of the Conclusion ecosystem of over 20 companies, each with their own specialty and identity. Several times per year, we organize Conclusion on Stage – a …
Some Notes on my small steps with Oracle APEX
In this article, I will share some of my personal findings and discoveries as I start out building a small APEX application. No experienced developer is likely to learn …
Quickly developing and hosting your friendly neighbourhood application – for free using … Oracle APEX
My challenge: my wife wants to set up a system for some of our friends and relatives to let each other know about appliances and things they can share …
Session Catalog for Oracle OpenWorld & CodeOne 2018 in JSON files
The Oracle OpenWorld and CodeOne 2018 conferences took place in the last week of October 2018. Together, over 1500 sessions took place. The session catalog with details for all …
Querying connected data in Graph databases with Neo4j
TL;DR; · Graph databases are ideal for query use cases with data with complex relationships and layers of connections · Its query language is fast, efficient and allows for …