Distributed SQL Tips and Tricks – April 3, 2020

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.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.