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

Summary

YugabyteDB, a distributed SQL database, offers various query metrics through the `pg_stat_statements` extension, which can be viewed via the "YSQL All Ops" link on the server's utility page or by querying the data directly. The best way to check if a row exists is to use the `EXISTS` keyword with a subquery, as it returns a boolean value instead of `NULL`. YugabyteDB also supports regular expression queries and getting the current timestamp in YSQL, but users must be aware of the differences between plain and timestamp columns. The database has new documentation, blogs, tutorials, and videos available, including topics on polymorphism, GraphQL, and distributed SQL.