> ## Documentation Index
> Fetch the complete documentation index at: https://powersync-raw-tables-dotnet.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Advanced Topics

> Sync Streams topics you only need when a specific condition applies to your data, source database, or deployment.

These pages cover situations that do not apply to every project. Use them when a specific condition applies to your data, source database, or deployment. For pages that every project needs, see [Writing Queries](/sync/streams/queries) and the other Usage pages.

<CardGroup>
  <Card title="Reducing Bucket Count" icon="chart-line-down" horizontal href="/sync/advanced/reducing-bucket-count" />

  <Card title="Client ID" icon="key" horizontal href="/sync/advanced/client-id" />

  <Card title="Case Sensitivity" icon="font-case" horizontal href="/sync/advanced/case-sensitivity" />

  <Card title="Compatibility" icon="code-merge" horizontal href="/sync/advanced/compatibility" />

  <Card title="Storage Version 4" icon="hard-drive" horizontal href="/sync/advanced/storage-version-4" />

  <Card title="Sync Data by Time" icon="clock" horizontal href="/sync/advanced/sync-data-by-time" />

  <Card title="Schemas and Connections" icon="database" horizontal href="/sync/advanced/schemas-and-connections" />

  <Card title="Multiple Client Versions" icon="code-branch" horizontal href="/sync/advanced/multiple-client-versions" />

  <Card title="Partitioned Tables (Postgres)" icon="table" horizontal href="/sync/advanced/partitioned-tables" />

  <Card title="Sharded Databases" icon="server" horizontal href="/sync/advanced/sharded-databases" />
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.