Re: [GENERAL] Great site for comparing databases (or anything else)
It seems to be based on the honor system. When you click Rank, it asks you what databases you're familiar with. Then you can stack rank those databases across various questions. It's possible people could lie and say they know about mySQL and Postgres when in reality they don't, but hopefully the overall results would be accurate. Actually one of the reasons I posted it here was because I was hoping more database experts could weigh in with their opinions.. Mike On Sat, Oct 27, 2012 at 4:00 PM, Stephen Cook scli...@gmail.com mailto:scli...@gmail.com wrote: On 10/27/2012 5:18 PM, Mike Christensen wrote: Just came across this one: http://hammerprinciple.com/__databases/items/mysql/__postgresql http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Does it say anywhere on that site if the people surveyed know both databases well enough to judge these questions? I can't find anything about that, and the site also ranks gin and martial arts, so I'm not sure sure it has much value. I saw lots of discussion about the results shown in the website. I would say that it is always good to have something to start with. And I vote for it. -- Emi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
Em 27/10/2012 19:18, Mike Christensen escreveu: Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Mike Sorry to say, this site is full of holes. The problem is explained in section I am familiar with this database. How would people who don't know something be allowed to emit a judgment about the compared products? Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
On 10/27/2012 5:18 PM, Mike Christensen wrote: Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Does it say anywhere on that site if the people surveyed know both databases well enough to judge these questions? I can't find anything about that, and the site also ranks gin and martial arts, so I'm not sure sure it has much value. -- Stephen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
It seems to be based on the honor system. When you click Rank, it asks you what databases you're familiar with. Then you can stack rank those databases across various questions. It's possible people could lie and say they know about mySQL and Postgres when in reality they don't, but hopefully the overall results would be accurate. Actually one of the reasons I posted it here was because I was hoping more database experts could weigh in with their opinions.. Mike On Sat, Oct 27, 2012 at 4:00 PM, Stephen Cook scli...@gmail.com wrote: On 10/27/2012 5:18 PM, Mike Christensen wrote: Just came across this one: http://hammerprinciple.com/**databases/items/mysql/**postgresqlhttp://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Does it say anywhere on that site if the people surveyed know both databases well enough to judge these questions? I can't find anything about that, and the site also ranks gin and martial arts, so I'm not sure sure it has much value. -- Stephen
Re: [GENERAL] Great site for comparing databases (or anything else)
On 28/10/12 12:00, Stephen Cook wrote: On 10/27/2012 5:18 PM, Mike Christensen wrote: Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Does it say anywhere on that site if the people surveyed know both databases well enough to judge these questions? I can't find anything about that, and the site also ranks gin and martial arts, so I'm not sure sure it has much value. -- Stephen Probably a very useful site to note people's 'perceptions' - as perceptions tend to influence peoples decisions, especially when people feel overwhelmed by technical decision making. Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. For the above reasons, I think it may be of value to the pg community to look at it in order to consider what are marketing messages should be. Cheers, Gavin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to C. BASIC has a low threshold, but you will very quickly bump your head against the wall. MySQL, the BASIC of db engines? regards, Leif -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
On 28/10/12 12:29, Leif Biberg Kristensen wrote: Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to C. BASIC has a low threshold, but you will very quickly bump your head against the wall. MySQL, the BASIC of db engines? regards, Leif I have used both MySQL Postgres: I feel a lot more comfortable with Postgres, as it seems to be both simpler and more sophisticated. MySQL has several DB engines for different purposes, Postgres has just one that appears to be more capable than the collection of features from all the MySQL DB engines combined. In the last 12 years I've gone looking for comparisons between them 3 times; and each time, Postgres comes out better overall. Cheers, Gavin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
Em 28/10/2012 01:35, Gavin Flower escreveu: On 28/10/12 12:29, Leif Biberg Kristensen wrote: Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to C. BASIC has a low threshold, but you will very quickly bump your head against the wall. MySQL, the BASIC of db engines? regards, Leif I have used both MySQL Postgres: I feel a lot more comfortable with Postgres, as it seems to be both simpler and more sophisticated. MySQL has several DB engines for different purposes, Postgres has just one that appears to be more capable than the collection of features from all the MySQL DB engines combined. In the last 12 years I've gone looking for comparisons between them 3 times; and each time, Postgres comes out better overall. And I must add: even using InnoDB, MySQL allows violation of relational integrity (just put it under heavy transactional load). I've suffered this pain in the past even with MySQL 5.1. This problem does not happens with PostgreSQL. The only occasion I had duplications in PostgreSQL was during a heavy data load. At that time, I used RSync to copy data to another server with the command: rsync -azv /var/lib/pgsql/9.1/data root@127.0.0.1:/var/lib/pgsql/9.1/ Do you see my mistake above? Yes, this causes duplicate records (and after some time, complete database corruption in PostgreSQL). Is just db admin stupidity (I can tell, because I was caused by my self). Would be nice if we can shield PostgreSQL against my personal silliness. Edson Cheers, Gavin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Great site for comparing databases (or anything else)
On 28/10/12 16:52, Edson Richter wrote: Em 28/10/2012 01:35, Gavin Flower escreveu: On 28/10/12 12:29, Leif Biberg Kristensen wrote: Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to C. BASIC has a low threshold, but you will very quickly bump your head against the wall. MySQL, the BASIC of db engines? regards, Leif I have used both MySQL Postgres: I feel a lot more comfortable with Postgres, as it seems to be both simpler and more sophisticated. MySQL has several DB engines for different purposes, Postgres has just one that appears to be more capable than the collection of features from all the MySQL DB engines combined. In the last 12 years I've gone looking for comparisons between them 3 times; and each time, Postgres comes out better overall. And I must add: even using InnoDB, MySQL allows violation of relational integrity (just put it under heavy transactional load). I've suffered this pain in the past even with MySQL 5.1. This problem does not happens with PostgreSQL. The only occasion I had duplications in PostgreSQL was during a heavy data load. At that time, I used RSync to copy data to another server with the command: rsync -azv /var/lib/pgsql/9.1/data root@127.0.0.1:/var/lib/pgsql/9.1/ Do you see my mistake above? Yes, this causes duplicate records (and after some time, complete database corruption in PostgreSQL). Is just db admin stupidity (I can tell, because I was caused by my self). Would be nice if we can shield PostgreSQL against my personal silliness. Edson Cheers, Gavin My tools are not good enough to cope with my own ineptitude - give me better tools! :-) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general