Tag: Show Databases

Reading Time: 13 minutes

What is ClickHouse?

ClickHouse is an open-source column-oriented DBMS (or database management system) primarily used for OLAP (or the Online Analytical Processing of queries). It is capable of blazing fast generation of real-time analytical data and reporting utilizing SQL queries. It is fault tolerant, scalable, highly reliable and contains a feature rich tool set.

Reading Time: 8 minutes

Introduction

In this tutorial, we will examine what Neo4j is, what it is used for, and how it is implemented. We will also install and configure the installation on an Ubuntu 20.04 server. Neo4j is a graphical database used to create data relationships. Other examples of graphical databases include:

Reading Time: 6 minutes

Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.

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.

Login to MySQL

First we'll log in to the MySQL server from the command line with the following command:

Reading Time: 1 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. As part of our PostgreSQL series, we’ll show you how to list and switch between databases quickly.
 

Reading Time: 2 minutes