8 ms·
Heroku Releases Free PostgreSQL App for OSX
- untog 14y agoDamn. I was hoping this would be a Postgres client, not a bundled server. pgAdmin works, but it's a pain. Sequel Pro is orders of magnitude better.
- willlll 14y agoTry the sister project http://inductionapp.com/ http://inductionapp.com/
- untog 14y agoWow, how have I never heard of this? Awesome, thanks!
- rexf 14y agonice, will def check out induction! "Induction supports PostgreSQL, MySQL, SQLite, Redis, and MongoDB out-of-the-box"
- justauser 14y agoInduction does look good. A bit uglier but if you need to support quite a few databases maybe Razor is another good alternative. I've used it for years. It is not open source though. http://www.razorsql.com/ http://www.razorsql.com/
- TY 14y agoRazor is actually quite impressive - I've made it the default SQL client tool for the team. It works on Windows, OS X and Linux, connects to almost any RDBMS in existence, easily customizable and has tabbed results interface in addition to many other features. All for $60-70. Easily worth the money, you can get a full trial for 30 days to see if it works for you.
- JonnieCache 14y agoThere's also this, similar but more full featured. http://www.navicat.com/ http://www.navicat.com/ I use it a lot, and have nothing but praise for it.
- eropple 14y agoI got Navicat during a sale on the App Store. It's the first app where I wished I could re-buy it at list price. It is GREAT.
- teyc 14y agoI'm curious. What's Navicat do that cheaper clients/don't?
- michaelbuckbee 14y agoNavicat is great, it has been surprisingly helpful to have the same database client app for all of the different DB systems (Postgres, MySQL, Sqlite) that I need to interact with.
- sant0sk1 14y agoI tried Induction a few weeks back and it has quite a ways to go before you could rely on it day in and day out. I'm still holding out for Postgres and Sqlite support in Sequel Pro since that tool has a great UI and tons of nifty features.
- agildehaus 14y agoSequel Pro devs have long expressed an interest in Pg support but I've never seen any actual work being done. Anyone know if it's a stop on their roadmap yet?
- mathnode 14y agoNote: OS X Lion includes the command like psql client already installed. OS X Lion Server, includes a full PostgreSQL server.
- IanMalcolm 14y agoAnd no silly kickstarter was needed for that.
- msie 14y agoI assume that the people who wrote it are employed, and getting paid, by GitHub.
- younata 14y agoHeroku, but close enough.
- thibaut_barrere 14y agoThat's because it is essentially (good - and paid!) technical marketing :)
- djbender 14y agoI didn't realize you were forced at gunpoint to donate.
- ksherlock 14y agoWhat a useless write up. http://postgresapp.com/ http://postgresapp.com/ https://github.com/mattt/PostgresApp https://github.com/mattt/PostgresApp Postgres.app is the easiest way to get started with PostgreSQL on the Mac. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down. Postgres.app will be distributed through the Mac App Store, with a separate build containing the latest PostgreSQL beta available for direct download from the website.
- jdelsman 14y agobrew install postgres Done. How is this useful?
- Aqua_Geek 14y agoIt doesn't require you to have dev tools installed.
- lost-theory 14y agoCan you call yourself a developer then? :)
- ketralnis 14y agoYeah, how dare that non-C-programmer call himself a True Scottsman without a C compiler installed?
- deleted 14y ago[deleted]
- sailfast 14y agoIt definitely took some work to get PostgreSQL up and running on OSX when I was trying to mirror my Heroku production environment locally for dev. This lowers a bunch of barriers, especially for a newbie to the PostgreSQL like me so I can appreciate this. I'm sure anyone working through Michael Hartl's Rails Tutorial right now and trying to do the optional Postgres configuration is also pretty excited at the time savings.
- joshstrange 14y agoI'm confused, hasn't this existed for a while now? I have had this installed on my machine since Jun 4th, 2012. How is this "News"?
- leftnode 14y agoMaybe not everyone subscribes to the Heroku mailing list or the list of all new software released ever and hadn't heard about it?
- zacharyvoase 14y agoThe article says it was released today, but it wasn't.
- Natsu 14y agoHe might be confused like me. I've been using it for weeks now and didn't realize it hadn't been officially released yet. I found it while searching and it has proven very convenient for working with Heroku.
- rdl 14y agoIt's cool that this exists, but when I do development local to my mac, I always use a virtual linux machine for the server -- just a whole lot easier to keep the prod and test platforms in sync, and makes it easier to roll back. I do like having macports (or homebrew, I guess) on the mac for tools like mutt, curl, wget, nmap, etc., but I'd prefer to run a whole virtual front end server talking to a virtual db server and use local clients on the mac to connect. (I really wish I had more than 4GB RAM in my Air, though, but don't want to replace this one so soon)
- rgrieselhuber 14y agoWhat app do you use to manage the virtual instances?
- Aqua_Geek 14y agoVagrant (http://vagrantup.com http://vagrantup.com) is a good option for creating/managing environments.
- shellox 14y agoI think this is a great way getting started with postgres. You don't have to build it from scratch(may via homebrew) and can directly dive in using it. I know, there are binaries linked on the postgres website, but I had some issues with the installer in the past.
- kristianp 14y agoI found this alarming: " The majority of active apps on Heroku use Postres, but we found that many developers use SQLite or MySQL on their local development machines". If your app is at the deployment to production stage, then I would strongly recommend using the same database as will be used in production. This quote isn't actually saying what proportion of developers don't do that, though.