Guides

Task-oriented walkthroughs for the things you’ll actually do with Sqkon — query your data, page through it, expire it, and keep your tests fast. Each page is self-contained; skim the list and jump to whatever you need.

If you’re new, the first three pages are the fundamentals — querying, traversing nested fields, and ordering results. The rest cover capabilities you’ll reach for as your store grows.

Querying & shaping results

• Querying — type-safe Where DSL, operators, AND/OR/NOT composition.
• Nested fields — .then(...) for paths into nested objects and list elements.
• Ordering — sort with OrderBy, multi-field precedence, ASC/DESC.

Reading at scale

• Paging — selectPagingSource (offset) and selectKeysetPagingSource (keyset).
• Flow — every read returns a Flow; how change propagation and dedup work.
• Performance — when JSONB is fast, when it isn’t, and how to keep queries cheap.

Lifecycle & data integrity

• Expiry — TTL semantics, eviction strategies, and stale reads.
• Transactions — multi-write atomicity and Flow emission timing.
• Migrations — schema and serialization migrations.

Working with your data classes

• Serialization tips — @SerialName, value classes, sealed hierarchies, enums.
• Testing — in-memory drivers, MainScope teardown, Turbine patterns.

---

Table of contents

• Querying
• Nested fields
• Ordering
• Paging
• Expiry / TTL
• Reactive flows
• Transactions
• Serialization tips
• Migrations
• Performance
• Testing