Distributed SQL Tips and Tricks – Feb 7, 2020

YugabyteDB is a distributed SQL database that offers strong consistency, continuous availability, and long-term data persistence as fundamental design principles. It leverages an in-memory block cache for good read performance, even when the dataset doesn't fit entirely in RAM. YugabyteDB supports multi-region deployment options, including synchronous replication across data centers with automatic resilience against data center failures. The YSQL API adheres to PostgreSQL's error codes in most cases, but returns YugabyteDB-specific error codes for system-specific errors. YugabyteDB auto-recovery from failures is typically within a few seconds, depending on the heartbeat interval set by the user. To view tables in JetBrains DataGrip, users need to enable standard JDBC metadata instead of PostgreSQL-specific metadata. Additionally, new documentation, blogs, tutorials, and videos have been published, including updates on yb-ts-cli, server-server encryption, and upcoming meetups and conferences.