Inquiry about primary key support for Views — update operations not recognized in subscriptions

[GEFNENEN]

Hi SpacetimeDB team,

I'm using SpacetimeDB for real-time game state sync, and I've run into an issue with View subscriptions: because Views lack primary keys, the client SDK can't pair insert+delete operations as updates. This means onUpdate callbacks never fire—we only get separate insert and delete events.

I understand Views currently don't support primary keys by design, and I've heard there might be plans to add this in the future. Could you share:

1. Is primary key support for Views still on the roadmap? Any rough timeline or current status?
2. If it's not coming soon, do you have any recommended workarounds for subscription scenarios that need proper update detection?

My use case involves pushing aggregated multi-table data via Views to clients, where distinguishing actual updates (vs. separate insert/delete pairs) matters for smooth gameplay.

This limitation is currently blocking a clean implementation for real-time game state sync. I'd really love to see primary key support for Views land soon—it would make Views truly viable for reactive applications. Fingers crossed it's high on the priority list! 🙏

Thanks for your work on SpacetimeDB—appreciate any insight you can share! 😊

[GEFNENEN]

Just to add some context: I've been using SpacetimeDB for almost a year now—started with v1.1.2 back when RLS was still the norm, and every new release genuinely got me excited 😄. I adopted Views right after they launched and quickly hit this limitation. Since then, I've been waiting for a fix and occasionally seeing others in Discord run into the same issue—it's been about 3 months now.

I really don't want to go back to RLS—Views are exactly what I need, just missing this one crucial piece. Hoping it can be prioritized! 🙏

[joshua-spacetime]

@GEFNENEN yes primary keys for views is something we've talked about. I don't have a timeline I can share, but we will be releasing more view features in the coming weeks once 2.0 is out the door. For right now, if you need primary keys you'll have to materialize and update the view manually by just writing to a table. But we'll try to add some level of primary key support in the next few weeks.

Out of curiosity, are you using procedural views or the query builder?

[GEFNENEN]

@joshua-spacetime I am currently not using Query Builder but rather Procedural Views, which I find more in line with my usage habits.

Could you tell me if there's a significant performance difference between the two?