YugabyteDB is a distributed SQL database that supports both hash and range partitioning schemes for its primary key columns. It allows users to specify the number of tablets they want a table to have, which can be done using the SPLIT INTO clause in the CREATE TABLE statement. The database also supports row-level locking options on SELECT statements, including FOR UPDATE, FOR SHARE, and FOR KEY SHARE, which can be used to lock rows retrieved by the SELECT statement. Additionally, YugabyteDB has new documentation, blogs, tutorials, and videos available, covering topics such as data sharding strategies, operational best practices, and getting started with local installs. The database is also hiring for various positions, including frontend engineers, software engineers, developer advocates, and more.