Posts by agoddard
Azure Containers
Azure Containers Just as Virtual Machines or “VMs” virtualize physical machines, Containers virtualize operating systems. Containers are designed to “bundle” what is minimally required (executables, binary code, libraries, and configuration files) to run a tiny microservice or a huge application in any environment. Containers thus provide an easy way to run applications without having to manage…
Read MoreCreating a Simple Azure App Service Web App
The Azure App Service is a Platform as a Service (or PaaS) offering from Microsoft. It’s a component that provides resources for deploying web applications and for making deployed web applications accessible by HTTP clients. You can use it to host web applications, REST API’s and backend services for mobile applications in almost any programming language…
Read MoreExploring Azure Cosmos DB
Azure Cosmos DB is a fully managed NoSQL database designed for modern app development. Microsoft states that “…any web, mobile, gaming, and IoT application that needs to handle massive amounts of data, reads, and writes at a global scale with near-real response times for a variety of data will benefit from Cosmos DB…”. In this post I want to demonstrate…
Read MoreCreating a Docker Application
Create a project To create a Docker application, you need an application and a (Docker) image file. In this example we’ll use a very simple Python script as the application, so we have to create 2 files: A “py” file (the python script that will contain the code to be executed) A ‘Dockerfile’ file (the…
Read MoreExploring PostgreSQL with pgAdmin
PostgreSQL is a powerful, open-source object-relational database system with 30+ years of active development that has earned it a formidable reputation for reliability, feature robustness, and performance. In this post I want to show how you can get started quickly with PostgreSQL by creating a sample database and running some simple queries against it using…
Read MoreBasic SQL Functions – Part 3: GROUP BY Statement
So far, we have gone over the SELECT, FROM and WHERE clauses. These three clauses are used to control what we are seeing in a view. What if we want to control how what we are searching for appears in the view, that is where GROUP BY comes in. The GROUP BY clause is used…
Read MoreBasic SQL Functions – Part 4: ORDER BY Statement
Similar to the GROUP BY clause, the ORDER BY clause also determines how the data is displayed in the view and not so much what the view is displaying. The ORDER BY clause controls the order in which records appear in a view. The order can be determined by the numerical magnitude if it is…
Read MoreBasic SQL Functions – Part 5: JOINS
Now that we have set a basis for how to control a view from one table, we should have enough knowledge to tackle how we incorporate information from two or more tables into one view. Joining in SQL is extremely useful and is used time and time again in a relational database. Often times we…
Read MoreEuclid Studio: Navigating the Business Rules Node
Using the Business Rules Node in Euclid Studio is an extremely effective way of managing business rules, giving you total control over their scope and impact. It’s important to understand the tool’s options and settings before adjusting or implementing new rules. In this example, we’ll go through the basic options and settings of the node.…
Read MoreEuclid Studio: Connecting to a database via JDBC
When using an ETL and modeling tool like Euclid Studio, it’s extremely likely that you’ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you’ve logged into Euclid Studio and created/opened your flow, hover over the ‘Server’ menu at the top…
Read More