feat: Add feature view versioning support to PostgreSQL and MySQL online stores by YassinNouh21 · Pull Request #6193 · feast-dev/feast · GitHub

Summary

Added versioned read/write support to PostgreSQL and MySQL online stores, following the SQLite reference implementation pattern from feat: Add version tracking to FeatureView #6101
When enable_online_feature_view_versioning is enabled, data is routed to version-specific tables (e.g., project_driver_stats_v2)
Registered both stores in _check_versioned_read_support() so version-qualified feature references (driver_stats@v2:trips_today) work correctly

Changes

PostgreSQL (postgres.py):

Updated _table_id() to accept enable_versioning parameter with version suffix logic
Updated all 6 callers: online_write_batch, _construct_query_and_params, update, teardown, retrieve_online_documents, retrieve_online_documents_v2

MySQL (mysql.py):

Updated _table_id() with same versioning pattern
Threaded enable_versioning through _execute_batch(), write_to_table(), and _drop_table_and_index()
Updated online_read, update, and teardown callers

Shared (online_store.py, errors.py):

Added PostgreSQLOnlineStore and MySQLOnlineStore to _check_versioned_read_support() allowlist
Updated VersionedOnlineReadNotSupported error message

Test plan

7 unit tests for PostgreSQL _table_id (no version, disabled, enabled, v0, version_tag priority)
7 unit tests for MySQL _table_id (same coverage)
5 unit tests for _check_versioned_read_support (PostgreSQL/MySQL/SQLite allowed, unsupported raises, no tag no error)
4 PostgreSQL e2e tests with real database (testcontainers): write/read without versioning, with v1, version isolation, teardown
4 MySQL e2e tests with real database (testcontainers): same coverage
27/27 tests passing, all lint checks pass

Closes #6168
Closes #6169
Part of #2728

✅ Devin Review: No Issues Found

Devin Review analyzed this PR and found no potential bugs to report.

View in Devin Review to see 5 additional findings.

@franciscojavierarceo @ntkathole Can you guys check it ?

@ntkathole can you check again ?

…ine stores Add versioned read/write support so that version-qualified feature references (e.g., driver_stats@v2:trips_today) resolve to the correct versioned table in both PostgreSQL and MySQL online stores. Changes: - PostgreSQL: Updated _table_id() and all callers to support enable_versioning - MySQL: Updated _table_id(), _execute_batch(), write_to_table(), and _drop_table_and_index() to thread versioning flag through - online_store.py: Registered PostgreSQLOnlineStore and MySQLOnlineStore in _check_versioned_read_support() - errors.py: Updated VersionedOnlineReadNotSupported message - Unit tests split per store in tests/unit/infra/online_store/ - Integration tests in tests/integration/online_store/ (Docker, testcontainers) Closes feast-dev#6168 Closes feast-dev#6169 Part of feast-dev#2728 Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

…upport Unconditional imports of pymysql and psycopg broke online reads for users on other stores (Redis, DynamoDB, etc.) that don't have these optional dependencies installed. Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

Teardown was only dropping the current version's table, orphaning older versioned tables (e.g. _v1, _v2). Now queries the database catalog to find and drop all versioned tables for each feature view. Also extracts the duplicated _table_id logic from SQLite, MySQL, and Postgres into a shared compute_table_id helper. Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

LIKE _v% could match unrelated tables (e.g. driver_verbose when dropping versions for driver). Switch to REGEXP/~ with _v[0-9]+$ pattern. Also scope Postgres pg_tables query by schemaname. Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

@YassinNouh21 looks like versioning test failing

