Need advice about which tool to choose?Ask the StackShare community!
Heroku Postgres vs PSequel: What are the differences?
Developers describe Heroku Postgres as "Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL". Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management. On the other hand, PSequel is detailed as "A free PostgreSQL GUI Tool for Mac OS X". Designed for Yosemite. Written in Swift. PSequel provides a clean and simple interface to perform common PostgreSQL tasks quickly.
Heroku Postgres belongs to "PostgreSQL as a Service" category of the tech stack, while PSequel can be primarily classified under "Database Tools".
Considering moving part of our PostgreSQL database infrastructure to the cloud, however, not quite sure between AWS, Heroku, Azure and Google cloud. Things to consider: The main reason is for backing up and centralize all our data in the cloud. With that in mind the main elements are: -Pricing for storage. -Small team. -No need for high throughput. -Support for docker swarm and Kubernetes.
Good balance between easy to manage, pricing, docs and features.
DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.
Pros of Heroku Postgres
- Easy to setup29
- Follower databases3
- Dataclips for sharing queries3
- Extremely reliable3
Pros of PSequel
- Free3
- Simplest Postgres client3
- Doesn't try to upsell you with premium features3
Sign up to add or upvote prosMake informed product decisions
Cons of Heroku Postgres
- Super expensive2
Cons of PSequel
- No CSV export2