A foreign key in YSQL is used to maintain the referential integrity of data between two tables: values in columns in one […]
Read MoreQuickly Test xCluster Active-Active Multi-Master Replication with yugabyted
xCluster replication is YugabyteDB’s implementation of asynchronous replication for disaster recovery. It allows you to set up one or more unidirectional replication flows between […]
Read MoreConnect to YSQL with YSQLSH and a JDBC URL
ysqlsh is the shell for interacting with the YugabyteDB YSQL API. To connect to a database, you need the following information: the […]
Read MoreDon’t forget to upgrade the YSQL system catalog
YugabyteDB stores YSQL system metadata, referred to as the YSQL system catalog, in special tables. The metadata includes information about tables, columns, […]
Read MoreMove Data from One Table to Another Table in One Command
You can move data from one table to another in two SQL commands, an INSERT followed by a DELETE. But it’s possible […]
Read More