[FEATURE] Postgres support for remote storage

[bobbyiliev]

Problem / Motivation

Currently, all tasks are stored locally, which makes it hard to sync the todo list across multiple machines or collaborate with others.

Proposed Solution

Add support for using PostgreSQL as a backend storage option. This would allow users to configure a remote Postgres database where tasks are stored, enabling seamless syncing between multiple machines and environments.

Alternatives considered

• Manual file sync through Git or cloud storage (works but is clunky and error-prone)
• SQLite with a shared network drive (limited portability and more setup overhead)

---

Acceptance Criteria

• Users can configure Postgres connection details via CLI or config file
• Tasks are stored and retrieved from the Postgres database
• Multiple clients can access and stay in sync with the same task list

[HithaHarish]

Hi @Valentin-v-Todorov please assign this issue to me.

[Valentin-v-Todorov]

Thanks for the issue suggestion @bobbyiliev !

Yes, @HithaHarish , I assign the issue to you. ✌️

[HithaHarish]

Thankyou @Valentin-v-Todorov , I'll fork and start working on it.

[HithaHarish]

Hi, @Valentin-v-Todorov.
I was trying to run tix-cli and noticed an issue with the cli.py file.

There exists an import :
from tix.storage.context_storage import ContextStorage

However, the file/module context_storage.py does not exist anywhere in the storage directory . Because of this, running commands like tix --help raises:
ModuleNotFoundError: No module named 'tix.storage.context_storage'

Could you clarify if context_storage was removed, renamed, or if there’s an alternative approach I should use?
Thanks!

[inzamrzn918]

HI @HithaHarish, you can check this PR #92 it will give you context to resolve the issue

[vikram-parashar]

Will the app now work online (since remote)
or if not
how will take care of syncing?

[HithaHarish]

Hi @Valentin-v-Todorov,
I won’t be able to continue working on this issue anymore. Please feel free to unassign me or reassign it to someone else.
Thanks for the opportunity!
@inzamrzn918 , I appreciate the guidance 😊.