Learn application development
Transactions
Transactions are a sequence of operations performed as a single logical unit of work. These operations can modify multiple tables or rows. Transactions are important to maintain data integrity when multiple users are modifying the same set of rows across tables. For example, credit and debit transactions in a bank account.
Text search
YugabyteDB supports advanced text search schemes like similarity search, phonetic search, and full-text search, along with the standard pattern matching using the LIKE operator.
Aggregations
When performing analytical operations on your data, it is common to fetch aggregates like min, max, sum, average, and so on.
Batch operations
Sometimes it's better to batch multiple statements into one request to avoid round trips to the server. In YSQL, this can be done using Stored Procedures, which are not supported in the YCQL API.
Date and time
Although date and time are common concepts, working with dates and times across various time zones can be quite a challenge.
Strings and text
Text, string, and character data types are probably some of the most commonly used types when designing a schema. YugabyteDB provides an extensive suite of functionality to format and manipulate text data types.
Data expiration
Cleaning up old, unwanted data can be a painful task. YugabyteDB supports Time-to-Live (TTL) functionality in the YCQL API which you can use to automatically purge old data and reduce storage costs.