[{"id":10,"priority":"low","status":"pending","description":"Nebulex distributed caching with local ETS and partitioned adapter for hot resources","title":"Implement Nebulex caching","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["performance","backend","infrastructure"],"project_id":7,"assignee_name":"Bob Martinez","complexity":10,"deleted_at":null,"due_date":"2026-05-27","estimated_hours":"39","urgent":false},{"id":16,"priority":"high","status":"pending","description":"Structured logging with Logger metadata, Logfmt formatter, and Grafana dashboards","title":"Structured logging with Logfmt","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["devops","infrastructure","documentation"],"project_id":7,"assignee_name":"Dave Kim","complexity":5,"deleted_at":null,"due_date":"2026-02-01","estimated_hours":"24","urgent":false},{"id":18,"priority":"low","status":"pending","description":"Generate realistic test data with ExMachina factories for development","title":"Create seed data scripts (phase 3)","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["database","testing","infrastructure"],"project_id":7,"assignee_name":"Frank Lee","complexity":7,"deleted_at":null,"due_date":"2026-06-12","estimated_hours":"18","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":20,"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","security"],"project_id":7,"assignee_name":"Eve Wilson","complexity":5,"deleted_at":null,"due_date":"2026-05-05","estimated_hours":"37","urgent":true},{"id":28,"priority":"low","status":"pending","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"],"project_id":7,"assignee_name":"Alice Chen","complexity":4,"deleted_at":null,"due_date":"2026-01-31","estimated_hours":"23","urgent":false},{"id":29,"priority":"low","status":"pending","description":"S3-backed file uploads with Waffle and Mogrify image processing pipeline","title":"Waffle file uploads","completed":false,"inserted_at":"2026-03-28T20:13:16Z","updated_at":"2026-03-28T20:13:16Z","tags":["backend","api","infrastructure","security"],"project_id":5,"assignee_name":"Bob Martinez","complexity":9,"deleted_at":null,"due_date":"2026-05-20","estimated_hours":"4","urgent":false},{"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":38,"priority":"medium","status":"pending","description":"OpenAPI 3.0 spec for all PgRest resource endpoints","title":"Write API documentation","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["documentation","api"],"project_id":4,"assignee_name":"Bob Martinez","complexity":9,"deleted_at":null,"due_date":"2026-06-18","estimated_hours":"2","urgent":false},{"id":42,"priority":"high","status":"pending","description":"Back-office admin interface with LiveView table components and inline editing","title":"LiveView admin CRUD (phase 3)","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["liveview","backend","devops"],"project_id":4,"assignee_name":"Dave Kim","complexity":3,"deleted_at":null,"due_date":"2026-01-10","estimated_hours":"8","urgent":false},{"id":44,"priority":"low","status":"pending","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:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["backend","database","performance"],"project_id":3,"assignee_name":"Carol Johnson","complexity":3,"deleted_at":null,"due_date":"2026-04-03","estimated_hours":"30","urgent":false},{"id":48,"priority":"low","status":"pending","description":"Increase ExUnit test coverage to 80% across all modules with Coveralls integration","title":"ExUnit test coverage (phase 1)","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["testing","backend","security"],"project_id":2,"assignee_name":"Grace Park","complexity":5,"deleted_at":null,"due_date":"2026-01-08","estimated_hours":"38","urgent":false},{"id":54,"priority":"high","status":"pending","description":"Configure GitHub Actions with mix release for automated testing and Fly.io deployment","title":"Set up Mix releases pipeline (phase 3)","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["devops","infrastructure"],"project_id":4,"assignee_name":"Alice Chen","complexity":10,"deleted_at":null,"due_date":"2026-02-28","estimated_hours":"30","urgent":true},{"id":56,"priority":"medium","status":"pending","description":"Generate realistic test data with ExMachina factories for development","title":"Create seed data scripts","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["database","testing","performance"],"project_id":6,"assignee_name":"Eve Wilson","complexity":3,"deleted_at":null,"due_date":"2026-04-02","estimated_hours":"16","urgent":false},{"id":70,"priority":"critical","status":"pending","description":"WCAG 2.1 AA compliance review and LiveView aria attribute fixes","title":"Accessibility audit","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["liveview","ux"],"project_id":3,"assignee_name":"Carol Johnson","complexity":6,"deleted_at":null,"due_date":"2026-04-27","estimated_hours":"29","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":88,"priority":"high","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:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["liveview","otp","ux"],"project_id":5,"assignee_name":"Grace Park","complexity":6,"deleted_at":null,"due_date":"2026-06-26","estimated_hours":"24","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":43,"priority":"high","status":"pending","description":"Profile and optimize slow Ecto queries with EXPLAIN ANALYZE and pg_stat_statements","title":"Ecto query audit","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["performance","database","backend"],"project_id":1,"assignee_name":"Carol Johnson","complexity":5,"deleted_at":null,"due_date":"2026-01-20","estimated_hours":"27","urgent":false},{"id":51,"priority":"medium","status":"pending","description":"Ensure all LiveView pages work on mobile viewports with Tailwind responsive utilities","title":"Responsive Tailwind layouts (phase 4)","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["liveview","ux"],"project_id":1,"assignee_name":"Carol Johnson","complexity":7,"deleted_at":null,"due_date":"2026-06-17","estimated_hours":"25","urgent":false},{"id":53,"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:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["liveview","otp","infrastructure"],"project_id":7,"assignee_name":"Bob Martinez","complexity":9,"deleted_at":null,"due_date":"2026-04-11","estimated_hours":"5","urgent":true},{"id":55,"priority":"high","status":"pending","description":"Create ERD and Ecto migrations for the new data model with composite indexes","title":"Design Ecto schema","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["database","backend","ux"],"project_id":2,"assignee_name":"Carol Johnson","complexity":4,"deleted_at":null,"due_date":"2026-04-11","estimated_hours":"22","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":65,"priority":"critical","status":"pending","description":"OpenAPI 3.0 spec for all PgRest resource endpoints","title":"Write API documentation","completed":false,"inserted_at":"2026-03-28T20:13:17Z","updated_at":"2026-03-28T20:13:17Z","tags":["documentation","api"],"project_id":7,"assignee_name":"Grace Park","complexity":7,"deleted_at":null,"due_date":"2026-06-20","estimated_hours":"38","urgent":true},{"id":83,"priority":"critical","status":"pending","description":"Configure GitHub Actions with mix release for automated testing and Fly.io deployment","title":"Set up Mix releases pipeline","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["devops","infrastructure"],"project_id":3,"assignee_name":"Frank Lee","complexity":4,"deleted_at":null,"due_date":"2026-01-22","estimated_hours":"29","urgent":true},{"id":93,"priority":"low","status":"pending","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:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["backend","database","performance"],"project_id":5,"assignee_name":"Bob Martinez","complexity":6,"deleted_at":null,"due_date":"2026-02-24","estimated_hours":"12","urgent":false},{"id":95,"priority":"medium","status":"pending","description":"Increase ExUnit test coverage to 80% across all modules with Coveralls integration","title":"ExUnit test coverage","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["testing","backend"],"project_id":4,"assignee_name":"Alice Chen","complexity":4,"deleted_at":null,"due_date":"2026-04-10","estimated_hours":"40","urgent":false},{"id":101,"priority":"low","status":"pending","description":"Ensure all LiveView pages work on mobile viewports with Tailwind responsive utilities","title":"Responsive Tailwind layouts","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["liveview","ux"],"project_id":3,"assignee_name":"Grace Park","complexity":3,"deleted_at":null,"due_date":"2026-05-22","estimated_hours":"21","urgent":false},{"id":105,"priority":"critical","status":"pending","description":"S3-backed file uploads with Waffle and Mogrify image processing pipeline","title":"Waffle file uploads (phase 2)","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["backend","api","infrastructure","security"],"project_id":7,"assignee_name":"Grace Park","complexity":6,"deleted_at":null,"due_date":"2026-02-15","estimated_hours":"38","urgent":true},{"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":113,"priority":"low","status":"pending","description":"k6 load tests for critical Plug endpoints with Ecto connection pool tuning","title":"k6 load testing","completed":false,"inserted_at":"2026-03-28T20:13:19Z","updated_at":"2026-03-28T20:13:19Z","tags":["testing","performance","ux"],"project_id":1,"assignee_name":"Alice Chen","complexity":4,"deleted_at":null,"due_date":"2026-01-18","estimated_hours":"39","urgent":false},{"id":115,"priority":"critical","status":"pending","description":"Integrate Sentry Elixir SDK with Logger backend for error monitoring and alerting","title":"Set up Sentry with Logger","completed":false,"inserted_at":"2026-03-28T20:13:19Z","updated_at":"2026-03-28T20:13:19Z","tags":["devops","infrastructure"],"project_id":1,"assignee_name":"Carol Johnson","complexity":9,"deleted_at":null,"due_date":"2026-05-25","estimated_hours":"12","urgent":true},{"id":117,"priority":"high","status":"pending","description":"k6 load tests for critical Plug endpoints with Ecto connection pool tuning","title":"k6 load testing (phase 2)","completed":false,"inserted_at":"2026-03-28T20:13:19Z","updated_at":"2026-03-28T20:13:19Z","tags":["testing","performance","backend"],"project_id":3,"assignee_name":"Bob Martinez","complexity":10,"deleted_at":null,"due_date":"2026-06-15","estimated_hours":"17","urgent":true},{"id":96,"priority":"medium","status":"pending","description":"Implement URL-based API versioning using Plug.Router scopes with deprecation notices","title":"API versioning with Plug.Router (phase 1)","completed":false,"inserted_at":"2026-03-28T20:13:18Z","updated_at":"2026-03-28T20:13:18Z","tags":["api","backend","documentation","database"],"project_id":6,"assignee_name":"Alice Chen","complexity":10,"deleted_at":null,"due_date":"2026-01-05","estimated_hours":"2","urgent":false},{"id":110,"priority":"low","status":"pending","description":"Integrate Sentry Elixir SDK with Logger backend for error monitoring and alerting","title":"Set up Sentry with Logger","completed":false,"inserted_at":"2026-03-28T20:13:19Z","updated_at":"2026-03-28T20:13:19Z","tags":["devops","infrastructure"],"project_id":1,"assignee_name":"Alice Chen","complexity":9,"deleted_at":null,"due_date":"2026-04-22","estimated_hours":"18","urgent":false},{"id":114,"priority":"low","status":"pending","description":"Structured logging with Logger metadata, Logfmt formatter, and Grafana dashboards","title":"Structured logging with Logfmt (phase 3)","completed":false,"inserted_at":"2026-03-28T20:13:19Z","updated_at":"2026-03-28T20:13:19Z","tags":["devops","infrastructure"],"project_id":2,"assignee_name":"Frank Lee","complexity":10,"deleted_at":null,"due_date":"2026-01-27","estimated_hours":"39","urgent":false}]