Module db 

Database layer for the kasl application.

Provides a complete data persistence layer built on SQLite, offering type-safe database operations for all application entities. Implements a migration system for schema evolution and provides specialized modules for different data types.

Features

• Core Infrastructure: Connection management and migrations
• Time Tracking: Workdays and pause records for activity monitoring
• Task Management: Tasks, templates, and organizational features
• Productivity Analytics: Data aggregation and reporting support

Usage

use kasl::db::{db::Db, tasks::Tasks, workdays::Workdays};
use kasl::libs::task::Task;

let db = Db::new()?;
let mut tasks = Tasks::new()?;
let task = Task::new("Review code", "Check PR #123", Some(75));
tasks.insert(&task)?;

use kasl::db::{tags::{Tags, Tag}, templates::{Templates, TaskTemplate}};

// Create and manage tags
let mut tags = Tags::new()?;
let tag_id = tags.create(&Tag::new("urgent".to_string(), Some("red".to_string())))?;

// Work with task templates
let mut templates = Templates::new()?;
let template = TaskTemplate::new(
    "daily-standup".to_string(),
    "Attend daily standup meeting".to_string(),
    "Team sync and planning".to_string(),
    100
);
templates.create(&template)?;

Performance Considerations

Indexing Strategy

• Temporal Queries: Optimized indexes on timestamp columns
• Relationship Lookups: Efficient foreign key index coverage
• Search Operations: Selective indexes for common query patterns

Connection Management

• Connection Reuse: Long-lived connections for better performance
• Transaction Batching: Grouped operations for improved throughput
• Statement Preparation: Cached prepared statements for repeated queries

Data Volume Handling

• Pagination Support: Efficient handling of large result sets
• Selective Loading: Fetch only required fields for large tables
• Archive Strategy: Data retention policies for long-term usage

Migration Best Practices

Schema Evolution

// Adding a new column (backward compatible)
tx.execute("ALTER TABLE tasks ADD COLUMN priority INTEGER DEFAULT 1", [])?;

// Creating new indexes for performance
tx.execute("CREATE INDEX idx_tasks_priority ON tasks(priority)", [])?;

// Adding new tables with proper foreign keys
tx.execute("CREATE TABLE task_dependencies (
    id INTEGER PRIMARY KEY,
    task_id INTEGER NOT NULL,
    depends_on INTEGER NOT NULL,
    FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
    FOREIGN KEY (depends_on) REFERENCES tasks(id) ON DELETE CASCADE
)", [])?;

Version Control Integration

• Sequential Versioning: Each migration increments the version number
• Descriptive Names: Clear migration names describing the change
• Testing Requirements: All migrations must be tested before deployment
• Rollback Planning: Consider rollback implications for schema changes

Platform-Specific Considerations

File System Integration

• Windows: Handles path length limitations and permission requirements
• macOS: Integrates with application sandbox restrictions
• Linux: Follows XDG base directory specifications

Backup and Recovery

• Export Functionality: Complete data export in multiple formats
• Import Validation: Schema validation during data import
• Corruption Recovery: Database integrity checks and repair options

Development and Debugging

Debug Features

• Migration Inspection: View current schema version and history
• Query Logging: Optional SQL query logging for performance analysis
• Connection Monitoring: Track active connections and lock contention

Testing Support

• In-Memory Databases: Fast test execution with temporary databases
• Fixture Management: Consistent test data setup and teardown
• Migration Testing: Automated testing of schema changes

Modules

db

Core database connection and initialization module.

jira_inbox

Local inbox of assigned open Jira issues.

jira_statuses

Catalog of Jira status id → name pairs synced from issues. Local catalog of Jira workflow statuses (id → name).

migrations

Database schema migration system.

pauses

Break and pause tracking operations.

tags

Task categorization and organization system.

tasks

Core task management operations.

templates

Reusable task template system.

workdays

Daily work session tracking.