Tag: drop

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: 6 minutes

What is ArangoDB?

ArangoDB is a high availability and scalable multi-model NoSQL database that natively works with graphs and documents and includes a full-text search. It is a free, open-source software developed and maintained by ArangoDB GmbH. The system supports three different data models with one database core and includes a unified query language called AQL (ArangoDB Query Language). This query language is declarative and allows the combination of different data access patterns in a single query. The software can be implemented on multiple systems, including Windows, macOS, Linux, Kubernetes, Docker, and on our Managed Cloud. It has a strong community support base on GitHub, StackOverflow, Google Groups, and Slack. 

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: 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. 

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.  

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: 4 minutes

This tutorial assumes you’ve already logged in to PhpMyAdmin. Now let’s familiarize ourselves with databases and PhpMyAdmin.

Reading Time: 2 minutes

Next Series:
MySQL via Command Line 102: Basic User Interaction

Reading Time: 2 minutes

• These instructions are intended for removing 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.

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

Reading Time: 2 minutes