After creating a local cluster for the TiDB database and visualizing the existing database via the show database command, I decided to create a database. And like many open-source databases, TiDB simplifies this activity by using a simple command as “create database.” Therefore, this post shows how quickly create a new database followed by the latest display of the existing databases: brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and…
Category: TiDB
TiDB – SHOW DATABASES Command
After creating a local TiDB platform, I would like to get started with some typical commands, such as listing the databases. Therefore, this post presents an example of how to display the databases to the connected user who has access: Note*: “The information_schema database always appears first in the list of databases.” Source: https://docs.pingcap.com/tidb/dev/sql-statement-show-databases brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil,…
Quickly deploy of a TiDB database for mac OS (macOS) – local test cluster
This post is about deploying a TiDB database in a non-productive environment. I intend to try the features of Hybrid Transactional and Analytical Processing (HTAP) workloads of this open-source distributed SQL database. It was mind-blowing when I heard about the possibility of a database maintaining the scalability of a NoSQL database while keeping the ACID transactions of a relational database. Therefore, I will follow the procedure “Deploy a local test cluster” found on the official documentation for MacOS as below: 1- Download and install TiUP: Command: Execution: 2- Declare the…