Automatic detection of provider-side unique and not-null constraints implemented for postgres, spatialite, ogr provider
Client side unique and not-null constraints can be set within QGIS.
Unique constraints are enforced in attribute form