Re: [GENERAL] Too far out of the mainstream

2012-09-06 Thread Edson Richter
Em 06/09/2012 02:34, Chris Travers escreveu: On Wed, Sep 5, 2012 at 7:56 PM, Edson Richter edsonrich...@hotmail.com mailto:edsonrich...@hotmail.com wrote: Em 05/09/2012 23:49, Chris Travers escreveu: Regarding MySQL vs PostgreSQL: MySQL is what you get when app

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Chris Travers
On Tue, Sep 4, 2012 at 9:06 PM, Ondrej Ivanič ondrej.iva...@gmail.comwrote: Hi, On 5 September 2012 12:14, Chris Travers chris.trav...@gmail.com wrote: So people are using PostgreSQL in roles that aren't very visible anyway, DBA's are usually coming to PostgreSQL from other RDBMS's, and

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Oliver Kohll - Mailing Lists
Here's a bit of positive news spin - in a backhanded way perhaps, but still a compliment: http://www.theregister.co.uk/2012/08/31/postgresql_too_cool_for_school/ Oliver www.agilebase.co.uk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Ivan Sergio Borgonovo
On Tue, 4 Sep 2012 19:14:28 -0700 Chris Travers chris.trav...@gmail.com wrote: So people are using PostgreSQL in roles that aren't very visible anyway, DBA's are usually coming to PostgreSQL from other RDBMS's, and few applications are really distributed for PostgreSQL. I know a bunch of

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Achilleas Mantzios
On Τετ 05 Σεπτ 2012 10:51:49 Ivan Sergio Borgonovo wrote: On Tue, 4 Sep 2012 19:14:28 -0700 Chris Travers chris.trav...@gmail.com wrote: So people are using PostgreSQL in roles that aren't very visible anyway, DBA's are usually coming to PostgreSQL from other RDBMS's, and few

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Chris Angelico
On Wed, Sep 5, 2012 at 7:40 PM, Achilleas Mantzios ach...@smadev.internal.net wrote: (single master, 80+ slaves in 80+ vessels in the 7 seas (80+ = 80 and growning)) Cool!! How do your nodes communicate with each other? Is it an off-line resynchronization, or do you maintain long-range

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Achilleas Mantzios
On Τετ 05 Σεπτ 2012 23:44:08 Chris Angelico wrote: On Wed, Sep 5, 2012 at 7:40 PM, Achilleas Mantzios ach...@smadev.internal.net wrote: (single master, 80+ slaves in 80+ vessels in the 7 seas (80+ = 80 and growning)) Cool!! How do your nodes communicate with each other? Is it an

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread jam3
MySQL doesn't even support self referential updates like update t1 set c1 ='value' where t1.id not in (select id from t1 where id 100); Nor is it fully ACID compliant. And its online documentation is a nightmare. PgAdmin is infintely better than mysql workbench, heck anything is better than

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Magnus Hagander
On Sat, Sep 1, 2012 at 1:24 PM, Peter Bex peter@xs4all.nl wrote: On Sat, Sep 01, 2012 at 12:43:15AM +0200, Geert Mak wrote: There is this case studies section as well - http://www.postgresql.org/about/casestudies/ Which appear to me a little old and a little too little, one could try to

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread David Boreham
I dunno, perhaps I don't get out the office enough, but I just don't hear about MySQL any more. I think this thread is tilting at windmills. A few years ago about 1 in 2 contracts we had was with a start-up using MySQL. The other half were using either PG or Oracle or SQLServer. The years

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Chris Travers
On Wed, Sep 5, 2012 at 2:40 AM, Achilleas Mantzios ach...@smadev.internal.net wrote: On Τετ 05 Σεπτ 2012 10:51:49 Ivan Sergio Borgonovo wrote: On Tue, 4 Sep 2012 19:14:28 -0700 Chris Travers chris.trav...@gmail.com wrote: So people are using PostgreSQL in roles that aren't very

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Chris Travers
Regarding MySQL vs PostgreSQL: MySQL is what you get when app developers build a database server. PostgreSQL is what you get when db developers build a development platform. There really isn't anything more to say about it. Best Wishes, Chris Travers

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Damian Carey
On Sat, Sep 1, 2012 at 5:25 AM, Andy Yoder ayo...@airfacts.com wrote: Hello all, I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the concern our client's IT group has about our use of

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Edson Richter
Em 05/09/2012 23:49, Chris Travers escreveu: Regarding MySQL vs PostgreSQL: MySQL is what you get when app developers build a database server. PostgreSQL is what you get when db developers build a development platform. There really isn't anything more to say about it. This kind of claim is

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Scott Marlowe
On Wed, Sep 5, 2012 at 8:56 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 05/09/2012 23:49, Chris Travers escreveu: Regarding MySQL vs PostgreSQL: MySQL is what you get when app developers build a database server. PostgreSQL is what you get when db developers build a development

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Edson Richter
Em 06/09/2012 00:39, Scott Marlowe escreveu: On Wed, Sep 5, 2012 at 8:56 PM, Edson Richter edsonrich...@hotmail.com wrote: Em 05/09/2012 23:49, Chris Travers escreveu: Regarding MySQL vs PostgreSQL: MySQL is what you get when app developers build a database server. PostgreSQL is what you get

