---
title: Database
emoji: 📊
colorFrom: red
colorTo: red
sdk: gradio
sdk_version: "6.6.0"
app_file: app.py
pinned: false
license: mit
short_description: AI academic tools with SQLite database & user authentication
tags:
  - education
  - students
  - essay
  - pdf
  - quiz
  - translation
  - urdu
  - authentication
  - database
  - sqlite
---

# 🎓 Student AI Suite

**AI-powered academic platform with persistent user database**

A complete student productivity suite featuring essay generation, PDF summarization, smart quizzes, and Urdu translation — all with secure user accounts and persistent data storage.

---

## 🗄️ Database Features

| Feature | Technology | Description |
|---------|-----------|-------------|
| **SQLite Database** | `sqlite3` | Persistent local storage |
| **User Accounts** | SHA-256 + Salt | Secure password hashing |
| **Sessions** | Token-based | 24-hour secure sessions |
| **Activity Logging** | Analytics-ready | Track usage (optional) |
| **Preferences** | Per-user | Default settings storage |

---

## 📊 Database Schema

### Tables

```sql
users              # User accounts & profiles
sessions           # Active login sessions  
activity_logs      # Usage analytics (optional)
user_preferences   # Personal default settings