Connecting to MySQL Using Python

Posted on October 22, 2020 by Matt Holtz | Updated: October 23, 2020
Category: Tutorials | Tags: Browse, Columns, Data, Data Management, Database, Database Management, Databases, drop, Empty, Export, Import, Insert, management, MariaDB, MySQL, MySQL Views, PHPMyAdmin, Primary Key, Python, Python 3, Python Support, Python-PIP, Queries, Query, Range, Run, Schema, Search, SQL, String, Strings, Structure, Table, Tables, Views

Reading Time: 5 minutes

In this article, we will be discussing how to connect to MySQL using Python. Python is one of the most productive and widely used programming languages in use today. Its simple and elegant syntax makes it ideal for new programmers, while experienced programmers enjoy the extensive list of available modules and functionalities.

MySQL is a robust open-source SQL-based, relational database management system that is used in many software programs and web servers. This article aims to show how to connect to use Python to connect to MySQL and perform some basic tasks.

Continue reading →

How to Create and Use MySQL Views

Posted on October 14, 2020 by Matt Holtz | Updated: October 26, 2020
Category: Tutorials | Tags: Browse, Columns, Data, Data Management, Database, Database Management, Databases, drop, Empty, Export, Import, Insert, management, MariaDB, MySQL, MySQL Views, PHPMyAdmin, Primary Key, Queries, Query, Range, Run, Schema, Search, SQL, String, Strings, Structure, Table, Tables, Views

Reading Time: 6 minutes

What is a MySQL View?

A MySQL view is simply an ordinary database object that can save SQL query writers a lot of time when used correctly. A view is a stored query that a user can reference just like a table. Many times users will find themselves using the same base query over and over to solve multiple problems. Views are a way of quickly saving that query and referencing it later.

Continue reading →

How Has Containerization Changed the World?

Posted on July 2, 2020 by Matt Holtz
Category: Tutorials | Tags: Automation, Container, Containerization, Containerized Software, Developer, Development, DevOps, Docker, Environment, Git, Hypervisor, Image, Install, Installation, Kubectl, Kubernetes, KVM, Linux, MiniKube, Platform, Server Administration, Tools, Virtual Machines, VirtualBox, Virtualization, Web Application Development, Web Applications, Web Hosting

Reading Time: 5 minutes

The arrival of containerized software has drastically changed the landscape of web hosting, and web application provides. The simplification and speed that comes with containers make deploying services like websites so efficient that the traditional model of dedicated servers running specific web-based software is almost obsolete. This being said, there will always be a place for virtual server projects and dedicated servers handling specific tasks like HIPAA compliant hosting services.

Continue reading →

How Do I Set Up Setuid, Setgid, and Sticky Bits on Linux?

Posted on March 10, 2020 by Matt Holtz | Updated: June 11, 2020
Category: Tutorials | Tags: Chgrp, Chmod, chown, Execute, File Permissions, Group, Notation, Permission, Permissions, Read, Setgid, Setuid, Special Permissions, Sticky, Sticky Bit, Sticky Bits, User, Write

Reading Time: 6 minutes

What Are Linux File Permissions?

Setuid, Setgid and Sticky Bits are special types of Unix/Linux file permission sets that permit certain users to run specific programs with elevated privileges. Ultimately the permissions that are set on a file determine what users can read, write or execute the file. Linux provides more advanced file permissions that allow you to do more specific things with a file, or directory. Typically, these file permissions are used to allow a user to do certain tasks with elevated privileges (allow them to do things they normally are not permitted to do). This is accomplished with three distinct permission settings. They are setuid, setgid, and the sticky bit.

Continue reading →

Installing Microsoft Powershell on Ubuntu 18.04

Posted on February 7, 2020 by Matt Holtz | Updated: March 25, 2020
Category: Tutorials | Tags: Apt-Get, CLI, Cmdlet, Command-line, File Manager, GitHub, Install, Linux, Microsoft, PowerShell, Remote, Script, Server, Snap, SSH, Terminal, Ubuntu Ubuntu 18, Windows

Reading Time: 5 minutes

If you are a Windows administrator who has recently been tasked with administering a Linux-based Ubuntu server, you may find that utilizing Microsoft Powershell may help ease the transition into Linux, and allow you to be more productive. If you are a Linux administrator who is interested in exploring the options that Powershell provides, then this tutorial is for you as well.

Continue reading →

Introduction to Machine Learning

Posted on January 30, 2020 by Matt Holtz
Category: Tutorials | Tags: Adaptive Methods, Algorithms, bayesian, classification, Clustering, Confusion Matrix, Convergence, Convolutional Neural Networks, decision tree, evolutionary algorithms, fault diagnosis, generalization, Gradient Descent, Learning Mode, Natural Language Understanding, Normalization, parameter tuning, Pattern Identification Recognition, Prediction Predictive Analytics, Probabilistic Graphical Models, Regression, reinforcement learning, Supervised Learning, svm, Unsupervised Learning

Reading Time: 6 minutes

Two of the biggest catchphrases being thrown around today in computing are Artificial Intelligence (AI) and Machine Learning. Many times people use them interchangeably. The truth is that AI encompasses a lot more than just Machine Learning, but Machine Learning is one of the most promising aspects of AI.

Continue reading →

MySQL Performance: MySQL/MariaDB Indexes

Posted on January 23, 2020 by Matt Holtz | Updated: June 12, 2020
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 →

MySQL Performance: Intro to JOINS in SQL

Posted on December 25, 2019 by Matt Holtz | Updated: January 23, 2020
Category: Tutorials | Tags: Database, Database Management, Inner JOIN, JOINS, Left JOIN, MariaDB, Multiple JOIN, MySQL, Outer JOIN, Right JOIN, SQL, SQL Server, Tables, Union

Reading Time: 5 minutes

In this article, we will learn the basics of joining tables in SQL. We will learn about Left, Right, Inner, and Outer joins and give examples of how to use them.

Data in an RDBMS (Relational Database Management System) is grouped into tables. These tables have a rigid definition of the type of data that can be stored in them. To connect different tables, and thus different types of data that may relate to each other, we will use the JOIN clause.

Continue reading →

Liquid Web | Knowledge Base

Author: Matt Holtz

Connecting to MySQL Using Python

Related Articles:

How to Create and Use MySQL Views

What is a MySQL View?

Related Articles:

How Has Containerization Changed the World?

Related Articles:

Installing Microsoft Powershell on Ubuntu 18.04

Related Articles:

Introduction to Machine Learning

Related Articles:

MySQL Performance: MySQL/MariaDB Indexes

Related Articles:

MySQL Performance: Intro to JOINS in SQL

Related Articles:

Search our Knowledge Base

Related Articles:

What is a MySQL View?

Related Articles:

Related Articles:

What Are Linux File Permissions?

Related Articles:

Related Articles:

Related Articles:

Related Articles:

Related Articles:

Sidebar