Tell us about your experience working with PostgreSQL and Redis

Experience with PostgreSQL includes designing relational schemas, writing complex SQL queries, using indexes for optimization, configuring replication and backups. Also applied functions and triggers for business logic on the database side.

Worked with Redis as a high-performance in-memory storage for data caching, message queue implementation, and session storage. Used Redis data structures (strings, lists, sets, hashes) for various tasks, and configured TTL for automatic deletion of outdated data.

Integrated PostgreSQL with Flutter via REST API or GraphQL, and used Redis on the server side to speed up response times and manage application state.