Grant Permissions to a MySQL User on Linux via Command Line

Reading Time: 2 minutes

Preflight Check

  • These instructions are intended for granting a MySQL user permissions on Linux via the command line
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
Continue reading “Grant Permissions to a MySQL User on Linux via Command Line”

Create a MySQL User on Linux via Command Line

Reading Time: < 1 minute

Pre-Flight Check

  • These instructions are intended for creating a MySQL user on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
Continue reading “Create a MySQL User on Linux via Command Line”

Creating and Deleting a PostgreSQL Database on Ubuntu 16.04

Reading Time: 2 minutes

PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems.

Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language.  In this tutorial, we will be demonstrating some essentials like creating, listing and deleting a database.

Continue reading “Creating and Deleting a PostgreSQL Database on Ubuntu 16.04”

Install and Connect to PostgreSQL 10 on Ubuntu 16.04

Reading Time: < 1 minute

PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes database schemas and in the query language.  In this tutorial, we will show you how to install and connect to your PostgreSQL database on Ubuntu 16.04.

 

Continue reading “Install and Connect to PostgreSQL 10 on Ubuntu 16.04”

Select a MySQL Database on Linux via Command Line

Reading Time: 2 minutes

Pre-Flight Check

  • These instructions are intended for selecting a MySQL database on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
Continue reading “Select a MySQL Database on Linux via Command Line”

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 VueJS 3 CLI, GUI & Plugins – Part 4

Reading Time: 7 minutes

Intro 

In the last tutorial, we learned how to install Vue 3 CLI and gone over a few of the new features which were shipped with it. 

In this article, we will go over two features that are really something new in the world of JavaScript Frameworks. These features are Plugins and Graphical User Interface. 

Continue reading “How To Install VueJS 3 CLI, GUI & Plugins – Part 4”

What Is WSGI?

Reading Time: 2 minutes

Have you ever wondered how Python web applications work on an Apache or NGINX web server? The answer is WSGI or Web Server Gateway Interface.

Python is rapidly gaining in popularity for various web applications and software options. WSGI is one of the numerous powerful frameworks that are enabling this forward-looking acceptance. You may be new to Python web applications and wondering how this type of application is deployed in a production environment or you may have already used this type of framework previously, but want to know more about what WSGI is. 

Continue reading “What Is WSGI?”

3 Tips For Working With a MySQL Database!

Reading Time: 2 minutes

Pre-Flight Check

  • These instructions are intended for deleting a MySQL database on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
Continue reading “3 Tips For Working With a MySQL Database!”