Glad to hear it! As far as the permanence of your hostname is concerned, Neon - our DB provider - does indicate that it is stable for the lifetime of the project. Only direct mutations by the project owner can modify the connection string.
As an aside, I'd recommend taking advantage of connection pooling if you plan on utilizing this dedicated resource fairly widely. The provided compute resource otherwise has a hard cap on direct connections.