Subject: RE: [Asterisk-Users] OT: Best DB
What is the best truck? A recent survey finds that
there are far more Ford Rangr pickup trucks on the road
then there are Frightliner 18 wheelers
In another survey we find that Chevy outnumbers Porche.
Closer to home in the computer world, more people use
MS
On March 18, 2005 07:08 pm, Mike Sander wrote:
But Budwieser tastes like water to most Australian beer drinkers.
No, it tastes like piss to pretty much everyone. They just have a great
marketing budget.
-A.
___
Asterisk-Users mailing list
First, for an on-topic comment :-)
Which database you choose will largely have the most to do with what
applications you need to integrate your Asterisk databases with. If
those applications are based on MySQL, you may need to use that. Ditto
with Oracle, MS SQL, etc. My personal favorite is
David Brodbeck wrote:
This Postgres vs. MySQL business is ultimately just a religious debate, like
PC vs. Mac, Ford vs. Chevy, or Kirk vs. Picard.
With all due respect I disagree. It is much more like a public policy
debate. There are those of us in any of the Oracle, DB2, or PostgreSQL
What is the best truck? A recent survey finds that
there are far more Ford Rangr pickup trucks on the road
then there are Frightliner 18 wheelers
In another survey we find that Chevy outnumbers Porche.
Closer to home in the computer world, more people use
MS Windows than Solaris.
I think
On 15 Mar 2005, at 23:52, Giudice, Salvatore wrote:
we were able to handle a peak of 700k inserts per hour. MySQL gave us
very few problems and probably had a cumulative downtime of
approximately 4 days per year until the project was decommissioned.
When
y
That's more than 1% downtime, not even
On March 15, 2005 06:04 pm, Giudice, Salvatore wrote:
commercial licensing AND has a real enterprise class support structure
behind it, or are you going to run with PostgreSQL (bow wow) distributed
under a BSD license with some mom and pop support shops and some mailing
It's time to put up or
Data validation should be done at all levels. Period.
Validating the SAME data at each level greatly decreases your speed.
True, but at the expense of data reliability and security. If one
validation layer is compromised (buffer overflow, packet injection, or
even a bad link between client
On Tue, 2005-03-15 at 13:00 -0500, Giudice, Salvatore wrote:
MySQL: Speed, Power and Precision
_
Speed, yes. Anyone can write an SQL layer over a flat file and make it
fast. If you want real speed (faster than MySQL with the same level of
reliability choose
This Postgres vs. MySQL business is ultimately just a religious debate, like
PC vs. Mac, Ford vs. Chevy, or Kirk vs. Picard. They both work; they both
have their plusses and minuses; and debates about which are better never
convince anyone to change their preconceived ideas. It's also about as
PostgreSQL fantasy.
-Original Message-
From: Andrew Kohlsmith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 6:44 AM
To: asterisk-users@lists.digium.com
Subject: Re: [Asterisk-Users] OT: Best DB
On March 15, 2005 06:04 pm, Giudice, Salvatore wrote:
commercial licensing AND has
-Original Message-
From: Giudice, Salvatore [mailto:[EMAIL PROTECTED]
As for your 'artist license with your data' comment, put it into some
context. I would blame a programmer for trying to insert a
string of 255
characters into a field only 100 character wide. Maybe you could
I believe the driving factors for this are the ability to commercially
license Mysql for product integration over PostgreSQL's BSD license,
This is a ridiculous FUD statement. Are you actually trying to suggest that
one cannot commercially license PostgreSQL?
That's simply FALSE.
The primary
Ok, we all get it, some people prefer mysql, some people prefer postgres.
Now can we all just get on with our life or at least create a mailing list:
[EMAIL PROTECTED]
so that those people who think that mustard tastes better than ketchup have
somewhere more appropriate to argue.
Thanks,
My apologies to the rest of the readers for the flame, but Mr
Salvatore, you are sadly misinformed.
I like MySQL as well as PostgreSQL and they both have their merits,
but it's annoying to see someone give a recommendation of one over the
other based on ignorance instead of relevant facts.
If
/benchmarks.ht
ml
-Original Message-
From: Chris Travers [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 13, 2005 2:27 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
At the risk of sounding like a closed source fan (I'm not) I do
On March 15, 2005 01:00 pm, Giudice, Salvatore wrote:
MySQL: Speed, Power and Precision
Now *that* is funny. Thank you for bringing some humour to the list. Now
take the rest of this email and file it under FUD and exaggeration on MySQL's
capabilities, especially the benchmarks.
-A.
%.
-Original Message-
From: Andrew Kohlsmith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 1:40 PM
To: asterisk-users@lists.digium.com
Subject: Re: [Asterisk-Users] OT: Best DB
On March 15, 2005 01:00 pm, Giudice, Salvatore wrote:
MySQL: Speed, Power and Precision
Now
Giudice, Salvatore wrote:
Sticks and stone still break my bones, but PostgreSQL is still a dog.
Enough, take it off list, PLEASE!
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To
On Mar 15, 2005, at 11:21 AM, Giudice, Salvatore wrote:
x-tad-biggerSticks and stone still break my bones, but PostgreSQL is still a dog./x-tad-bigger
x-tad-bigger /x-tad-bigger
Market share:
x-tad-biggerAccording to CD Times magazine dated July 1, 2004/x-tad-bigger
x-tad-bigger Top Deployed
On March 15, 2005 02:21 pm, Giudice, Salvatore wrote:
Sticks and stone still break my bones, but PostgreSQL is still a dog.
Until you actually show some benchmarks where the tests are clearly documented
and Postgres is properly tuned, you're spreading FUD. Your testing should
also demonstrate
you stick with MySQL.
Cheers... SG
-Original Message-
From: Apollon Koutlides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 2:41 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
Richard Cook wrote:
We use PostgreSQL
I could start a pretty big flame war if I tried to compare Windows 95 with
MacOS X by deployment stats instead of stability. [David
Brodbeck]I've seen Mac OS X locked up solid just by putting in
adamaged CD-R disc. It's a nice OS, mind you, but it's not as
stable as some people
On Tue, 2005-03-15 at 14:21 -0500, Giudice, Salvatore wrote:
Sticks and stone still break my bones, but PostgreSQL is still a dog.
Market share:
According to CD Times magazine dated July 1, 2004
Top Deployed Databases poll shows following databases in use:
SQL Server with 78%,
-Original Message-
From: Steven Critchfield [mailto:[EMAIL PROTECTED]
Top Deployed Databases poll shows following databases in use:
SQL Server with 78%, Oracle - 55%, MySQL - 33% and PostgreSQL - 8%.
I see they created this with Mysql,
78 + 55 + 44 + 8 = 185%
I'm sure if
Comment:
Best sometimes gets fuzzy.
MySQL's mind-share is frightening.
Because of the mind-share/marketing I see MySQL being deployed where
perhaps PostgreSQL should be and Oracle is considered too expensive.
(avoiding MS SQL server. :) )
Also probably due to the 'mind-share' documenation is
Giudice, Salvatore wrote:
MySQL: Speed, Power and Precision
Thanks, I will file this in my MySQL Appointment Book under Feb 31.
Oh, you mean that is not a valid date? MySQL had no problem with it...
Seriously though, precision and accuracy are not strongpoints of MySQL.
MySQL really has
, 2005 2:49
PM
To: Asterisk
Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT:
Best DB
On Mar
15, 2005, at 11:21 AM, Giudice, Salvatore wrote:
Sticks and stone still break my bones, but PostgreSQL is still a
dog.
Market share:
According to CD Times
indexes.
Either way, pick whichever DB you feel comfortable with regard to your
circumstances.
-Original Message-
From: Chris Travers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 5:57 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT
2:49 PM
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [Asterisk-Users] OT: Best DB
On Mar 15, 2005, at 11:21 AM, Giudice, Salvatore wrote:
Sticks and stone still break my bones, but PostgreSQL is still a dog.
*Market share:*
According to CD Times magazine dated July 1
quote who=Giudice, Salvatore
So, let me see if I am right. You run a support shop? You want your
database to validate your data for you instead of leaving that logic
to
your application? Usually, a database is considered to be an asset
worth
protecting from unvalidated user input. Also, do
On Tue, 15 Mar 2005 18:52:00 -0500, Giudice, Salvatore
[EMAIL PROTECTED] wrote:
So, let me see if I am right. You run a support shop? You want your
database to validate your data for you instead of leaving that logic to
your application? Usually, a database is considered to be an asset worth
On Tuesday 15 March 2005 06:34 pm, Robert Hajime Lanning wrote:
quote who=Giudice, Salvatore
So, let me see if I am right. You run a support shop? You want your
database to validate your data for you instead of leaving that logic
to
your application? Usually, a database is considered to
On Tue, 2005-03-15 at 19:04 -0600, Jon Gabrielson wrote:
On Tuesday 15 March 2005 06:34 pm, Robert Hajime Lanning wrote:
quote who=Giudice, Salvatore
So, let me see if I am right. You run a support shop? You want your
database to validate your data for you instead of leaving that logic
At the risk of sounding like a closed source fan (I'm not) I do think
you should
at least consider Oracle for this job.
I built a system a few years ago which takes a constant stream of
entries from a number (100)
of remote systems analizes them and generates reports
(see
[EMAIL PROTECTED] wrote:
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different sorts of
backgrounds, I thought I would get the best opinions here.
We have several different switches and other telecom equipment at our
facilities which
On March 10, 2005 07:14 pm, Giudice, Salvatore wrote:
I vote for MySQL. PostgreSQL is fine, but MySQL handles much better
under extreme load. MySQL is also usually touted as being generally
You *gotta* be kidding me. MySQL can't hold a candle to PostgreSQL for high
load, high volume or
On Fri, Mar 11, 2005 at 01:56:47PM -0500, Giudice, Salvatore wrote:
As for the production recommendation you refer to, I would
respectufully disagree. If you are an enterprise comapny looking to
deploy an open-source DB, you will pick the one that has an established
support company to
On Fri, Mar 11, 2005 at 04:25:59PM -0500, David Filion wrote:
Maybe I miss read, but doesn't the licensing of the newer releases of
MySQL require companies to purchase a license?
No. The license is GPL. Originally it was LGPL for the client libraries
but this got changed recently.
So you
If you're a VoIP provider, and are trying to
provide a near carrier-grade service, postgres shines.
I'm not disagreeing with you, but we are a CLEC and we do provide
'carrier-grade' service and we use MySQL everywhere.
IMHO, MySQL is just so much more easy to use, install and maintain.
On Fri, 2005-03-11 at 08:51 -0600, Matthew Boehm wrote:
If you're a VoIP provider, and are trying to
provide a near carrier-grade service, postgres shines.
I'm not disagreeing with you, but we are a CLEC and we do provide
'carrier-grade' service and we use MySQL everywhere.
people to support. Green pill or
blue pill, it's your choice...
-Original Message-
From: Mohit Muthanna [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 8:06 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
On Thu, 10 Mar
My god. WTF is doing 700,000 inserts/hour for 2TB of data?
-Matthew
Giudice, Salvatore wrote:
I have had MySQL databases running in excess of 2 terrabytes handling
up to 700,000 inserts/hour on an 8 cpu machine. Try doing that with
PostgreSQL.
___
Security events generated from IDS.
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
Sent: Friday, March 11, 2005 3:11 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
My god. WTF is doing 700,000 inserts/hour
quote who=Giudice, Salvatore
Security events generated from IDS.
That is called logging noise.
That must have been a experiment in statistic anomalies and trends.
--
END OF LINE
-MCP
___
Asterisk-Users mailing list
, 2005 3:11 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
My god. WTF is doing 700,000 inserts/hour for 2TB of data?
-Matthew
Giudice, Salvatore wrote:
I have had MySQL databases running in excess of 2 terrabytes handling
up
postgreSQL is easier for your people to support. Green pill or
blue pill, it's your choice...
-Original Message-
From: Mohit Muthanna [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 8:06 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT
On Wed, 9 Mar 2005, [EMAIL PROTECTED] wrote:
For some reason I didn't think PostgreSQL was for mission critical apps. I
don't think I have any reasoning behind it, just didn't think it was
hardcore...sounds like i might be wrong...i'll have to look into it more.
For your app, probably either
On Thu, Mar 10, 2005 at 01:04:35AM -0700, Forrest W. Christian said:
I understand that PostgreSql has also gotten faster than it used to be.
It's interesting. Just yesterday I was saying that we use both MySQL and
Postgres here, and that we were probably going to move everything to
postgres just
Walt Reed wrote:
On Thu, Mar 10, 2005 at 01:04:35AM -0700, Forrest W. Christian said:
I understand that PostgreSql has also gotten faster than it used to be.
It's interesting. Just yesterday I was saying that we use both MySQL and
Postgres here, and that we were probably going to move
On March 10, 2005 08:44 am, Walt Reed wrote:
Now one of our lead engineers has done some performance testing last
night for our
app and found MySQL to be 8 to 100 times faster for all but one of our
operations (combination of ~80% reads, 20% writes on the InnoDB table
type.) His testing
of
it will reside in memory due to caching anyway.
-Original Message-
From: Steven Critchfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 1:00 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: RE: [Asterisk-Users] OT: Best DB
If it stores the entire DB in 1
On Thu, Mar 10, 2005 at 08:55:53AM -0500, David Filion said:
Walt Reed wrote:
Now one of our lead engineers has done some performance testing last
night for our
app and found MySQL to be 8 to 100 times faster for all but one of our
operations (combination of ~80% reads, 20% writes on the
I'd *love* to see the particulars of that test. It's been
shown time and time
again that postgres' speed CLOBBERS mysql for anything but
the simplest
selects, and that it can handle far more concurrent
connections without
slowing down.
I strongly agree with this, i have a prepaid
Subject: RE: [Asterisk-Users] OT: Best DB
If it stores the entire DB in 1 file, it can not scale as
well as other DBs. Postgres 8 supports splitting a single DB
up so you can put portions of it on different media if
needed. If you have to tune for absolute speed, you can
purchase one
On Thu, 2005-03-10 at 09:17 -0500, Andrew Kohlsmith wrote:
On March 10, 2005 08:44 am, Walt Reed wrote:
Now one of our lead engineers has done some performance testing last
night for our
app and found MySQL to be 8 to 100 times faster for all but one of our
operations (combination of ~80%
On Thu, Mar 10, 2005 at 09:09:09AM -0600, [EMAIL PROTECTED] said:
I'd *love* to see the particulars of that test. It's been
shown time and time
again that postgres' speed CLOBBERS mysql for anything but
the simplest
selects, and that it can handle far more concurrent
connections
.
-Original Message-
From: Steven Critchfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 10:45 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: RE: [Asterisk-Users] OT: Best DB
On Thu, 2005-03-10 at 08:57 -0600, Jay Milk wrote:
IB/FB stores the DB
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 2:41 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
Richard Cook wrote:
We use PostgreSQL in house. It performs wonderfully and cross-platform
drivers (ODBC, .NET) are way further
On Thu, 10 Mar 2005 19:14:36 -0500, Giudice, Salvatore
[EMAIL PROTECTED] wrote:
I vote for MySQL. PostgreSQL is fine, but MySQL handles much better
under extreme load. MySQL is also usually touted as being generally
I'd have to (respectfully) disagree with that... MySQL just cannot
handle high
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different sorts of backgrounds,
I thought I would get the best opinions here.
We have several different switches and other telecom equipment at our
facilities which all have their own
On Wed, 2005-03-09 at 14:50 -0500, [EMAIL PROTECTED] wrote:
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different sorts of backgrounds,
I thought I would get the best opinions here.
We have several different switches and other
On Wed, Mar 09, 2005 at 02:50:47PM -0500, [EMAIL PROTECTED] wrote:
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different sorts of
backgrounds, I thought I would get the best opinions here.
We have several different switches and
] OT: Best DB
On Wed, Mar 09, 2005 at 02:50:47PM -0500, [EMAIL PROTECTED] wrote:
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different sorts of
backgrounds, I thought I would get the best opinions here.
We have several different switches
-users@lists.digium.com
Sent: Wednesday, March 09, 2005 3:18 PM
Subject: Re: [Asterisk-Users] OT: Best DB
On Wed, Mar 09, 2005 at 02:50:47PM -0500, [EMAIL PROTECTED] wrote:
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different
On Wed, 2005-03-09 at 15:43 -0500, [EMAIL PROTECTED] wrote:
For some reason I didn't think PostgreSQL was for mission critical apps. I
don't think I have any reasoning behind it, just didn't think it was
hardcore...sounds like i might be wrong...i'll have to look into it more.
Open source
On Wed, Mar 09, 2005 at 03:02:03PM -0600, Steven Critchfield said:
On Wed, 2005-03-09 at 15:43 -0500, [EMAIL PROTECTED] wrote:
For some reason I didn't think PostgreSQL was for mission critical apps. I
don't think I have any reasoning behind it, just didn't think it was
hardcore...sounds
On Wed, 2005-03-09 at 15:02 -0600, Steven Critchfield wrote:
On Wed, 2005-03-09 at 15:43 -0500, [EMAIL PROTECTED] wrote:
For some reason I didn't think PostgreSQL was for mission critical apps. I
don't think I have any reasoning behind it, just didn't think it was
hardcore...sounds like
, it's a beautiful thing.
-Original Message-
From: Adam Goryachev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 7:40 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] OT: Best DB
On Wed, 2005-03-09 at 15:02 -0600, Steven
On Thu, 2005-03-10 at 00:37 -0600, Jay Milk wrote:
So much for the history. As for usability, IB is your typical (almost)
ANSI SQL-92 compliant database engine. It supports RI, triggers, stored
procs, just like we all like'em. Its engine is touted for the
superserver architecture but in
I know this is a bit off topic but we are using Asterisk :)
Since this list is full of tech gurus w/ all different sorts
of backgrounds, I thought I would get the best opinions here.
We have several different switches and other telecom
equipment at our facilities which all have their
Richard Cook wrote:
We use PostgreSQL in house. It performs wonderfully and cross-platform
drivers (ODBC, .NET) are way further along than MySQL. We switched from
MySQL a couple of months ago and have never been happier.
We use Postgres exclusively too (12 databses, several of them with
several
72 matches
Mail list logo