Dockerizing an MSSQL Server (header image)

Dockerizing an MSSQL Server: Unlocking Flexibility

Alex Cassells Databases, Development Technologies, Docker, SQL, Tutorial Leave a Comment

Docker is a pretty magical tool that streamlines server and environment setup while helping to eliminate the operating system and software version variables. It’s one of the best ways to mitigate the classic ‘Works on my machine!’ obstacle many developers run into when sharing or promoting their code.

When a lot of people think of Docker, the last thing they think of is Microsoft or Windows. It took many years for Docker to even officially support Windows. As a .NET developer, I always wanted the stability that Docker offers, and today, I can have it. In the post below, I’ll dive into how to dockerize an MSSQL Server.

Sequelize Command Line and Migration

Sequelize ORM: Interacting with databases using Node

James Fielder Databases, Development Technologies, Programming Leave a Comment

Today, we are going to be going over a very useful tool called Sequelize. It is an Object Relational Mapper (ORM), which allows us to interact with relational databases using Node.js.

Sequelize supports many different databases, but in this blog, we will be using MySQL. We will go over how to set up a local MySQL instance and a Node.js server using Sequelize to communicate with it.

Along the way, we’ll learn basic Sequelize functionally, such as the command line tool and migrations, to understand how to work with the database…

Apollo Client and GraphQL

Apollo Client: State Management for GraphQL Made Easy

Braden Niswonger Development Technologies, GraphQL, JavaScript, Programming, React Leave a Comment

In this post, we will explore Apollo Client integrated with a React application and how it provides an abstraction layer between a JavaScript application and a GraphQL server. The features Apollo Client offers make it a prime choice for devs also using GraphQL.

We’ll begin by discussing what Apollo Client is and how it can be advantageous over other state management libraries. And finally, we will look at some example React queries for retrieving and mutating data.

Let’s get started.

[Video] Data Mining/Science: Supervised Time-Series Model

Keyhole Software Development Technologies, Educational Event, PostrgreSQL, Python, Video Leave a Comment

In this video, Alex presents an introduction to data science “big ideas” relevant to the model, an explanation of its data modeling process, and a demonstration of the real-life machine learning solution implemented with Python, Postgres SQL, and H2O (an open-source machine learning algorithm). Multiple data sources and technologies were combined to create an accurate model that allows farmers and recreationists to make actionable insights about the future. A few questions and answers round out the discussion.