dora-query-pipeline

Database query lifecycle management standardizes statement allocation, polling, cancellation, and reaping to prevent memory leaks and stale data. It ensures consistent execution behavior and memory-safe statement reaping across different database engines.

Engine-specific cancellation applies clear rules for propagating cancellation signals across Postgres, SQLite, and DuckDB. It manages concurrency and server-side cancellation support to ensure robust state management during query execution.

Result isolation between frontend tabs requires structured query lifecycle management to separate execution states. Standardizing polling and cancellation ensures each tab receives isolated result sets without cross-contamination from concurrent queries.

A statement state machine for query execution tracks allocation, polling, and cancellation phases to prevent stale data and memory leaks. It provides robust state management required for memory-safe statement reaping and consistent lifecycle behavior.

Query lifecycle management applies to backend query services and frontend data providers requiring robust state management and concurrency control. It supports Tauri applications by standardizing execution paths and ensuring proper cancellation signal propagation.