Postgres.app

#1

Post by simonebrunozzi » Fri, Aug 06, 2021, 7:33 AM UTC

Postgres.app
postgresapp.com

Re: Postgres.app

#2

Post by KingOfCoders » Fri, Aug 06, 2021, 8:21 AM UTC

I've happily used that on OSX (simpler than docker etc.), now I've switched to Windows, anything like that for Windows?

Re: Postgres.app

#3

Post by doctor_eval » Fri, Aug 06, 2021, 8:31 AM UTC

Used this for years. Can confirm awesomeness.

Re: Postgres.app

#4

Post by ridruejo » Fri, Aug 06, 2021, 8:36 AM UTC

KingOfCoders wrote: post #2

I've happily used that on OSX (simpler than docker etc.), now I've switched to Windows, anything like that for Windows?

https://bitnami.com/stack/wapp/installer

Re: Postgres.app

#5

Post by get52 » Fri, Aug 06, 2021, 8:44 AM UTC

I don't know anything about postgres but I've been using SQLite for years and it never failed me

Re: Postgres.app

#6

Post by harg » Fri, Aug 06, 2021, 8:44 AM UTC

It looks nice for beginners but personally I find that a simple docker-compose file per project that spins up a postgresql container works pretty nicely and is really easy to use. I just run `docker-compose up -d` and I have a database running. Docker containers also stay out of the way of the os and I can run the right versions for whichever project.

Re: Postgres.app

#7

Post by DelightOne » Fri, Aug 06, 2021, 8:45 AM UTC

harg wrote: post #6

It looks nice for beginners but personally I find that a simple docker-compose file per project that spins up a postgresql container works pretty nicely and is really easy to use. I just run `docker-compose up -d` and I have a database running. Docker containers also stay out of the way of the os and I can run the right versions for whichever project.

Makes you able to automatically run initialization scripts too.

Re: Postgres.app

#8

Post by boros2me » Fri, Aug 06, 2021, 8:45 AM UTC

Love the simplicity of the app, used it for years! However when I started working with docker-compose stacks exposing PostgreSQL port I had to uninstall it because it all got confusing.

Re: Postgres.app

#9

Post by willvarfar » Fri, Aug 06, 2021, 8:51 AM UTC

harg wrote: post #6

It looks nice for beginners but personally I find that a simple docker-compose file per project that spins up a postgresql container works pretty nicely and is really easy to use. I just run `docker-compose up -d` and I have a database running. Docker containers also stay out of the way of the os and I can run the right versions for whichever project.

(Be on top of security; this was recently on HN https://news.ycombinator.com/item?id=27613217)

Re: Postgres.app

#10

Post by xmodem » Fri, Aug 06, 2021, 9:14 AM UTC

Use it and love it. I use docker too for ephemeral databases but keep the long-lived ones here.

I just wish there was a version of this for mySQL/MariaDB.