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 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 developers build a database ser

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 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 >> platform. >> >> T

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 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

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 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 >> platform. >> >> T

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 Damian Carey
On Sat, Sep 1, 2012 at 5:25 AM, Andy Yoder 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 > PostgreSQL i

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 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 wrote: > > > > > So people are using PostgreSQL in roles that aren't very visible > >

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 befo

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 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 m

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 MyS

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 > 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 resynchro

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 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 (satellite?) comms? The system

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 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 re

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 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 people working for huge s

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 subscript

Re: [GENERAL] "Too far out of the mainstream"

2012-09-04 Thread Chris Travers
On Tue, Sep 4, 2012 at 9:06 PM, Ondrej Ivanič wrote: > Hi, > > On 5 September 2012 12:14, Chris Travers 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 distribu

Re: [GENERAL] "Too far out of the mainstream"

2012-09-04 Thread Ondrej Ivanič
Hi, On 5 September 2012 12:14, Chris Travers 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. > > Not only > this but there was significan

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 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 resta

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 wrote: > > > 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 tough because of i

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

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 wrote: > On 05/09/12 08:38, Scott Marlowe wrote: > > On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower > 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 da

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 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 without special recovery act

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 wrote: On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak 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 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 question > supports

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 wrote: > On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak 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 > the

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 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 pgsql-general mail

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-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 -- Sen

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-02 Thread Chris Travers
On Sat, Sep 1, 2012 at 8:01 AM, Tom Lane wrote: > Scott Marlowe writes: > > On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers > 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 >

Re: [GENERAL] "Too far out of the mainstream"

2012-09-01 Thread Johan Nel
"Chris Travers" wrote in message news:CAKt_ZfvZfYq_VPYXG3p=fy=s1whcc0p9trxkczfrrsjsqms...@mail.gmail.com... On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder 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-mai

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, perh

Re: [GENERAL] "Too far out of the mainstream"

2012-09-01 Thread Pavel Stehule
2012/9/1 Chris Travers : > > > On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder 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 g

Re: [GENERAL] "Too far out of the mainstream"

2012-09-01 Thread Pavel Stehule
2012/9/1 Tom Lane : > Scott Marlowe writes: >> On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers >> 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. I

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 wrote: > Scott Marlowe writes: >> On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers >> 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 > >> Pr

Re: [GENERAL] "Too far out of the mainstream"

2012-09-01 Thread Tom Lane
Scott Marlowe writes: > On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers 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 s

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 wrote: > On Sat, Sep 1, 2012 at 7:25 AM, Chris Travers > 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

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 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 by the same guy, Ston

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 wrote: > >> It's an interesting thing. > We have a product that runs over PostgreSQL without any problems (well, we > have few, but most of th

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
On Fri, Aug 31, 2012 at 12:25 PM, Andy Yoder 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 > PostgreSQL

Re: [GENERAL] "Too far out of the mainstream"

2012-09-01 Thread Edson Richter
o far out of the mainstream" 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 ou

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" lin

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 UltraDN

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

Re: [GENERAL] "Too far out of the mainstream"

2012-08-31 Thread Steve Atkins
On Aug 31, 2012, at 4:15 PM, Scott Marlowe 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 whois.afilias.net

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 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 subscription: http://www

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 wrote: > > On Aug 31, 2012, at 12:45 PM, Scott Marlowe 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

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 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 Po

Re: [GENERAL] "Too far out of the mainstream"

2012-08-31 Thread Steve Atkins
On Aug 31, 2012, at 12:45 PM, Scott Marlowe 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 stopped using or visit

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 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 the concern

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

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

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 Fri

[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 differe