MySQL Performance: MySQL/MariaDB Indexes

Reading Time: 6 minutes

Data in a MySQL/MariaDB database is stored in tables. A simple way of thinking about indexes is to imagine an extensive spreadsheet. This type of system is not always conducive to quick searching; that’s where an index becomes essential. If there is no index, then the database engine has to start at row one and browse through all the rows looking for the corresponding values. If this is a small table, then it is no big deal, but in larger tables and applications where there can be tables with millions and even billions of rows, it becomes problematic. As you can imagine, searching through those rows one by one will be time-consuming, even on the latest hardware. The solution is to create an INDEX (or more than one) for your data.

Continue reading “MySQL Performance: MySQL/MariaDB Indexes”

How To Install SQLAlchemy

Reading Time: 7 minutes
sqlalchemy logo

The SQLAlchemy Toolkit and Object Relational Mapper is an extensive set of utilities for working with Python and databases. This toolkit provides a package full of popular persistence patterns, designed for economical and robust database accessibility. SQLAlchemy allows a developer to use simple SQL statements (unlike other Object Relational Mapping tools) which provide a helpful method to connect database tables with user-defined Python classes. The SQLAlchemy Object Relational Mapping tool is primarily centered on using the SQL Expression language.

Continue reading “How To Install SQLAlchemy”

Managed Server vs. Unmanaged Server Defined

Reading Time: 8 minutes

In this article, we will be discussing what it means to employ a “managed server” versus an “unmanaged server” and what the primary differences are. This article is written in response to ongoing questions we see from clients regarding the types of resources, services, and capabilities that are included when a managed server is selected for use.

Continue reading “Managed Server vs. Unmanaged Server Defined”

How to Install TensorFlow on CentOS

Reading Time: 4 minutes

In this tutorial, we are going to take a look at how to get started with TensorFlow on CentOS. We will be covering two methods. First, we will take a look at installing TensorFlow in a Python virtual environment via the Python package manager pip. After that, we will walk through installing TensorFlow via the Anaconda package manager. Finally, we will cover building a TensorFlow pip package from source.

Continue reading “How to Install TensorFlow on CentOS”

How to Uninstall Software on Ubuntu

Reading Time: 5 minutes

In this article, we will be discussing the various methods and techniques used to locate and uninstall the software from a Ubuntu/Debian based server. We will primarily be using the apt and dpkg commands on the command line.

Continue reading “How to Uninstall Software on Ubuntu”

How to Install and Use Git-Secret

Reading Time: 3 minutes

What is Git-Secret?

Git-secret is a bash tool that is used to store your private files and information inside of a git repo on your server. The git-secret tool allows us to encrypt sensitive files that are stored inside a secure, encrypted repository. In this article, we will be examining the process of installing and working with git-secret on an 18.04 Ubuntu Server.

Continue reading “How to Install and Use Git-Secret”

How To Install Selenium Tools on Ubuntu 18.04

Reading Time: 9 minutes

In our last article on Selenium, we touched on the tools that the software provides for testing web applications. In this article, we will review the installation of these tools and some basic tests that can be run using the following tools. 

  • Selenium IDE 
  • Selenium Grid
  • Selenium WebDriver

We will go through each of the Selenium tools in the order that is listed below. So let’s begin by installing Selenium IDE. After this, we will cover the basic usage of each of the tools. 

Continue reading “How To Install Selenium Tools on Ubuntu 18.04”

How to Setup a Python Virtual Environment on CentOS

Reading Time: 5 minutes

In this tutorial, we are going to cover how to set up a Python virtual environment on CentOS. A Python virtual environment makes it possible to install Python packages into a discreet Python ecosystem that is entirely separate from your system’s default Python framework. This means that you do not have to worry about overwriting the installation of any current packages that might be defaulted to the existing version of Python on your system.

Continue reading “How to Setup a Python Virtual Environment on CentOS”

What is Selenium?

Reading Time: 3 minutes

Introduction

Selenium is a suite of open-source testing tools for web apps that can be utilized across multiple platforms and browsers. Selenium is comprised of four different tools, each providing a different testing capability.

Parts of the Selenium Testing Suite

    null
  • Selenium Integrated Development Environment (IDE)
  • Selenium Grid
  • WebDriver
  • Selenium RC
Continue reading “What is Selenium?”

How To Install Chef On CentOS 7

Reading Time: 3 minutes

What is Chef?

Chef is a popular, open-source, IaC (Infrastructure as Code) management tool. It eases administration, configuration, and deployment of server resources across a network from a central location. 

What is IaC?

IaC (or Infrastructure as code) is the procedure of provisioning, coordinating, and controlling servers via machine-readable files, that are defined in commonly reused records called cookbooks rather than physical hardware configuration or interactive configuration tools.

Continue reading “How To Install Chef On CentOS 7”