AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
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 […]
0 
0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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. […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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, […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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, […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 “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’ […]
0 0 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. […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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) […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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 […]
0 0 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, […]
0 0 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. […]
0 0 
