René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Feature request: Table filters for tabular persisters","articleBody":"Hi, first of all thanks for amazing work.\n\n## Problem / use-case\n_Is your feature request related to a problem? Please describe._\n\nLet me start with describing our use case. We are dev tool platform and most of data for our users are organized in \"branches\". And we want to use TinyBase to synchronize these between browsers, IDEs, Cloudflare Workers/Durable Objects and Postgres. \n\nBecause data are thanks to the branches logically partitioned we want to create TinyBase Store per branch. Because as user works on one branch we don't need any other data. Also companies may over time collect a lot of abandoned branches that are unused so scoping per branch will keep it reasonably small.\n\nBut I believe that this is might be quite common, as things are often organized in projects, rooms, organizations, ...\n\n## Feature request\n_Describe the solution you'd like_\n\nIt would be great to be able to define filters on table definitions (that logically map to something like `where branchId = \"xyz\"`) when creating persister, which would instruct it what data it should load for given table. \n\nIf I understand the source code right the condition would come [here](https://github.com/tinyplex/tinybase/blob/main/src/persisters/common/database/commands.ts#L93-L95) in `loadTable` command but also on other places where currently all rows get deleted (eg [here](https://github.com/tinyplex/tinybase/blob/main/src/persisters/common/database/commands.ts#L216) and [here](https://github.com/tinyplex/tinybase/blob/main/src/persisters/common/database/commands.ts#L283))\n\n## Alternatives\n_Describe alternatives you've considered_\n\nUnfortunately we haven't found any alternative that would allow us to synchronise only part of tables","author":{"url":"https://github.com/jakubriedl","@type":"Person","name":"jakubriedl"},"datePublished":"2025-04-24T15:44:47.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/233/tinybase/issues/233"}