René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cannot use SQLite as the SQL registry","articleBody":"## Expected Behavior \n\nfeature_store.yaml with SQLite as sql registry works.\n```\nproject: my_project\n# By default, the registry is a file (but can be turned into a more scalable SQL-backed registry)\n# registry: data/registry.db     # \u003c--- works with file registry but not with sqlite as sql registry.\nregistry:\n  registry_type: sql\n  path: sqlite:///data/registry.db\n# The provider primarily specifies default offline / online stores \u0026 storing the registry in a given cloud\nprovider: local\noffline_store:\n  type: file\nonline_store:\n    type: sqlite\n    path: data/online_store.db\nentity_key_serialization_version: 3\n# By default, no_auth for authentication and authorization, other possible values kubernetes and oidc. Refer the documentation for more details.\nauth:\n    type: no_auth\n```\n\n\n## Current Behavior\n\n```\nfeature_store = FeatureStore(repo_path=\".\")\n...\nOperationalError: (sqlite3.OperationalError) database is locked\n[SQL: INSERT INTO feast_metadata (project_id, metadata_key, metadata_value, last_updated_timestamp) VALUES (?, ?, ?, ?)]\n[parameters: ('my_project', 'last_updated_timestamp', '1754965241', 1754965241)]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)\n```\n\n## Steps to reproduce\n\nCreate a project/repository structure.\n```\nmy_project/feature_repo\n├── data\n│   └── driver_stats.parquet\n├── example_repo.py\n└── feature_store.yaml\n```\n\nRun.\n```\nfeature_store = FeatureStore(repo_path=\".\")\n```\n\nexample_repo.py:\n```\n# This is an example feature definition file\n\nfrom datetime import timedelta\n\nfrom feast import (\n    Entity,\n    FeatureService,\n    FeatureView,\n    Field,\n    FileSource,\n    Project,\n)\nfrom feast.feature_logging import LoggingConfig\nfrom feast.infra.offline_stores.file_source import FileLoggingDestination\nfrom feast.types import Float32, Int64\n\nproject = Project(name=\"my_project\", description=\"A project for driver statistics\")\n\ndriver_hourly_stats = FileSource(\n    name=\"driver_hourly_stats_source\",\n    path=\"data/driver_stats.parquet\",\n    timestamp_field=\"event_timestamp\",\n    created_timestamp_column=\"created\",\n)\n\n# You can think of an entity as a primary key used to fetch features.\ndriver = Entity(name=\"driver\", join_keys=[\"driver_id\"])\n\ndriver_hourly_stats_view = FeatureView(\n    name=\"driver_hourly_stats\",\n    entities=[driver],\n    ttl=timedelta(days=1),\n    # The list of features defined below act as a schema to both define features\n    # for both materialization of features into a store, and are used as references\n    # during retrieval for building a training dataset or serving features\n    schema=[\n        Field(name=\"conv_rate\", dtype=Float32),\n        Field(name=\"acc_rate\", dtype=Float32),\n        Field(name=\"avg_daily_trips\", dtype=Int64, description=\"Average daily trips\"),\n    ],\n    # Tell FEAST to materialise into online store.\n    online=True,\n    source=driver_hourly_stats,           # \u003c--- Link to the raw data storage technology\n    tags={\"team\": \"driver_performance\"},\n)\n\n# This groups features into a model version\ndriver_activity_v1 = FeatureService(\n    name=\"driver_activity_v1\",\n    features=[\n        # driver_hourly_stats_view[[\"conv_rate\", \"acc_rate\"]],  # Sub-selects a feature from a feature view\n        driver_hourly_stats_view,\n    ],\n    logging_config=LoggingConfig(\n        destination=FileLoggingDestination(path=\"data\")\n    ),\n)\n\n```\n\n### Specifications\n\n- Version:\n```\nimport feast\nfeast.__version__\n\n'0.51.0'\n```\n- Platform: MacOS M2 (15.5 (24F74))\n- Subsystem: Python 3.11\n\n## Possible Solution\n","author":{"url":"https://github.com/oonisim","@type":"Person","name":"oonisim"},"datePublished":"2025-08-12T02:32:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":8},"url":"https://github.com/5565/feast/issues/5565"}