Remember when we diverted a Delimited Text dataset so the Azure Data Factory could read it as XML and dump it into the SQL Server? Fortunately our hack is obsolete by now. The Data Factory now natively supports XML files in Copy Activity and Data Flows. Let’s take a look!

Simple file, easy process
Reading XML files is easy when the file structure is straightforward. Consider the customer file we used in our last post: A customer record has a unique number, a mail address and an operation like “insert” or “update”. …

With the first release candidate of PHP 8 out in the public our previous post about a dev environment based on PHP 7 and MySQL 5.7 (!) is officially outdated. It’s time to update your WAMP stack! As we are aiming at a portable development environment will won’t “install” the components in the usual way but put them together from ZIP versions and configure them all to work together nicely.

Starting with Apache

To host a PHP site we again use it as module in the Apache web server. As suggested by PHP developers first download the latest version of Apache from https://www.apachelounge.com/download/. …

Creating and maintaining high quality web components is hard work. You not only implement the crucial functionality but — for UI components — you also have to make it look nice.
And while reusability is one core aspect of web components, it’s most often bound to the design language used: Simple input fields based on Material Design or Fluent UI work like the other, but look different. You don’t want to implement the component twice, so wouldn’t it be nice to separate functionality and design?

Image for post
Image for post
Look different, but work alike… Implement twice?

Enter Lion, a collection of white-label web components, created by ING (aka ING Diba). The components are open-sourced and available on GitHub. For now Lion concentrates on form and navigation controls, as well as overlays and localization. But apart from buttons and inputs you can also find dialogs and even a calendar. …

For the best part of the last 12 months I am using the Azure stack in one of our clients Data Warehouse projects. Although the vast majority of our input files are comma separated (in some way), there are exceptions. One of these exceptions are XML files. Surprisingly enough they are not supported out of the box in the Copy Activity of the Azure Data Factory and I had to do some workarounds to get it going.

Good news! This workaround is obsolete by now, as Azure Data Factory now natively supports XML datatype for datasets.

Let’s start at the beginning - the naive way
The XML files should be loaded in the Staging Area in our SQL Server instance. Starting there the data is integrated into our Core Data Warehouse. …

It does not necessarily need a major release to add NoSQL-like functionality to a relational database management system. MySQL 5.7.12 introduced to X Plugin without a buzz. It enables you to create, read, update and delete JSON documents without enforcing a schema to the data. Tooling support includes a MySQL Shell for JavaScript and Python as well as connectors for NodeJS, Java, and .NET.

Ever since NoSQL databases have entered the stage there were attempts to extend MySQL to make it more NoSQL-ish. That attempts aimed at either the performance or JSON capabilities, e.g. …

With a variety of different browsers (and rapidly growing number of versions) out there feature detecting is a necessity for web developers. It keeps us from coding into the blue — while relying on the misbelief that all users regularly update their browser. In consequence adding checks into the code whether a specific feature is available helps us to work around vendor prefixes, enables us to use polyfills when necessary, and shields users from bad user experience.

Libraries like Modernizr assist us with detecting JavaScript and CSS features. But those libraries actually step in where browsers can do a good-enough job. Detecting programmatic features is easily done with plain JavaScript. …

Seven currently is the magic number for all fans of the good old LAMP stack. Oracle released the general availability release of MySQL 5.7 in late octobre and PHP 7 just hit the road - leapfrogging from 5.6 and leaving out version 6.

Time goes by and newer PHP / MySQL versions are available. We updated our story to include versions 8 here.

It’s almost a tradition for us to write tutorials on how to install new PHP or MySQL versions on Windows. We repeatedly did so on phpundmysql.de

About

OneBitAhead

The tech staff of OneBitAhead GmbH, putting the web stack to work. Here to discuss daily bits & bytes. #javascript #nodejs #webcomponents #rdbms #php

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store