MyProjectsManager 🚀

An open-source project and time management tool designed to track work hours, manage deadlines, and maintain a healthy balance between commercial and internal/pet projects.

🎯 Features (Planned)

• Time Tracking: Log hours spent on specific tasks and projects.
• Deadline Management: Keep track of upcoming project milestones.
• Project Balancing: Visualise the distribution of effort between commercial work and internal/pet projects.
• PWA Data Integration: Import and analyse data from Progressive Web Apps for extended productivity insights.

🛠️ Tech Stack

• Language: Python 3.14
• Framework: Django 6+
• Database: PostgreSQL (via Docker)
• Environment & Package Management: uv

💻 Local Development Setup

To run this project locally, you will need Python 3.14+, uv, and Docker installed on your machine.

1. Clone the repository

git clone https://github.com/OleksanderShevchenko/MyProjectsManager.git
cd MyProjectsManager

2. Set up the environment and install dependencies

This project uses uv for lightning-fast dependency management.

uv sync

3. Start the Database

Copy the example environment file and update the variables if necessary:

cp .env.example .env

Generate new secret key for .env and put it to your .env

uv run python -c "from django.core.management.utils import get_random_secret_key; print(get_random_secret_key())"

Update database settings:

• If you use postgres database from docker - set parameters at start of .env
• If you use cloud database - set its url.

To be able to import data from MS Project update PWA_URL in your .env

We use Docker to run PostgreSQL locally.

docker-compose up -d

4. Apply Migrations and Run the Server

uv run python manage.py migrate
uv run python manage.py runserver

💾 Database Backup & Restore

There are two ways to create a backup of your local database.

Method 1: Full PostgreSQL Dump (via Docker)

This method creates a complete SQL dump of the database running inside the Docker container (myprojectsmanager_db).

Important for Windows PowerShell users: The command must be wrapped in cmd /c to prevent PowerShell from corrupting the .sql file encoding.

Backup:

cmd /c 'docker exec -t myprojectsmanager_db pg_dump -U postgres projects_db > backup_12_08_2026_real.sql'

Restore: Create an empty database projects_db on your server/container, then run:

psql -U postgres -d projects_db -f backup_12_08_2026_real.sql

Method 2: Django Data Export (JSON)

This method exports all database records into a single JSON file. It is database-agnostic and ideal for migrating data (e.g., from PostgreSQL to SQLite).

Important for Windows users: Use the -X utf8 flag and -o parameter to avoid charmap codec can't encode errors when exporting Cyrillic or special characters.

Backup:

uv run python -X utf8 manage.py dumpdata -o datadump_12_08_2026.json

Restore:

uv run python manage.py loaddata datadump_12_08_2026.json

🤝 Contributing

Contributions, issues, and feature requests are welcome! Feel free to check the issues page.

📝 License

This project is open-source and available under the MIT License.