That is a long title. In this article, I introduce a Gitpod workspace (cloud based ephemeral development environment) in which you can try out NocoDB – an open source low code application development platform. This is an overview of the workspace: Note: Gitpod is a web service for developers (similar […]
Lucas Jellema
No Install, free polyglot Apache Kafka environment in ephemeral development environment with Node, Java, Python and Go
Click on a button- or this link. Wait about four to five minutes. You will have access to a free cloud based environment with a three-broker-node Apache Kafka Cluster, the AQ HK browser GUI for Kafka and client programs for producing messages and consuming messages in Node, Java, Python and […]
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 (position and points for the championship). If this is the graph, some questions can easily be answered: With whom has a […]
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 SQL query cannot answer. OK, the query can become quite long – with inline expressions and multiple joins – but it […]
Live Handson Environment for Modern Oracle Database Programming
My fellow Oracle ACE Directors and former AMIS-colleagues Patrick Barel and Alex Nuijten have co-authored an impressive book: The book discusses many of the wonders of SQL and PL/SQL – the well and lesser known things you can (and should) do when programming in and against the Oracle Database. Part […]
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 install environment. As part of that workspace, you have access to both SQL*Plus and SQLcl as command line interface to work […]
Oracle Database 23c–Fine Grained Locking–Lock Free Reservations
This should surprise if not baffle you. Session 1 inserts a record and commits it. Session 1 performs an update on this record. And does not yet commit its transaction. Session 2 tries to update that same record …. and is able to! It does not run into a lock. […]
Get going with Oracle Database 23c Free
A new major Oracle Database release is a special occasion. I joined Oracle in May 1994 just after the Oracle7 release (December 1993) although I worked with Oracle6 for a long time after that. I remember the launch of Oracle 8 (with OO support!) in 1996 and the excitement of […]
Maandag 20 maart– open Code Café– open source password manager Bitwarden, Git for Nerds–Fundamentals & Apache Superset data visualization
Op maandag 20 maart vindt weer een Code Café plaats waarin we tools en technologie bespreken en uitproberen. Tussen 17 en 20.30 staan drie onderwerpen op de agenda, eten we met elkaar en gaat we handson ervaring opdoen met de besproken onderwerpen. Als je het leuk vindt om meer te […]
The team has agreed …– the power of suggested recollection
I am not normally a cynic. I trust people’s good intentions. However, I am a little suspicious when an argument in favor or against a specific way of doing something boils down to: “we, the team, have agreed…” (or various flavors that use decided, concluded etc). It may very well […]
Extending Steampipe OCI Plugin with an OCI resource type table
I have written about Steampipe before. And I have stated how much I like this idea of using SQL to access data on cloud resources (and many other types of resources besides). Data is not only more easily accessible in a SQL select statement than in CLI or API calls, […]
Visual Dashboard on Oracle Cloud Infrastructure using Apache Superset and Steampipe
In addition to the OCI Console, there are many ways to inspect the status of Oracle Cloud resources – including the OCI CLI, Terraform, Grafana OCI Plugin, REST API, OCI App. The open source tool Steampipe (Select * from Cloud) enables SQL queries to inspect many non-SQL data sources and […]
Analyze and Visualize data from any cloud and anywhere with Apache Superset and Steampipe
Apache Superset is an open source end user tool for analyzing and visualizing data. Dozens of chart types are available out of the box, dashboards can be created, finetuned and shared/published. Superset can work with virtually any SQL data source. (I have recently written an introduction to Superset and created […]
Getting started working with Apache Superset – the open source data exploration and visualization platform
Apache Superset is an open source platform for data exploration and visualization. It can be described as an open, free alternative for Microsoft PowerBI, Tableau, Qlik and Oracle Analytics Desktop. Superset connects (through the SQL Alchemy framework) to dozens of SQL compliant databases and can work with CSV and JSON […]
News Flash: OCI DevOps – Deployment runner for Shell Stage
Oracle Cloud Infrastructure DevOps is a service I have written about on several occasions. The OCI DevOps service provides an Artifact Repository, Git Code repositories, Build Pipelines and Deployment Pipelines that know how to interact with the runtime environments OKE, Oracle Functions and Compute VM. The news flash is that […]
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 – I decided to make a cloud based RStudio environment to him. I have worked with Gitpod over the past six months, […]
How Cheppy thrills and acceleraties us at AMIS–and what it does not yet do
ChatGPT is a bit of a “tongue twister” so I will speak of Cheppy. AMIS has a long history of spotting, exploring, embracing and rolling out new concepts and technologies . It something we like doing – a trait of the organisation- and are good at and successful with. That […]
Mont Blanc is [not] the highest mountain–risk of local optimization
The best solution may not be the best solution. Depending on the scope in which you consider the alternatives, you may arrive at the wrong conclusion. Consider only the problem at hand, there may be an apparently easy solution that in the grander scheme of things is not optimal and […]
Five part article series introducing Go on OCI
Go – sometimes Golang because internet searching for just “go” is quite impossible – is a popular programming language. It was initially launched in 2012 and as been gaining popularity ever since. It has embraced many of the good things from other languages including Java and improved on a number […]
OCI Function Parameters based on Vault Secrets–an enhancement request
OCI Functions are powerful components in a cloud native world. Triggered by events and direct requests, these functions are engaged to perform a specific task. Which could be almost anything (as long as it does not take too long). And it can certainly be some task that requires access to […]
Use it .. or lose it. On Application and Feature decommissioning
“Can we let go of that office building?” (we pay rent, utilities, furniture – is that still necessary or justified) “Well, I believe Chris is still making use of that building.” Chris: “my team meets Wednesday morning every other week in one of the conference rooms in that building.” (Chris’ […]
Dynamic Configuration of Terraform plans and Stacks in Oracle Cloud Infrastructure
Some of the data used by Terraform to create cloud resources is sensitive and should not be stored in plain text in source code repositories. Examples are passwords, client secrets, API tokens. Even though the Terraform configurations are (infrastructure as) code – not every element can be treated as code. […]
Terraform – injecting local and remote Configuration Data
This article describes how a Terraform plan can read configuration data at plan and application time from local or remote JSON documents to provide dynamic, easily and centrally maintainable settings that guide the provisioning process. Terraform variables are static: they are assigned using their default value (which cannot use function […]
Many ways to provision Oracle Cloud Resources using Terraform
Terraform is used for automated provisioning of resource on Oracle Cloud Infrastructure. Resources are defined in HCL – the DSL used in Terraform for describing infrastructure – and these definitions are processed by the OCI provider for Terraform that turns the definitions into the required calls to the OCI REST […]
Create Terraform Stack and Apply it to Provision Resources on Oracle Cloud Infrastructure
Terraform is the tool of choice for automated provisioning of cloud resources on Oracle Cloud Infrastructure (IaC). In two recent articles, I have demonstrated how to create a plan with resource definitions to be processed by the OCI provider for Terraform and how to (re)use a Terraform Module to allow […]
Terraform Modules, For-Each, File Set on Oracle Cloud
The creation of cloud resources on Oracle Cloud Infrastructure is ideally done as Infra as Code using Terraform (plans). No hands need to touch the console, no permissions need to be given to individual users and all actions can be previewed, tested and easily repeated. The support for Terraform in […]
Terraform from Cloud Shell for OCI resource creation through Infra as Code
The creation of cloud resources on Oracle Cloud Infrastructure is ideally done as Infra as Code using Terraform (plans). No hands need to touch the console, no permissions need to be given to individual users and all actions can be previewed, tested and easily repeated. OCI has deep support for […]
Delayed Delivery in OCI Queue Service–time based message release
Messages published to an Oracle Cloud Infrastructure (OCI) Queue may not immediately be intended for consumption. It is a not uncommon requirement to make messages available for consumption only at a specific moment in time, rather than right away. OCI Queue does not currently have built in support for a […]
Generic OCI Resource manipulation with OCI CLI Raw Request
I should have been aware of it – but I was not. The generic OCI CLI Raw Request option – the uniform approach to any OCI resource query or manipulation through OCI CLI. With raw request, each call looks like this: oci raw-request –http-method POST –target-uri API-ENDPOINT/API-PATH/resourcetype/resource-OCID –request-body file://request.json The […]
First Steps with OCI Queue Service–fully managed massively scalable FIFO queue
In an earlier article, I have explored the promise of OCI Queue – a managed queue service launched in December 2022. In this article I will show my first real activities with OCI Queue. Small steps, granted. But surely helpful to give you some idea of what this service is […]
OCI Queue– simple, powerful, heavy duty reliable decoupling
The new OCI Queue Service provides a straightforward offering: publish messages into a persisted store and allow consumers to retrieve these messages from that store – the oldest message first (FIFO). Interaction with OCI Queue can be done through REST API calls or through the STOMP-protocol (the Simple (or Streaming) […]
Quickest way to run a container on Oracle Cloud Infrastructure: container instances
Container Instances on Oracle Cloud Infrastructure are VM based environments that can be leveraged as “serverless” container runtimes. Once a container instance has been defined – which is a very simple, rapid procedure – we can specify the container images (OCI – open container initiative – compliant) for which containers […]
Oracle Cloud Infrastructure–flutter of activity: Queue, Container Instances
Over the last few days, in this pre-Holiday season period, Oracle has released a number of interesting new services and updates to existing services. I plan on exploring them in more detail in the coming weeks. (note: the illustration is courtesy of StableDiffusion – using the prompt “a painting of […]
Unified Auditing not possible for Oracle Database XE (Express Edition)
I recently tried to get Unified Auditing going for Oracle Database XE. I could not really find instructions – not even through ChatGPT – and finally reached out to Gerald Venzl, the community champion at Oracle who is one for the key people behind Oracle Database XE. I learned from […]
GitHub Copilot reduces writing Java boilerplate to two simple comments
GitHub Copilot helped me write a Java application to process a CSV file. Not a hard task – though one that in Java always feels much harder than in Python or Node. This time round – because of Copilot – all I have to was write two simple instructions (and […]
Overhead of Service Mesh–measuring and comparing Istio, Linkerd, Kuma and Consul
A Service Mesh can provide many facilities regarding traffic management between microservices – from simple routing and load balancing, producing telemetry to applying complex routing logic and security policies. This layer of logic that is applied on top of what services are doing themselves is not free: additional latency is […]
Run your own instance of Backstage in 3 minutes
Backstage is the Developer Portal Platform that has come out of Spotify and now lives under the CNCF (Cloud Native Compute Foundation) umbrella where it is one of the most popular and active projects. Backstage provides a framework an starting point for what typically evolves into your highly customised developer […]
Running OpenTelemetry Demo in Gitpod Workspace–two click install
Recently the OpenTelemetry project launched a demo application that demonstrates many aspects of instrumentation, metrics and trace gathering, providing insight across multi-service, multi-technology application stacks and in general how to leverage OpenTelemetry. The application architecture for the demo stack looks like this: A front end web application – a web […]
Gitpod workspace for instant Dapr explorations
I have prepared a Gitpod wokspace definition that allows me to start a fresh development environment with the latest release of Dapr (dapr.io) installed as well as supporting containers that provide state store (Redis, MySQL) and Pub/Sub (Redis) capabilities. This environment is a perfect starting point for trying out Dapr, […]
Gitpod for Oracle Cloud Infrastructure development
Gidpod provides ephemeral development environments. Run a Gitpod workspace and get a clean environment with precisely those components that have been configured for the use case or context you need to work in. Everytime a workspace is initialized and everyone who does that, the environment will be exactly the same. […]