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
Set a YugabyteDB ysqlsh Variable Equal To a Query Result
If you’ve worked with ysqlsh, the shell for interacting with the YugabyteDB YSQL API, you are probably familiar with the set meta-command. […]
Read MoreReset Forgotten YSQL Admin User Password
Some 20 years ago I started a new job with a company in Pittsburgh as an Oracle DBA. The first task given […]
Read MoreSave on Typing SQL Commands using Variables
There are going to be SQL commands that you issue repeatedly. To avoid typing them every time you need them, you can […]
Read MoreShow the Number of YSQL Connections per Node via the Command Line
We learned in the tip LIST THE SERVERS IN YOUR CLUSTER that in YSQL we can list the nodes (hosts) in our […]
Read More