Unique Attribute (Column) or Index
Currently the only supported unique attribute is the hash attribute, which is defined when the table is created. It will be great to have more that one unique attribute, and to be able to created an unique attribute after the table has been created.
Comments: 6
-
11 Aug, '20
Zachary FowlerYou are suggesting HarperDB enforce the uniqueness of another field? For example email addresses.
-
12 Aug, '20
dallenYes that would be a nice feature to have.
-
26 Jun, '21
ShivHello! is this fixed?
-
26 Jun, '21
Jacob CohenShiv, we have not yet added this feature to HarperDB. It is still under consideration, but we do not currently have it on our near term backlog. If we bring it into our backlog, the status will change from "Under Consideration" to "Planned". Thanks for your interest!
-
18 Aug, '21
Lucky victoryi think unique attributes can still be created after creating the table,
for instance you can create a unique user_id by passing it as an attribute when inserting a new data, then pass a UUID generator as the value. -
18 Aug, '21
Jacob CohenLucky, as of now, the only attribute where HarperDB will enforce uniqueness is on the hash_attribute. This request is to allow users to set HarperDB to enforce uniqueness on all other attributes.