4 ms·

When will PostgreSQL hit the tipping point? Sucker has been ripe for the pickin' for years.

by ruby_roo 17y ago

mishmash 17y ago
Does pgMyAdmin (or whatever the phpMyAdmin equivalent is called) still suck?
- pivo 17y ago
  Not in my opinion
  - mishmash 17y ago
    It's been a long time since I've tried it, but will try again soon. From the guided tour, it looks impressive: http://www.pgadmin.org/visualtour.php http://www.pgadmin.org/visualtour.php
- cookiecaper 17y ago
  phpPgAdmin is okay, I think about on par with phpMyAdmin, but I prefer pgadmin3.
chaosmachine 17y ago
When it gets a different name. I have a theory the difficult name drives people away before they ever give it a chance. Looking at Wikipedia, it seems I might not be far off. Before you read anything about the features, there's an entire paragraph explaining the name: "The mixed-capitalization of the PostgreSQL name can confuse some people on first viewing..." Given a blind choice, I suspect any SQL newbie deciding between which one to try first, would go with the friendly sounding "MySQL" vs the intimidating "Postgre(s..ql?!)".
fizx 17y ago
I switched my Rails development from mysql to postgresql for a few projects now. It's really nice to have sensible index usage, and good in-db fulltext. I don't have the same comfort level though. I'm not sure how much is my familiarity with mysql, and how much is pg being legitimately harder.
rjurney 17y ago
When the tools get a little friendlier. MySQL is still much easier to start working with. I prefer Postgres, but it is more difficult for the n00b.
- cookiecaper 17y ago
  I don't think that's true at all; someone who started on MySQL is obviously more comfortable with the MySQL methods, but I can't think of anything about Postgres that makes it more difficult than MySQL for someone with no prior experience. PgSQL definitely has more advanced features, but they can generally be safely ignored if you don't want to utilize them.
  - brendano 17y ago
    the free, standard gui for mysql is much easier to use than the free gui for postgresql. (mysql query browser vs. pgadmin III).
  - rjurney 17y ago
    Dare I say that you started on postgres? :) The commands are more obscure.
duskwuff 17y ago
When it gets good native clustering support? Last time I checked, clustering support was still tentative, not heavily tested, and not in the core distribution.

When will PostgreSQL hit the tipping point? Sucker has been ripe for the pickin' for years.

mishmash 17y ago

Does pgMyAdmin (or whatever the phpMyAdmin equivalent is called) still suck?

pivo 17y ago
Not in my opinion
- mishmash 17y ago
  It's been a long time since I've tried it, but will try again soon. From the guided tour, it looks impressive: http://www.pgadmin.org/visualtour.php http://www.pgadmin.org/visualtour.php
cookiecaper 17y ago
phpPgAdmin is okay, I think about on par with phpMyAdmin, but I prefer pgadmin3.

chaosmachine 17y ago

When it gets a different name. I have a theory the difficult name drives people away before they ever give it a chance. Looking at Wikipedia, it seems I might not be far off. Before you read anything about the features, there's an entire paragraph explaining the name: "The mixed-capitalization of the PostgreSQL name can confuse some people on first viewing..." Given a blind choice, I suspect any SQL newbie deciding between which one to try first, would go with the friendly sounding "MySQL" vs the intimidating "Postgre(s..ql?!)".

fizx 17y ago

I switched my Rails development from mysql to postgresql for a few projects now. It's really nice to have sensible index usage, and good in-db fulltext. I don't have the same comfort level though. I'm not sure how much is my familiarity with mysql, and how much is pg being legitimately harder.

rjurney 17y ago

When the tools get a little friendlier. MySQL is still much easier to start working with. I prefer Postgres, but it is more difficult for the n00b.

cookiecaper 17y ago
I don't think that's true at all; someone who started on MySQL is obviously more comfortable with the MySQL methods, but I can't think of anything about Postgres that makes it more difficult than MySQL for someone with no prior experience. PgSQL definitely has more advanced features, but they can generally be safely ignored if you don't want to utilize them.
- brendano 17y ago
  the free, standard gui for mysql is much easier to use than the free gui for postgresql. (mysql query browser vs. pgadmin III).
- rjurney 17y ago
  Dare I say that you started on postgres? :) The commands are more obscure.

duskwuff 17y ago

When it gets good native clustering support? Last time I checked, clustering support was still tentative, not heavily tested, and not in the core distribution.