Why not have Phoenix push and SPA so the connections are not persistent? Also Phoenix doesn't have a specific database library you can connect any database. Phoenix is really just the framework on the back end but it is also made to be a server side renderer or it can serve a SPA that will not persist a connection. With 40 cores if done right I feel like that could be a lot of connections. Especially with Elixirs Beam and multi core processing.