Implement cache backend selection and initialization logic

[djarecka]

~1-2days

• Support SQLite (local) and PostgreSQL (local or remote) as cache backends
• Load configuration, validate connections, and fall back to a local cache when needed
• Automatically create required tables if they do not exist