Company
Date Published
Author
Dorian Hoxha
Word count
1208
Language
English
Hacker News points
None

Summary

YugabyteDB provides several ways to save the results of YSQL commands to a file, including using the \o filename command. To specify multiple hosts for the YSQL client to use, the client can be configured with a list of hostnames or IP addresses in the connection settings. The yb-ctl command is used to create and manage YugabyteDB clusters on a single local machine, but it cannot be used to monitor or manage multi-node clusters created using manual deployment methods. To extract a date from a timestamp using YSQL, the `login_time::date` cast function can be used. Additionally, YSQL provides an equivalent to MySQL's group_concat function called string_agg, which can be used to concatenate non-NULL values from a group. The latest blog posts, tutorials, and videos are available on the YugabyteDB website, including articles on automating deployments with Google Cloud Deployment Manager and getting started with distributed SQL colocated tables.