feat(CockroachDB support): Switch to JSONField for SDK metrics labels

[khvn26]

Thanks for submitting a PR! Please check the boxes below:

• I have added information to docs/ if required so people know about the feature!
• I have filled in the "Changes" section below?
• I have filled in the "How did you test this code" section below?
• I have used a Conventional Commit title for this Pull Request

Changes

This migrates all the labels fields added in #5623 to jsonb as the hstore support turned out to be problematic:

1. The hstore extension requires enabling additional parameter sets in some cloud environments (e.g. Azure).
2. Psycopg2 type adapters don't play well with CockroachDB, which should be compatible otherwise.

Note that due to problem 1, I've removed the CREATE EXTENSION operation from the original migration.

How did you test this code?

Migrations and tests run ok.
Will be smoke-tested against CockroachDB as well.

[vercel]

The latest updates on your projects. Learn more about Vercel for GitHub.

3 Skipped Deployments

Project	Deployment	Actions	Updated (UTC)
docs	Ignored	Preview	Mar 24, 2026 1:52pm
flagsmith-frontend-preview	Ignored	Preview	Mar 24, 2026 1:52pm
flagsmith-frontend-staging	Ignored	Preview	Mar 24, 2026 1:52pm

[github-actions]

Docker builds report

Image	Build Status	Security report
ghcr.io/flagsmith/flagsmith-api-test:pr-5833	Finished ✅	Skipped
ghcr.io/flagsmith/flagsmith-frontend:pr-5833	Finished ✅	Results ✅
ghcr.io/flagsmith/flagsmith-e2e:pr-5833	Finished ✅	Skipped
ghcr.io/flagsmith/flagsmith:pr-5833	Finished ✅	Results ✅
ghcr.io/flagsmith/flagsmith-private-cloud:pr-5833	Finished ✅	Results ✅

[codecov]

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 98.32%. Comparing base (7c8e69d) to head (7f0f7a3).
⚠️ Report is 6 commits behind head on main.

Additional details and impacted files

@@           Coverage Diff           @@
##             main    #5833   +/-   ##
=======================================
  Coverage   98.32%   98.32%           
=======================================
  Files        1335     1337    +2     
  Lines       49876    49910   +34     
=======================================
+ Hits        49039    49073   +34     
  Misses        837      837           

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
• 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

[scarlson]

Confirming this fix allows CockroachDB to work without needing to update Psycopg to 3.1+.

[Zaimwa9]

The migrations look redundant except if I am missing something? Can we see to merge them together maybe ?

[khvn26]

@Zaimwa9 Indeed these migrations look very similar, but their purpose is actually different:

• 0006 adds correct jsonb columns to the tables. The original migration is modified to avoid customers having to add hstore capability to their databases since it's no longer a requirement. This exists primarily for new installations/fresh dbs.
• 0007 alters existing hstore columns to jsonb. This has to happen for installations where previous 0006 migration was already applied.

So, to answer your question, no, we can't merge these migrations as they cater for different scenarios, and I argue they are not in fact redundant.

[Zaimwa9]

Alright thanks for the details, I felt that under the hood there was a migration purpose

[emyller]

I forgot to add as notes to my last review: not actually requesting any changes unless proven necessary by the comment I added.

[krahllucas]

any updates?

[khvn26]

@krahllucas Hello, sorry for the radio silence here — we've just prioritised this and are planning to release it until the end of Q1.

[emyller]

LGTM

[github-actions]

Playwright Test Results (oss - depot-ubuntu-latest-16)

 10 passed

Details

 10 tests across 7 suites
 24.1 seconds
 7f0f7a3
 🔄 Run: #15446 (attempt 1)

Playwright Test Results (oss - depot-ubuntu-latest-arm-16)

 10 passed

Details

 10 tests across 7 suites
 28.4 seconds
 7f0f7a3
 🔄 Run: #15446 (attempt 1)

Playwright Test Results (private-cloud - depot-ubuntu-latest-arm-16)

 16 passed

Details

 16 tests across 13 suites
 1 minute, 3 seconds
 7f0f7a3
 🔄 Run: #15446 (attempt 1)

Playwright Test Results (private-cloud - depot-ubuntu-latest-16)

 1 passed

Details

 1 test across 1 suite
 55.6 seconds
 7f0f7a3
 🔄 Run: #15446 (attempt 1)