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”
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”
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”
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”
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”
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”
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”
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”
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
- Selenium Integrated Development Environment (IDE)
- Selenium Grid
- Selenium RC
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”