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

Summary

YugabyteDB's distributed SQL APIs, YSQL and YCQL, have different load balancer requirements due to their underlying client driver implementations, with YSQL relying on PostgreSQL drivers that are not cluster aware or shard aware, while YCQL relies on Cassandra Query Language's smart client drivers. YugabyteDB provides a Spark connector library for YSQL and a JDBC API for YSQL, as well as support for ordering rows by the IN list of values using the VALUES clause or WITH ORDINALITY syntax. To backup a single table in a YSQL database, use the ysql_dump tool with the --table argument, while to list all table names in a YugabyteDB database, query the information_schema.tables view. New documentation and blog posts have been published on various topics, including array data types and functionality, upcoming events, and getting started with YugabyteDB.