Everything hot already lives in Postgres — local data/ was 25 MB of pre-migration relics and unbounded logs. Moved the two dead .duckdb files (untouched since 2026-06-16) to archive/, added nightly log rotation (copy-truncate >20 MB, safe with systemd append mode), and updated the last vestigial "market.duckdb" docstrings to say Postgres, closing the CONSOLIDATION_PLAN cleanup items. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
15 lines
444 B
Python
15 lines
444 B
Python
"""Research database schema — reuses the core market schema."""
|
|
|
|
from __future__ import annotations
|
|
|
|
from pathlib import Path
|
|
|
|
from storage.db import get_connection
|
|
|
|
DEFAULT_RESEARCH_DB = "data/research/market.duckdb" # vestigial label: the PG facade ignores file paths
|
|
|
|
|
|
def get_research_connection(db_path: str | Path = DEFAULT_RESEARCH_DB):
|
|
"""Open (and initialize) the research market database."""
|
|
return get_connection(db_path)
|