Let's find out what can we achieve; using what we already have, without adding other layers, servers or applications: PostgreSQL.…