Re: [GENERAL] Too far out of the mainstream

2012-09-05 Thread Chris Travers
On Wed, Sep 5, 2012 at 7:56 PM, Edson Richter edsonrich...@hotmail.comwrote: Em 05/09/2012 23:49, Chris Travers escreveu: Regarding MySQL vs PostgreSQL: MySQL is what you get when app developers build a database server. PostgreSQL is what you get when db developers build a development

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Steve Crawford
On 08/31/2012 01:05 PM, Andrew Sullivan wrote: ..Anyone who thinks that MySQL, with its sketchy guarantees of data integrity and persistence, is mainstream-acceptable but Postgres isn't because they haven't read about it in InfoWorld And if they want to read about it in InfoWorld, they can:

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Mike Christensen
On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak po...@verysmall.org wrote: I have been looking into heroku lately, they run on PostgreSQL - https://postgres.heroku.com/postgres Went out to lunch with a guy who worked for Redfin as well. I guess they're all Postgres over there too.. -- Sent via

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Scott Marlowe
On Tue, Sep 4, 2012 at 11:28 AM, Mike Christensen m...@kitchenpc.com wrote: On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak po...@verysmall.org wrote: I have been looking into heroku lately, they run on PostgreSQL - https://postgres.heroku.com/postgres Went out to lunch with a guy who worked for

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Kevin Grittner
Andy Yoder ayo...@airfacts.com wrote: I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the concern our client's IT group has about our use of PostgreSQL in our shop. The group in

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Gavin Flower
On 05/09/12 05:35, Scott Marlowe wrote: On Tue, Sep 4, 2012 at 11:28 AM, Mike Christensen m...@kitchenpc.com wrote: On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak po...@verysmall.org wrote: I have been looking into heroku lately, they run on PostgreSQL - https://postgres.heroku.com/postgres Went

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Scott Marlowe
On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower gavinflo...@archidevsys.co.nz wrote: On 05/09/12 05:35, Scott Marlowe wrote: I have read to emails to one of the postgresql lists, where people in companies with 1000's of databases had power failures and only the postgresql databases restarted

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Scott Marlowe
On Tue, Sep 4, 2012 at 3:13 PM, Gavin Flower gavinflo...@archidevsys.co.nz wrote: On 05/09/12 08:38, Scott Marlowe wrote: On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower gavinflo...@archidevsys.co.nz wrote: On 05/09/12 05:35, Scott Marlowe wrote: I have read to emails to one of the postgresql

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Geert Mak
Since this PGCon 2011 page has no slides - http://www.pgcon.org/2011/schedule/events/361.en.html I Googled for sharding and PostgreSQL and I found this - http://www.databasesoup.com/2012/04/sharding-postgres-with-instagram.html On Tuesday last week we had a terrific SFPUG meeting at which Mike

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Chris Travers
On Tue, Sep 4, 2012 at 10:35 AM, Scott Marlowe scott.marl...@gmail.comwrote: Since there's no reporting requirements for using postgresql commercially etc, it's kind of a stealth database. It's all over the place and nobody knows it. Meanwhile, finding qualified PostgreSQL DBAs is pretty

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Gavin Flower
On 05/09/12 08:38, Scott Marlowe wrote: On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower gavinflo...@archidevsys.co.nz wrote: On 05/09/12 05:35, Scott Marlowe wrote: I have read to emails to one of the postgresql lists, where people in companies with 1000's of databases had power failures and only

Re: [GENERAL] Too far out of the mainstream

