codenotary / codenotary/immudb

Unique constraint in SQL (immudb-py)

Open
#897 1 comment 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Go
Stars
9k
Forks
378
Avg merge
3d 1h
Merged PRs (30d)
3

Description

**What would you like to be added or enhanced**
Add UNIQUE constraint to SQL

**Why is this needed**
This will allow to create Candidate Keys within a relational table. (Something which is needed quite often in many cases)

**Additional context**
An example usage of Unique constraint would be:

``CREATE TABLE table1 (id INTEGER, title VARCHAR UNIQUE, active BOOLEAN NOT NULL, PRIMARY KEY id)``

Contributor guide

Open the contributing guide

Research direction

Start by tracing the SQL CREATE TABLE path described in the issue and identify how column and table constraints are parsed and enforced. Review the existing SQL tests before deciding coverage. Done means UNIQUE constraints can be declared as shown and duplicate values are rejected consistently.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.