Is there more to Kafka than the usual producer and consumer API? In a previous article, this question was raised to introduce alternative solutions offered by Kafka for designing and building stream processing applications. Streams (Kafka Streams API) rich library was presented as such an alternative to the known producer and consumer. Why the...
Even as an experienced consultant, you don't think about many things until you are faced with them. I have put several InnoDB clusters including MySQL router into operation over the past few years. Up to now, this was always an interactive process where it was no problem to simply enter the passwords of privileged users (at the console). It was cle...
Configuration files are a constant source of errors. Especially with older systems (before version 8.0), which did not yet have the possibility to make online persistent changes (e.g. "set global persist…"), there were often minor problems. The parameter was set online (but volatile; i.e. not rebootable) due to a lack of downtime and was written to...
The GeoJSON format (https://de.wikipedia.org/wiki/GeoJSON) is a popular exchange format because it is supported by many applications. In addition, the JSON structure makes it easy to read for both humans and machines.With the help of the procedure "sdo_util.from_geojson" provided by Oracle Spatial the format can be converted very easily into the da...
I use PowerShell almost daily to access data in Oracle databases. Why, especially in this combination, I want to present by means of an example. But first there will be a few words about the used technology. Why PowerShell? Quite simply: Because it's there. Completely without the installation of additional components, PowerShell is pres...
Is there more to Kafka than the usual producer and consumer APIs? Kafka, the event streaming platform, is usually known for its producer and consumer APIs allowing applications to write, store and retrieve events from the platform in a decoupled way. In the age of ubiquity of compute resource and huge volume of data being generated, it offers the p...