2012-09-04 Thread Ondrej Ivanič
Hi, On 5 September 2012 12:14, Chris Travers chris.trav...@gmail.com wrote: So people are using PostgreSQL in roles that aren't very visible anyway, DBA's are usually coming to PostgreSQL from other RDBMS's, and few applications are really distributed for PostgreSQL. snip Not only this

Re: [GENERAL] Too far out of the mainstream

2012-09-03 Thread Geert Mak
I have been looking into heroku lately, they run on PostgreSQL - https://postgres.heroku.com/postgres -- 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] Too far out of the mainstream

2012-09-03 Thread Gavin Flower
On 04/09/12 10:38, Geert Mak wrote: I have been looking into heroku lately, they run on PostgreSQL - https://postgres.heroku.com/postgres PostgreSQL is the database of choice for reliable web-applications. Is what they say on that page, not mincing words are they? Cheers, Gavin -- Sent

Re: [GENERAL] Too far out of the mainstream

2012-09-02 Thread Johan Nel
Chris Travers chris.trav...@gmail.com wrote in message news:CAKt_ZfvZfYq_VPYXG3p=fy=s1whcc0p9trxkczfrrsjsqms...@mail.gmail.com... On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder ayo...@airfacts.com wrote: Hello all, I would like the community's input on a topic. The words too far

Re: [GENERAL] Too far out of the mainstream

