Is it possible to connect to the database directly from a separate app?

Drawbacks mostly involve the fact that such a connection could be used for write access. Is that a requirement?

If your integration needs write access to the database, consider writing a plugin that exposes just the operations you need instead.