Task Management App

Project Overview

This project involves creating a straightforward and functional task management app. It helps users organize their tasks, track deadlines, and stay productive.

User Stories

1. As a user, I want to:

   • Add, edit, and delete my tasks easily
   • Group tasks into categories for better organization
   • Set reminders for important deadlines
   • Mark tasks as completed to track progress
   • Use the app offline without losing data

2. As a developer, I want to:

   • Use SQLite to manage local data storage
   • Create a responsive and user-friendly design
   • Implement notification functionality for reminders
   • Ensure data persistence across app restarts

3. As a busy professional, I want to:

   • Quickly view tasks that are due today or overdue
   • Create recurring tasks for ongoing responsibilities
   • Sync tasks across devices (optional enhancement)

Example Code

Here’s how to create a task with SQLite:

import * as SQLite from 'expo-sqlite';

const db = SQLite.openDatabase('tasks.db');

export const createTable = () => {
  db.transaction(tx => {
    tx.executeSql(
      'CREATE TABLE IF NOT EXISTS tasks (id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, category TEXT, dueDate TEXT, completed BOOLEAN);'
    );
  });
};

export const addTask = (title, category, dueDate) => {
  db.transaction(tx => {
    tx.executeSql('INSERT INTO tasks (title, category, dueDate, completed) VALUES (?, ?, ?, ?);', [title, category, dueDate, false]);
  });
};

Further Enhancements

Add a calendar view to see tasks by date. Integrate cloud sync with Firebase for data backup. Include color-coded categories for better visibility. Allow users to attach notes or files to tasks. Implement recurring tasks with customizable intervals.