MySQL DROP TABLE already removes all indexes. The separate DROP INDEX was failing on versioned tables that were created via online_write_batch (which doesn't create the _ek index). Also reuse _drop_table_and_index in _drop_all_version_tables instead of duplicating logic. Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

@ntkathole can you check again ready to be merged ?

# [0.61.0](v0.60.0...v0.61.0) (2026-04-07) ### Bug Fixes * Add grpcio dependency group to transformation server Dockerfile ([2c2150a](2c2150a)) * Add https readiness check for rest-registry tests ([ea85e63](ea85e63)) * Add website build check for PRs and fix blog frontmatter YAML error ([#6079](#6079)) ([30a3a43](30a3a43)) * Added missing jackc/pgx/v5 entries ([94ad0e7](94ad0e7)) * Added MLflow metric charts across feature selection ([#6080](#6080)) ([a403361](a403361)) * Check duplicate names for feature view across types ([#5999](#5999)) ([95b9af8](95b9af8)) * Fix integration tests ([#6046](#6046)) ([02d5548](02d5548)) * Fix missing error handling for resource_counts endpoint ([d9706ce](d9706ce)) * Fix non-specific label selector on metrics service ([a1a160d](a1a160d)) * fix path feature_definitions.py ([7d7df68](7d7df68)) * Fix regstry Rest API tests intermittent failure ([d53a339](d53a339)) * Fixed IntegrityError on SqlRegistry ([#6047](#6047)) ([325e148](325e148)) * Fixed intermittent failures in get_historical_features ([c335ec7](c335ec7)) * Fixed pre-commit check ([114b7db](114b7db)) * Fixed the intermittent FeatureViewNotFoundException ([661ecc7](661ecc7)) * Fixed uv cache permission error for docker build on mac ([ad807be](ad807be)) * Fixes a `PydanticDeprecatedSince20` warning for trino_offline_store ([#5991](#5991)) ([abfd18a](abfd18a)) * Handle existing RBAC role gracefully in namespace registry ([b46a62b](b46a62b)) * Ignore ipynb files during apply ([#6151](#6151)) ([4ea123d](4ea123d)) * Integration test failures ([#6040](#6040)) ([9165870](9165870)) * Mount TLS volumes for init container ([080a9b5](080a9b5)) * **postgres:** Use end_date in synthetic entity_df for non-entity retrieval ([#6110](#6110)) ([088a802](088a802)), closes [#6066](#6066) * Ray offline store tests are duplicated across 3 workflows ([54f705a](54f705a)) * Reenable tests ([#6036](#6036)) ([82ee7f8](82ee7f8)) * SSL/TLS mode by default for postgres connection ([4844488](4844488)) * Use commitlint pre-commit hook instead of a separate action ([35a81e7](35a81e7)) ### Features * Add Claude Code agent skills for Feast ([#6081](#6081)) ([1e5b60f](1e5b60f)), closes [#5976](#5976) [#6007](#6007) * Add complex type support (Map, JSON, Struct) with schema validation ([#5974](#5974)) ([1200dbf](1200dbf)) * Add decimal to supported feature types ([#6029](#6029)) ([#6226](#6226)) ([cff6fbf](cff6fbf)) * Add feast apply init container to automate registry population on pod start ([#6106](#6106)) ([6b31a43](6b31a43)) * Add feature view versioning support to PostgreSQL and MySQL online stores ([#6193](#6193)) ([940e0f0](940e0f0)), closes [#6168](#6168) [#6169](#6169) [#2728](#2728) * Add materialization, feature freshness, request latency, and push metrics to feature server ([2c6be18](2c6be18)) * Add metadata statistics to registry api ([ef1d4fc](ef1d4fc)) * Add non-entity retrieval support for ClickHouse offline store ([4d08ddc](4d08ddc)), closes [#5835](#5835) * Add OnlineStore for MongoDB ([#6025](#6025)) ([bf4e3fa](bf4e3fa)), closes [golang/go#74462](golang/go#74462) * Add Oracle DB as Offline store in python sdk & operator ([#6017](#6017)) ([9d35368](9d35368)) * Add RBAC aggregation labels to FeatureStore ClusterRoles ([daf77c6](daf77c6)) * Add ServiceMonitor auto-generation for Prometheus discovery ([#6126](#6126)) ([56e6d21](56e6d21)) * Add typed_features field to grpc write request (([#6117](#6117)) ([#6118](#6118)) ([eeaa6db](eeaa6db)), closes [#6116](#6116) * Add UUID and TIME_UUID as feature types ([#5885](#5885)) ([#5951](#5951)) ([5d6e311](5d6e311)) * Add version indicators to lineage graph nodes ([#6187](#6187)) ([73805d3](73805d3)) * Add version tracking to FeatureView ([#6101](#6101)) ([ed4a4f2](ed4a4f2)) * Added Agent skills for AI Agents ([#6007](#6007)) ([99008c8](99008c8)) * Added CodeQL SAST scanning and detect-secrets pre-commit hook ([547b516](547b516)) * Added odfv transformations metrics ([8b5a526](8b5a526)) * Adding optional name to Aggregation (feast-dev[#5994](#5994)) ([#6083](#6083)) ([56469f7](56469f7)) * Created DocEmbedder class ([#5973](#5973)) ([0719c06](0719c06)) * Extended OIDC support to extract groups & namespaces and token injection with multiple methods ([#6089](#6089)) ([7c04026](7c04026)) * Feature Server High-Availability on Kubernetes ([#6028](#6028)) ([9c07b4c](9c07b4c)), closes [Hi#Availability](https://github.com/Hi/issues/Availability) [Hi#Availability](https://github.com/Hi/issues/Availability) * **go:** Implement metrics and tracing for http and grpc servers ([#5925](#5925)) ([2b4ec9a](2b4ec9a)) * Horizontal scaling support to the Feast operator ([#6000](#6000)) ([3ec13e6](3ec13e6)) * Making feature view source optional (feast-dev[#6074](#6074)) ([#6075](#6075)) ([76917b7](76917b7)) * Replace ORJSONResponse with Pydantic response models for faster JSON serialization ([65cf03c](65cf03c)) * Support arm docker build ([#6061](#6061)) ([1e1f5d9](1e1f5d9)) * Support distinct count aggregation [[#6116](#6116)] ([3639570](3639570)) * Support HTTP in MCP ([#6109](#6109)) ([e72b983](e72b983)) * Support nested collection types (Array/Set of Array/Set) ([#5947](#5947)) ([#6132](#6132)) ([ab61642](ab61642)) * Support podAnnotations on Deployment pod template ([1b3cdc1](1b3cdc1)) * Use orjson for faster JSON serialization in feature server ([6f5203a](6f5203a)) * Utilize date partition column in BigQuery ([#6076](#6076)) ([4ea9b32](4ea9b32)) ### Performance Improvements * Online feature response construction in a single pass over read rows ([113fb04](113fb04)) * Optimize protobuf parsing in Redis online store ([#6023](#6023)) ([59dfdb8](59dfdb8)) * Optimize timestamp conversion in _convert_rows_to_protobuf ([33a2e95](33a2e95)) * Parallelize DynamoDB batch reads in sync online_read ([#6024](#6024)) ([9699944](9699944)) * Remove redundant entity key serialization in online_read ([d87283f](d87283f))

# [0.62.0](v0.61.0...v0.62.0) (2026-04-08) ### Bug Fixes * Added missing jackc/pgx/v5 entries ([94ad0e7](94ad0e7)) * Fix missing error handling for resource_counts endpoint ([d9706ce](d9706ce)) * fix path feature_definitions.py ([7d7df68](7d7df68)) * Fix regstry Rest API tests intermittent failure ([d53a339](d53a339)) * Fixed intermittent failures in get_historical_features ([c335ec7](c335ec7)) * Fixed the intermittent FeatureViewNotFoundException ([661ecc7](661ecc7)) * Handle existing RBAC role gracefully in namespace registry ([b46a62b](b46a62b)) * Ignore ipynb files during apply ([#6151](#6151)) ([4ea123d](4ea123d)) * Mount TLS volumes for init container ([080a9b5](080a9b5)) * **postgres:** Use end_date in synthetic entity_df for non-entity retrieval ([#6110](#6110)) ([088a802](088a802)), closes [#6066](#6066) * SSL/TLS mode by default for postgres connection ([4844488](4844488)) * Sync v0.61-branch so v0.61.0 tag is reachable from master ([af66878](af66878)) ### Features * Add Claude Code agent skills for Feast ([#6081](#6081)) ([1e5b60f](1e5b60f)), closes [#5976](#5976) [#6007](#6007) * Add decimal to supported feature types ([#6029](#6029)) ([#6226](#6226)) ([cff6fbf](cff6fbf)) * Add feast apply init container to automate registry population on pod start ([#6106](#6106)) ([6b31a43](6b31a43)) * Add feature view versioning support to PostgreSQL and MySQL online stores ([#6193](#6193)) ([940e0f0](940e0f0)), closes [#6168](#6168) [#6169](#6169) [#2728](#2728) * Add metadata statistics to registry api ([ef1d4fc](ef1d4fc)) * Add Oracle DB as Offline store in python sdk & operator ([#6017](#6017)) ([9d35368](9d35368)) * Add RBAC aggregation labels to FeatureStore ClusterRoles ([daf77c6](daf77c6)) * Add ServiceMonitor auto-generation for Prometheus discovery ([#6126](#6126)) ([56e6d21](56e6d21)) * Add typed_features field to grpc write request (([#6117](#6117)) ([#6118](#6118)) ([eeaa6db](eeaa6db)), closes [#6116](#6116) * Add UUID and TIME_UUID as feature types ([#5885](#5885)) ([#5951](#5951)) ([5d6e311](5d6e311)) * Add version indicators to lineage graph nodes ([#6187](#6187)) ([73805d3](73805d3)) * Add version tracking to FeatureView ([#6101](#6101)) ([ed4a4f2](ed4a4f2)) * Added Agent skills for AI Agents ([#6007](#6007)) ([99008c8](99008c8)) * Added odfv transformations metrics ([8b5a526](8b5a526)) * Created DocEmbedder class ([#5973](#5973)) ([0719c06](0719c06)) * Extended OIDC support to extract groups & namespaces and token injection with multiple methods ([#6089](#6089)) ([7c04026](7c04026)) * Replace ORJSONResponse with Pydantic response models for faster JSON serialization ([65cf03c](65cf03c)) * Support distinct count aggregation [[#6116](#6116)] ([3639570](3639570)) * Support HTTP in MCP ([#6109](#6109)) ([e72b983](e72b983)) * Support nested collection types (Array/Set of Array/Set) ([#5947](#5947)) ([#6132](#6132)) ([ab61642](ab61642)) * Support podAnnotations on Deployment pod template ([1b3cdc1](1b3cdc1)) * Utilize date partition column in BigQuery ([#6076](#6076)) ([4ea9b32](4ea9b32)) ### Performance Improvements * Online feature response construction in a single pass over read rows ([113fb04](113fb04))

YassinNouh21 requested review from a team as code owners March 29, 2026 12:56

YassinNouh21 requested review from dmartinol, nquinn408 and redhatHameed and removed request for a team March 29, 2026 12:56

devin-ai-integration Bot reviewed Mar 29, 2026

View reviewed changes

YassinNouh21 force-pushed the feat/postgres-mysql-versioning branch 3 times, most recently from b35410f to 0e56ae2 Compare March 29, 2026 13:17

This comment was marked as resolved.

Sign in to view

YassinNouh21 force-pushed the feat/postgres-mysql-versioning branch from 75923e7 to ca254af Compare April 5, 2026 14:58

YassinNouh21 requested review from franciscojavierarceo and ntkathole April 5, 2026 15:22

ntkathole reviewed Apr 5, 2026

View reviewed changes

Comment thread sdk/python/feast/infra/online_stores/mysql_online_store/mysql.py Outdated

ntkathole reviewed Apr 5, 2026

View reviewed changes

Comment thread sdk/python/feast/infra/online_stores/postgres_online_store/postgres.py

This comment was marked as resolved.

Sign in to view

ntkathole approved these changes Apr 6, 2026

View reviewed changes

YassinNouh21 added 7 commits April 6, 2026 16:34

style: fix ruff formatting for _table_id signatures

0ffa1ec

Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

style: collapse remaining multi-line signatures to single line

8bf0ef7

Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

style: wrap long _drop_all_version_tables signature

386d01a

Signed-off-by: yassinnouh21 <yassinnouh21@gmail.com>

ntkathole force-pushed the feat/postgres-mysql-versioning branch from 4fb6a34 to 386d01a Compare April 6, 2026 11:04

ntkathole added the ok-to-test label Apr 6, 2026

YassinNouh21 self-assigned this Apr 7, 2026

YassinNouh21 force-pushed the feat/postgres-mysql-versioning branch from bcaa701 to e782090 Compare April 7, 2026 09:13

Merge branch 'master' into feat/postgres-mysql-versioning

47b1f36

ntkathole merged commit 940e0f0 into feast-dev:master Apr 7, 2026
27 checks passed

YassinNouh21 deleted the feat/postgres-mysql-versioning branch April 7, 2026 10:40

ntkathole mentioned this pull request Apr 7, 2026

feat: Add SingleStore online store support for feature view versioning #6195

Open

7 tasks

This was referenced Apr 10, 2026

feat: Add feature view versioning support to FAISS online store #6256

Merged

feat: Add feature view versioning support to Redis and DynamoDB online stores #6257

Merged

alekseevpavel04 mentioned this pull request Aug 20, 2026

feat: Support feature view versioning in the Cassandra online store #6766

Open

7 tasks

feat: Add feature view versioning support to PostgreSQL and MySQL online stores by YassinNouh21 · Pull Request #6193 · feast-dev/feast · GitHub

Uh oh!

feat: Add feature view versioning support to PostgreSQL and MySQL online stores - #6193

feat: Add feature view versioning support to PostgreSQL and MySQL online stores#6193
ntkathole merged 9 commits into
feast-dev:masterfrom
YassinNouh21:feat/postgres-mysql-versioning

YassinNouh21 commented Mar 29, 2026 •
edited by devin-ai-integration Bot
Loading

Uh oh!

Uh oh!

devin-ai-integration Bot left a comment

Uh oh!

This comment was marked as resolved.

Uh oh!

YassinNouh21 commented Apr 5, 2026

Uh oh!

Uh oh!

Uh oh!

This comment was marked as resolved.

Uh oh!

YassinNouh21 commented Apr 5, 2026

Uh oh!

ntkathole commented Apr 6, 2026

Uh oh!

YassinNouh21 commented Apr 7, 2026 •
edited
Loading

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

feat: Add feature view versioning support to PostgreSQL and MySQL online stores by YassinNouh21 · Pull Request #6193 · feast-dev/feast · GitHub

Uh oh!

feat: Add feature view versioning support to PostgreSQL and MySQL online stores - #6193

feat: Add feature view versioning support to PostgreSQL and MySQL online stores#6193ntkathole merged 9 commits intofeast-dev:masterfeast-dev/feast:masterfrom YassinNouh21:feat/postgres-mysql-versioningYassinNouh21/feast:feat/postgres-mysql-versioningCopy head branch name to clipboard

Conversation

YassinNouh21 commented Mar 29, 2026 • edited by devin-ai-integration Bot Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Summary

Changes

Test plan

Uh oh!

devin-ai-integration Bot left a comment

Choose a reason for hiding this comment

✅ Devin Review: No Issues Found

Uh oh!

This comment was marked as resolved.

Uh oh!

YassinNouh21 commented Apr 5, 2026

Uh oh!

Uh oh!

Uh oh!

This comment was marked as resolved.

Uh oh!

YassinNouh21 commented Apr 5, 2026

Uh oh!

ntkathole commented Apr 6, 2026

Uh oh!

YassinNouh21 commented Apr 7, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

feat: Add feature view versioning support to PostgreSQL and MySQL online stores#6193
ntkathole merged 9 commits into
feast-dev:masterfrom
YassinNouh21:feat/postgres-mysql-versioning

YassinNouh21 commented Mar 29, 2026 •
edited by devin-ai-integration Bot
Loading

YassinNouh21 commented Apr 7, 2026 •
edited
Loading