The ysqlsh CLI is the shell for interacting with the YugabyteDB YSQL API. The -h (or –host) flag specifies the host name […]
Read More
Presplit a Materilized View into a Specific Number of Tablets
For larger tables and indexes that are hash-sharded, we can specify the number of initial tablet splits desired as part of the […]
Read MoreDisplay Queries that Internal Commands Generate
As you explore the ysqlsh interactive shell, it’s useful to know that you can view the SQL queries executed for each meta-command […]
Read MoreRecover Recently Deleted Data Using Follower Reads
YugabyteDB is a transactional database that supports distributed transactions. A transaction is a sequence of operations performed as a single logical unit […]
Read MoreMake a Database Read Only
The YugabyteDB YSQL (PostgreSQL compatble) API supports the creation of multiple databases. You can create a new database using the CREATE DATABASE command. […]
Read More