Backend & Database Setup

[ScottyTGB]

📘 Project Overview

This issue is focused on developing the backend logic and database schema necessary for the project. Using Flask, we will create a server-side rendered application with SQLite for managing data. This will be integrated with AJAX/Websockets for efficient client-server communication.

🎯 Backend Requirements

• Flask Server Logic: Develop robust server routes and logic to handle various application functionalities.
• SQLite Database: Design and implement a database schema suitable for the project's data management needs.
• Dynamic Data Interaction: Utilize AJAX/Websockets for real-time data interactions without needing to reload the client-side.

⚙️ Technical Constraints

• Limited Technologies: Use only Flask, AJAX/Websockets, JQuery (sparingly), and SQLite.
• Server-Side Rendering Focus: Ensure all rendering and logic processing are handled server-side.

🏗️ Milestones

• [x] M1: Flask Setup and Initial Routes (Due: 23-APR-2024)
  • Setup Flask application structure.
  • Implement initial server routes necessary for basic application functions.
• [x] M2: Database Schema Design (Due: 23-APR-2024)
  • Design the SQLite database schema.
  • Implement models and database migrations.
• [x] M3: AJAX/Websockets Integration (Due: 25-APR-2024)
  • Set up AJAX endpoints for dynamic data fetching and updates.
  • Implement Websockets for real-time communication where necessary.
• [x] M4: Data Management and Security (Due: 30-APR-2024)
  • Develop data management functions.
  • Implement security measures for data integrity and protection.

🎯 Success Criteria

• Backend efficiently handles all route requests with server-side logic.
• Database is normalized and optimized for the required queries.
• Real-time data handling is smooth and efficient with minimal load time.

[tmeinertz]

All 4 have been implemented M1 - Flask routes and flask app created M2 - SQLite database created and integrated M3 - Flask now loads data into the HTML template M4 - CSRF tokens, Flask-Login and SQLAlchemy are in to protect