I have idle daydreams where Sequel Pro is finally ported to Postgres. pgAdmin is horrendous.
That would be amazing. Sequel Pro makes MySQL management so easy. Have you emailed the author asking for that feature? Edit: It seems they are working on it but I i'm not sure when we can expect a release: http://stuconnolly.com/blog/sequel-pro-postgresql-support/
I've used Sequel Pro and I don't understand why others love it; it's as clunky as anything I've ever used. My preference is for SQLyog - and my dream is that to be ported to OSX...
I've heard about PostgreSQL and know that HN community raves about it, but am currently using RDS with MySQL. Does it make sense to migrate to PostgreSQL, I don't have a lot of data as I'm in the early stage? What are the primary advantages that PostgreSQL provides over MySQL? Any advise/pointers is appreciated.
Postgres actually cares about your data. Perhaps you mistakenly insert "2013-10-32" into a date column. MySQL will silently convert this to "0000-00-00" (!!). Postgres will raise an error. Perhaps you make an error in a transaction. MySQL lets you keep doing subsequent things in the transaction. Postgres treats the transaction as invalid and forces you to start over. Perhaps you want to add a column to a table that h…
Postgres actually cares about your data. Perhaps you mistakenly insert "2013-10-32" into a date column. MySQL will silently convert this to "0000-00-00" (!!). Postgres will raise an error. Perhaps you make an error in a transaction. MySQL lets you keep doing subsequent things in the transaction. Postgres treats the transaction as invalid and forces you to start over. Perhaps you want to add a column to a table that h…
Are add-ons such as PostGIS supported on RDS?
Hehe, never mind. It's the first of the offered features...
To me, the MySQL query optimizer (single index in a query) was the proverbial straw that broke the camel's back. My group is developing all new applications in PostgreSQL and we would like to migrate our legacy apps away from MySQL.
I'm on mobile and cant quickly and easily search this but is there a good GUI for postgre similar or superior to phpmyadmin?
Dbvisualizer (http://www.dbvis.com/) works with lots of databases and is really pretty cheap. Disclaimer: no connection other being a long term customer, I use it with Oracle, MySQL and Postgresql.
Can you please explain the value proposition of using Heroku Postgres vs RDS now? Heroku's solution is 2 to 4 times more expensive for the same type of DB, and RDS even allows for reserved instances to further lower the bill.
There are a variety of differences overall. One area is we're focused more on delivering more guidance and expertise around what you're doing with your database, in addition to ensuring your database is healthy and running. An example of this is notifications that we deliver around unused indexes, where you may benefit from other indexes, or other places where you can quickly optimize your DB. This starts to free up…
I understand that "forks" and "follows" are easy concepts, stats are cools, etc. but I personally wouldn't want to pay double or triple for that (and I'm not a DBA, so I feel the pain). Not that my word counts much as I'm on the smallest Heroku production plan, so I guess my bill isn't exactly interesting for this kind of discussion. In my case, I would say that even saving $25 off $50 can be offset by these additional niceties. But, I don't know what I would think if I were a customer paying $1000/mo.
This is not true at all. Apps on Heroku are built on open source software (Rails, Postgres, etc). You can always decide to host it all yourself without too many issues.
How is this not true? It absolutely IS vendor lock-in, just in a slightly less sinister form. If you add 5 services & then to switch hosts it's not another git push. You have to re-configure each of the services. If you'd done this yourself all along & made machine images it would have been less convenient at the time, but probably cheaper & a good learning experience. There are many other hosting platforms that offe…
> Plus there's a lot of value in learning how to work with machine images that goes way beyond hosting a web app.
Every minute I spend doing that is a minute I spend not doing things I enjoy. YMMV though.
I have but one suggestion. Unless RDS for PostgreSQL is drastically different from RDS for MySQL, you still need a DB administrator. RDS removes remarkably little of the pain of running a database instance (most of the pain that's removed is just the up front setup), and ends up adding a lot of inconveniences for your day-to-day operations. Also don't count on their replication as your backup. OK. That's two suggesti…
> Also don't count on their replication as your backup.
This statement seems like a complete non-sequitur: does anyone credible recommend replication as a backup strategy? It's like dinging a server vendor because you can't rely on RAID as a backup plan.
To me, the MySQL query optimizer (single index in a query) was the proverbial straw that broke the camel's back. My group is developing all new applications in PostgreSQL and we would like to migrate our legacy apps away from MySQL.
I'm on mobile and cant quickly and easily search this but is there a good GUI for postgre similar or superior to phpmyadmin?
I think this is great news... PostgreSQL is definitively my favorite open-source database. It's also nice to see Amazon get into the game, as hosted pg options have been fairly limited. I am slightly disappointed to not see the server-side JS support baked in, and that apparently you can't do reads from distributed replicas. Just the same, I think there will be a lot of progress in this area. Administering databases…
It looks like the Multi-AZ setup is using block level replication such as DRBD instead of the built-in replication: > Database updates are made concurrently on the primary and standby resources to prevent replication lag. Makes me feels better for setting up my own pg cluster on EC2 a week ago, which does allow reads from the replication slave. Plus, I can provision <1000 IOPS (provisioned IOPS is damn expensive with…
The time spent researching and building that cluster was time not spent building product. If you are low on capital then it was potentially a good tradeoff, but I'd much rather just scale up my read capacity by adding horsepower until they get around to adding read replicas. My goal is to spend as little time as possible administering my infrastructure, and running my own database cluster is the last thing on my mind.