ysqlsh is the shell for interacting with the YugabyteDB YSQL API. To connect to a database, you need the following information: the […]
Read More
Find All Table Columns Storing Some Value
A long time ago a database developer asked me how she could produce a list of all table columns in the database […]
Read MoreMaintain a History of YSQL Commands
ysqlsh is a shell for interacting with the YugabyteDB YSQL API. By default, the commands that you type are kept in a […]
Read MoreBetter Performance on JSONB Data Value Search with a GIN Index
YSQL supports the JSON and JSONB data types which both can store JSON (JavaScript Object Notation) data. JSON stores an exact copy […]
Read More