Company
Date Published
Author
Marko Rajcevic
Word count
1102
Language
English
Hacker News points
None

Summary

YugabyteDB provides a connection pooling mechanism that allows users to reuse the PostgreSQL query layer, making it easier to integrate with existing third-party integrations. Users can connect to their Yugabyte Cloud Database using the YSQL API and various IDEs and drivers, such as DBeaver and DataGrip. The database supports SERIALIZABLE and SNAPSHOT transaction isolation levels, which are mapped to SQL isolation levels REPEATABLE READ and SERIALIZABLE, respectively. Optimistic locking is currently supported, while pessimistic locking is being worked on. Adding a column to a large table in YSQL can be done using an ALTER TABLE command, but there may be limitations for non-nullable columns with default values. YugabyteDB has new documentation, blogs, tutorials, and videos available, including fine-grained control for high availability, people and potential stories, and upcoming events such as the Distributed SQL Summit Asia 2021.