Skip to main content

Prefixed IDs for Django stored as UUID7 in PostgreSQL

Project description

django-niceid

IDs look like user_1KGGWGM8FEABRJA533GJKYW0B in Python and APIs, while PostgreSQL stores them as native UUID values (sortable, compact, index-friendly).

Why

  • Ordering: Natural ordering behavior just like integer auto-increment IDs.
  • Global Uniqueness: Unlike auto-incredemt IDs.
  • Clarity: Keep globally unique IDs while still having human-recognizable prefixes like user_ or org_.
  • Efficiency: Store IDs as native UUID in PostgreSQL instead of strings.
  • Performance: Better index locality than random UUIDv4 by using time-ordered UUIDv7.
  • Consistency: Standardize ID parsing/validation across Django models, routes, forms, and serializers.
  • Friendly: Crockford base32 keeps IDs compact and human-friendly in URLs and APIs. No 0 v O or I v L, only upper-case. Easy to dictate and read from logs, screenshots, errors.

Requirements

  • Python 3.14+ (uuid.uuid7 in the standard library)
  • Django 5.1+
  • PostgreSQL 18+ with native UUID support and a built-in uuidv7() function

Install

pip install django-niceid

Optional integrations:

pip install django-niceid[drf]      # Django REST Framework
pip install django-niceid[ninja]    # Django Ninja
pip install django-niceid[pydantic] # Pydantic v2 schemas
pip install django-niceid[tortoise] # django-tortoise ORM bridge

Quickstart

Add the app to INSTALLED_APPS:

INSTALLED_APPS = [
    # ...
    "niceid.apps.NiceIDConfig",
]

Define a model with a class-level namespace (2–16 lowercase letters or underscores):

from niceid.models import NiceIDModel


class User(NiceIDModel):
    namespace = "user"

    class Meta:
        # your options
        pass

Each row gets a primary key like user_1KGGWGM8FEABRJA533GJKYW0B. The value is generated by PostgreSQL via db_default=uuidv7() and exposed in Python as a NiceID instance.

PostgreSQL uuidv7()

On PostgreSQL 18+, uuidv7() is available without extra setup. Ensure your database supports it before running migrations:

SELECT uuidv7();

URL converter

The app config registers a path converter named niceid:

from django.urls import path

urlpatterns = [
    path("users/<niceid:user_id>/", user_detail),
]

user_id in the view is a NiceID instance.

Optional integrations

Django REST Framework

from niceid.drf import NiceIDSerializerField, NiceIDRelatedField

class UserSerializer(serializers.ModelSerializer):
    id = NiceIDSerializerField(read_only=True)
    team_id = NiceIDRelatedField(queryset=Team.objects.all(), source="team")

Django Ninja

Install django-niceid[ninja]. Field registration runs automatically in NiceIDConfig.ready().

Pydantic

Install django-niceid[pydantic]:

from pydantic import BaseModel
from niceid import NiceID

class Payload(BaseModel):
    user_id: NiceID

ID format

Part Rule
Namespace [a-z_]{2,16}
Separator _
Encoded UUID 25 Crockford base32 characters (UUIDv7)

Example: user_1KGGWGM8FEABRJA533GJKYW0B

Limitations (v0.1.0)

  • PostgreSQL only for database fields (native UUID column + uuidv7() default).
  • Python 3.14+ only.
  • Non-primary-key NiceIDField usage requires an explicit namespace= on the field.

Development

pip install -e ".[dev]"
pytest -m "not postgres"
docker compose up -d
POSTGRES_HOST=localhost POSTGRES_PORT=54329 pytest -m postgres

See CONTRIBUTING.md.

License

MIT — see LICENSE.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django_niceid-0.2.0.tar.gz (7.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

django_niceid-0.2.0-py3-none-any.whl (9.5 kB view details)

Uploaded Python 3

File details

Details for the file django_niceid-0.2.0.tar.gz.

File metadata

  • Download URL: django_niceid-0.2.0.tar.gz
  • Upload date:
  • Size: 7.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for django_niceid-0.2.0.tar.gz
Algorithm Hash digest
SHA256 cd5dbc1680523b3c46095a5dd06a9f5780868efc0449b5641e9acf7660ce2881
MD5 2c51f662024dc468a5188139c239077c
BLAKE2b-256 18091deafeed738e2751fc934e849ad503fb84ae20bb632a12e513f4bfbec92e

See more details on using hashes here.

Provenance

The following attestation bundles were made for django_niceid-0.2.0.tar.gz:

Publisher: release.yml on owais/django-niceid

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file django_niceid-0.2.0-py3-none-any.whl.

File metadata

  • Download URL: django_niceid-0.2.0-py3-none-any.whl
  • Upload date:
  • Size: 9.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for django_niceid-0.2.0-py3-none-any.whl
Algorithm Hash digest
SHA256 25fd02b3bb3c9269a7f7173cb64d59af835b20a3ceffe64abecf6ad737f8b8d9
MD5 4e53cfa11b97a286c065ce76c4315e01
BLAKE2b-256 94018d7a0ecc0f9182b483f937d35e6808a3c0ad3c09aa0e9fbe74b663bc6e3c

See more details on using hashes here.

Provenance

The following attestation bundles were made for django_niceid-0.2.0-py3-none-any.whl:

Publisher: release.yml on owais/django-niceid

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page