[{"id":9,"priority":"low","status":"completed","description":"OAuth2 login flow with Ueberauth Google and GitHub strategies plus Guardian JWT","title":"Implement Ueberauth flow (phase 2)","completed":true,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["security","backend","api"],"project_id":7,"assignee_name":"Dave Kim","complexity":1,"deleted_at":null,"due_date":"2026-05-10","estimated_hours":"28","urgent":false},{"id":12,"priority":"low","status":"in_progress","description":"Generate realistic test data with ExMachina factories for development","title":"Create seed data scripts (phase 1)","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["database","testing"],"project_id":5,"assignee_name":"Dave Kim","complexity":2,"deleted_at":null,"due_date":"2026-01-05","estimated_hours":"6","urgent":false},{"id":19,"priority":"critical","status":"pending","description":"Create reusable LiveComponent chart and metric card components with streams","title":"Build LiveView dashboard","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["liveview","otp"],"project_id":7,"assignee_name":"Alice Chen","complexity":2,"deleted_at":null,"due_date":"2026-02-19","estimated_hours":"10","urgent":true},{"id":21,"priority":"medium","status":"in_progress","description":"PostgreSQL full-text search using tsvector, GIN indexes, and ts_rank ordering","title":"Full-text search with tsvector (phase 2)","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["backend","database","performance","liveview"],"project_id":2,"assignee_name":"Eve Wilson","complexity":1,"deleted_at":null,"due_date":"2026-05-26","estimated_hours":"37","urgent":false},{"id":23,"priority":"critical","status":"in_progress","description":"Automated daily PostgreSQL backups to S3 with WAL-G and pg_dump retention policy","title":"WAL-G backup automation","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["database","devops","infrastructure","performance"],"project_id":7,"assignee_name":"Alice Chen","complexity":1,"deleted_at":null,"due_date":"2026-02-26","estimated_hours":"16","urgent":true},{"id":30,"priority":"critical","status":"in_progress","description":"S3-backed file uploads with Waffle and Mogrify image processing pipeline","title":"Waffle file uploads (phase 3)","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["backend","api","infrastructure"],"project_id":4,"assignee_name":"Grace Park","complexity":2,"deleted_at":null,"due_date":"2026-02-07","estimated_hours":"19","urgent":true},{"id":32,"priority":"critical","status":"pending","description":"Transactional email templates with Swoosh adapter and Oban delivery queue","title":"Swoosh email system","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["backend","infrastructure"],"project_id":4,"assignee_name":"Frank Lee","complexity":2,"deleted_at":null,"due_date":"2026-01-11","estimated_hours":"23","urgent":true},{"id":86,"priority":"high","status":"pending","description":"Implement URL-based API versioning using Plug.Router scopes with deprecation notices","title":"API versioning with Plug.Router","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["api","backend","documentation","infrastructure"],"project_id":1,"assignee_name":"Grace Park","complexity":1,"deleted_at":null,"due_date":"2026-04-18","estimated_hours":"3","urgent":false},{"id":39,"priority":"low","status":"pending","description":"Token bucket rate limiting with Hammer for API endpoints and Plug middleware","title":"Implement Hammer rate limiting (phase 4)","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["security","api","backend","database"],"project_id":2,"assignee_name":"Carol Johnson","complexity":1,"deleted_at":null,"due_date":"2026-06-20","estimated_hours":"3","urgent":false},{"id":59,"priority":"low","status":"pending","description":"Transactional email templates with Swoosh adapter and Oban delivery queue","title":"Swoosh email system","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["backend","infrastructure"],"project_id":6,"assignee_name":"Grace Park","complexity":1,"deleted_at":null,"due_date":"2026-01-25","estimated_hours":"35","urgent":false},{"id":79,"priority":"high","status":"completed","description":"Configure GitHub Actions with mix release for automated testing and Fly.io deployment","title":"Set up Mix releases pipeline","completed":true,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["devops","infrastructure"],"project_id":4,"assignee_name":"Bob Martinez","complexity":1,"deleted_at":null,"due_date":"2026-06-09","estimated_hours":"21","urgent":true},{"id":85,"priority":"medium","status":"in_progress","description":"PostgreSQL full-text search using tsvector, GIN indexes, and ts_rank ordering","title":"Full-text search with tsvector","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["backend","database","performance"],"project_id":6,"assignee_name":"Frank Lee","complexity":2,"deleted_at":null,"due_date":"2026-02-11","estimated_hours":"38","urgent":false},{"id":107,"priority":"low","status":"pending","description":"Add Absinthe GraphQL API alongside PgRest for flexible querying with dataloader","title":"Absinthe GraphQL endpoint","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["api","backend","ux"],"project_id":2,"assignee_name":"Grace Park","complexity":2,"deleted_at":null,"due_date":"2026-03-08","estimated_hours":"27","urgent":false},{"id":104,"priority":"high","status":"completed","description":"Back-office admin interface with LiveView table components and inline editing","title":"LiveView admin CRUD","completed":true,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["liveview","backend","documentation"],"project_id":7,"assignee_name":"Carol Johnson","complexity":1,"deleted_at":null,"due_date":"2026-05-13","estimated_hours":"14","urgent":false}]