MySQL Performance: MySQL/MariaDB Indexes

Posted on January 23, 2020 by Matt Holtz
Category: Series, Tutorials | Tags: Clauses, database, database management, Database Structure, Indexes, insert, JOINS, MariaDB, MySQL, Primary Key, queries, query, Row, search, select, SQL, sql server, table, tables, Update

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 →

How To Install SQLAlchemy

Posted on January 21, 2020 by David Singer | Updated: January 23, 2020
Category: Tutorials | Tags: CentOS, databases, DBAPI, developer, Expression, Firebird, git, Informix, language, Mapper, mapping, Microsoft SQL, MySQL, object, Oracle, ORM, pip, pip3, PostgreSQL, Python, Python 3, Python classes, python-pip, Raw SQL, Relational, SQL, SQL Expression Language, SQLAlchemy, SQLite, sqlite3, Sybase, tables, toolkit, Ubuntu, utilities, venv, virtualenv

Reading Time: 7 minutes

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 →

Managed Server vs. Unmanaged Server Defined

Posted on January 17, 2020 by David Singer
Category: Tutorials | Tags: Capabilities, Core Managed, dedicated server, environment, fully managed, Managed, Managed Server, Resources, server, server management, services, Solutions, Unmanaged, Unmanaged Server

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 →

How to Install TensorFlow on CentOS

Posted on January 16, 2020 by Justin Palmer
Category: Tutorials | Tags: application, CentOS, CentOS 8, Conda, data management, Data Science, Fintech, installation, IoT, Linux, machine learning, machine learning models, Python, Python 3, Python shell, Python Support, Python web application, python-pip, smb, Tensorflow, tensorflow platform, venv, virtualenv, Web Application Development, Web Applications

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 Uninstall Software on Ubuntu

Posted on January 15, 2020 by Alison Gray | Updated: January 16, 2020
Category: Tutorials | Tags: apt, apt-get, Autoremove, cli, Command-line, commandline, commands, Dependencies, dpkg, Flags, grep, less, package management, Purge, remove, server, server administration, server management, software, Ubuntu, Ubuntu 18.04, uninstall

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 Install and Use Git-Secret

Posted on January 14, 2020 by David Singer
Category: Tutorials | Tags: bash, encrypt, encryption, git, git repo, Git-Hook, git-secret, github, GnuPG, GPG, GPG Key, GPG Keypair, Keypair, keys, PGP, private keys, public keys, Security, Security Practices, Ubuntu, Ubuntu 18.04

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 Selenium Tools on Ubuntu 18.04

Posted on January 10, 2020 by Nickolas Newell | Updated: January 14, 2020
Category: Tutorials | Tags: Automation, IDE, Integrated Development Environment, Jar, Java, JavaScript, Open Source, Plugin, QTP, Same Origin, Selenium, Selenium Grid, Selenium RC, Testing Automation, Testing Framework, Testing Tool, UFT, Unified Functional Testing, Web Application Development, Web Applications, WebDriver

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 Setup a Python Virtual Environment on CentOS

Posted on January 9, 2020 by Justin Palmer | Updated: January 17, 2020
Category: Tutorials | Tags: application, CentOS, CentOS 8, data management, Data Science, Fintech, IoT, machine learning, Python, Python 3, Python shell, Python Support, Python web application, python-pip, smb, venv, virtualenv, Web Application Development, Web Applications

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 →

What is Selenium?

Posted on January 7, 2020 by Nickolas Newell | Updated: January 14, 2020
Category: Tutorials | Tags: Automation, IDE, Integrated Development Environment, Jar, Java, JavaScript, Open Source, Plugin, QTP, Same Origin, Selenium, Selenium Grid, Selenium RC, Testing Automation, Testing Framework, Testing Tool, UFT, Unified Functional Testing, Web Application Development, Web Applications, WebDriver

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

Selenium Integrated Development Environment (IDE)
Selenium Grid
WebDriver
Selenium RC

Continue reading →

How To Install Chef On CentOS 7

Posted on January 6, 2020 by Denis Bosack | Updated: January 14, 2020
Category: Tutorials | Tags: ansible, Automation, CentOS, CentOS 7, chef, Chef-Manage, cookbooks, deployment, devops, IaC, Infrastructure as Code, Open Source, Organization, playbook, provisioning, puppet, remote management, ROR, ruby-on-rails, server administration

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 →

Search our Knowledge Base

What is Git-Secret?

Introduction

Parts of the Selenium Testing Suite

What is Chef?

What is IaC?

Sidebar