2012-09-02 Thread Chris Travers
On Sat, Sep 1, 2012 at 8:01 AM, Tom Lane t...@sss.pgh.pa.us wrote: Scott Marlowe scott.marl...@gmail.com writes: On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers chris.trav...@gmail.com wrote: 1) While MySQL is perhaps better marketed, PostgreSQL is an older project with a proud heritage

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Peter Bex
On Sat, Sep 01, 2012 at 12:43:15AM +0200, Geert Mak wrote: There is this case studies section as well - http://www.postgresql.org/about/casestudies/ Which appear to me a little old and a little too little, one could try to add more, perhaps. I noticed that the Share Your Story link is

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Edson Richter
Em 31/08/2012 16:52, David Johnston escreveu: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Andy Yoder Sent: Friday, August 31, 2012 3:25 PM To: pgsql-general@postgresql.org Cc: Andy Yoder Subject: [GENERAL] Too far

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Chris Travers
On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder ayo...@airfacts.com wrote: Hello all, I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the concern our client's IT group has about our use of

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread David Boreham
On 9/1/2012 6:42 AM, Edson Richter wrote: Nevertheless, when we present our product to customers, they won't get satisfied until we guarantee we can run same product with major paid versions (Oracle, MS SQL, and so on). I think this is a business problem not a technology problem. Forget trying

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Chris Travers
Wandering away from the original topic a little but helpful enough to continue this line of reasoning here. On Sat, Sep 1, 2012 at 5:42 AM, Edson Richter edsonrich...@hotmail.comwrote: It's an interesting thing. We have a product that runs over PostgreSQL without any problems (well, we have

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Scott Marlowe
On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers chris.trav...@gmail.com wrote: 1) While MySQL is perhaps better marketed, PostgreSQL is an older project with a proud heritage (Informix started as a Postgres fork), and top-rate Pretty sure that's not true. Ingres is a cousin of Postgres started

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Chris Travers
On Sat, Sep 1, 2012 at 7:45 AM, Scott Marlowe scott.marl...@gmail.comwrote: On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers chris.trav...@gmail.com wrote: 1) While MySQL is perhaps better marketed, PostgreSQL is an older project with a proud heritage (Informix started as a Postgres fork),

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Tom Lane
Scott Marlowe scott.marl...@gmail.com writes: On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers chris.trav...@gmail.com wrote: 1) While MySQL is perhaps better marketed, PostgreSQL is an older project with a proud heritage (Informix started as a Postgres fork), and top-rate Pretty sure that's

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Scott Marlowe
On Sat, Sep 1, 2012 at 9:01 AM, Tom Lane t...@sss.pgh.pa.us wrote: Scott Marlowe scott.marl...@gmail.com writes: On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers chris.trav...@gmail.com wrote: 1) While MySQL is perhaps better marketed, PostgreSQL is an older project with a proud heritage

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Pavel Stehule
2012/9/1 Tom Lane t...@sss.pgh.pa.us: Scott Marlowe scott.marl...@gmail.com writes: On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers chris.trav...@gmail.com wrote: 1) While MySQL is perhaps better marketed, PostgreSQL is an older project with a proud heritage (Informix started as a Postgres

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Pavel Stehule
2012/9/1 Chris Travers chris.trav...@gmail.com: On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder ayo...@airfacts.com wrote: Hello all, I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the

Re: [GENERAL] Too far out of the mainstream

2012-09-01 Thread Stefan Kaltenbrunner
On 09/01/2012 01:24 PM, Peter Bex wrote: On Sat, Sep 01, 2012 at 12:43:15AM +0200, Geert Mak wrote: There is this case studies section as well - http://www.postgresql.org/about/casestudies/ Which appear to me a little old and a little too little, one could try to add more, perhaps. I

[GENERAL] Too far out of the mainstream

2012-08-31 Thread Andy Yoder
Hello all, I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the concern our client's IT group has about our use of PostgreSQL in our shop. The group in question supports multiple

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Scott Marlowe
So do they ever go to a site that ends in .org or .info? Tell them to stop it right now, as they are relying on PostgreSQL for those sites to resolve, and PostgreSQL is too far out of the mainstream. Once they've stopped using or visiting .org and .info sites tell them to get back to you. On

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Andy Yoder Sent: Friday, August 31, 2012 3:25 PM To: pgsql-general@postgresql.org Cc: Andy Yoder Subject: [GENERAL] Too far out of the mainstream Hello all, I

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Andrew Sullivan
On Fri, Aug 31, 2012 at 02:25:13PM -0500, Andy Yoder wrote: I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing the concern our client's IT group has about our use of PostgreSQL in our shop.

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Scott Marlowe
On Fri, Aug 31, 2012 at 2:05 PM, Andrew Sullivan a...@crankycanuck.ca wrote: On Fri, Aug 31, 2012 at 02:25:13PM -0500, Andy Yoder wrote: I would like the community's input on a topic. The words too far out of the mainstream are from an e-mail we received from one of our clients, describing

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Steve Atkins
On Aug 31, 2012, at 12:45 PM, Scott Marlowe scott.marl...@gmail.com wrote: So do they ever go to a site that ends in .org or .info? Tell them to stop it right now, as they are relying on PostgreSQL for those sites to resolve, and PostgreSQL is too far out of the mainstream. Once they've

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Geert Mak
A response to this sort of question from the .org TLD redelegation is still available online: http://archive.icann.org/en/tlds/org/questions-to-applicants-13.htm#Response13TheInternetSocietyISOC. The details in that answer are all obsolete, of course, since it's from several years (and

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Andrew Sullivan
On Fri, Aug 31, 2012 at 04:00:06PM -0600, Scott Marlowe wrote: One of the most fascinating things to come out of the whole Afilias winning the right to host the .org and .info domains was Oracle's PR response to the suggestion of using postgresql. Wish I could find it. It was only the .org

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Scott Marlowe
On Fri, Aug 31, 2012 at 4:14 PM, Steve Atkins st...@blighty.com wrote: On Aug 31, 2012, at 12:45 PM, Scott Marlowe scott.marl...@gmail.com wrote: So do they ever go to a site that ends in .org or .info? Tell them to stop it right now, as they are relying on PostgreSQL for those sites to

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Scott Marlowe
On Fri, Aug 31, 2012 at 4:47 PM, Andrew Sullivan a...@crankycanuck.ca wrote: Anyway, this is all an amusing walk down memory lane. Thanks for the reminder! Hard to believe it was so long ago! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Steve Atkins
On Aug 31, 2012, at 4:15 PM, Scott Marlowe scott.marl...@gmail.com wrote: Unless things have changed, Andrew Sullivan in this message http://archives.postgresql.org/pgsql-advocacy/2002-09/msg00012.php says: All interactions with the shared registry system, and any whois queries against

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Andrew Sullivan
On Fri, Aug 31, 2012 at 03:14:30PM -0700, Steve Atkins wrote: Mmm. Don't push this line of argument too hard. As I understand it, Postgresql is used by the registry to keep track of their customers - whois data, effectively. No, the Postgres back end in the Afilias implementation I worked on

Re: [GENERAL] Too far out of the mainstream

2012-08-31 Thread Andrew Sullivan
On Fri, Aug 31, 2012 at 04:31:09PM -0700, Steve Atkins wrote: dot-org is actually powered by UltraDNS tech (since bought out by Afilias) rather than bind. And that is directly SQL database backed, though likely not the database we know and love. No, it is not. Afilias did not buy UltraDNS.