clockworklabs / clockworklabs/SpacetimeDB
Multi Column Primary Keys
Nobody has claimed this yet.
- Dominant language
- Rust
- Stars
- 25.2k
- Forks
- 1.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 46
Description
We already have btree and hash indicies but the hash index route for mutli column indices is not ideal to enfore the uniqueness invariant in a convenient way.
This would also be immensily usefull for procedural view primary keys because you could actually determine a pk for a subset of your data :>
Requested by @kistz via the SpacetimeDB site.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing the existing btree and hash index paths, with particular attention to how hash indices handle multiple columns. The work is complete when multi-column primary keys can enforce uniqueness conveniently and support primary keys for subsets of procedural view data.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- rust
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100