DEPI Flutter Task - Database Operations

An application built with Flutter to add and edit notes demonstrating local database operations, data persistence, and SQLite integration as part of the DEPI Flutter development course.

📱 Project Overview

This project showcases Flutter's local database capabilities using SQLite, featuring CRUD operations, data persistence, and efficient database management patterns.

✨ Features

• 💾 Local Database: SQLite integration for offline data storage
• 🔄 CRUD Operations: Create, Read, Update, Delete functionality
• 📊 Data Persistence: Reliable local data storage
• 🎯 State Management: Reactive state updates
• 📱 Offline Support: Full functionality without internet connection
• 🔍 Data Search: Efficient database querying

🚀 Getting Started

Prerequisites

• Flutter SDK (latest stable version)
• Dart SDK
• Android Studio / VS Code
• SQLite (included with Flutter)

Installation

1. Clone the repository:

git clone https://github.com/Abobakr146/DEPI_Flutter_task_database.git
cd DEPI_Flutter_task_database

2. Install dependencies:

flutter pub get

3. Run the application:

flutter run

📂 Project Structure

lib/
├── main.dart
├── database/
│   ├── database_helper.dart   # SQLite helper class
│   ├── models/               # Data models
│   └── queries/              # SQL queries
├── screens/
│   ├── home_screen.dart
│   ├── add_item_screen.dart
│   └── edit_item_screen.dart
├── widgets/                  # Reusable UI components
└── utils/                    # Helper functions

🗄️ Database Features

Core Operations

• Create: Insert new records into database
• Read: Query and retrieve data with filters
• Update: Modify existing records
• Delete: Remove records safely

🚀 Performance Optimization

• Efficient indexing strategies
• Query optimization
• Lazy loading implementation
• Memory management
• Background database operations

📊 Data Management Best Practices

• Data normalization
• Transaction management
• Error handling and recovery

👨‍💻 Author

Abobakr146

• GitHub: @Abobakr146

---