473,839 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Humor me: Postgresql vs. MySql (esp. licensing)

Yes, I know you've seen the above subject before, so please be gentle with
the flamethrowers.

I'm preparing to enter a discussion with management at my company
regarding going forward as either a MySql shop or a Postgresql shop.

It's my opinion that we should be using PG, because of the full ACID
support, and the license involved. A consultant my company hired before
bringing me in is pushing hard for MySql, citing speed and community
support, as well as ACID support.

My biggest concern with MySQL is licensing. We need to keep costs low,
and last I remember the parent company was being pretty strict on "fair
use" under the GPL. If I recall, they even said a company would have to
license the commercial version if it were simply used operationally within
the company.

Also, I was under the impression that Postgresql had pretty much caught up
with MySql in the speed category...is this not the case?

Finally, ACID support in mysql always seemed kind of a hack....perhaps
this has changed?

Thanks for any input (armament ;) ) you can provide.

John

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05
74 8071
On Fri, 10 Oct 2003, Martin Marques wrote:
El Jue 09 Oct 2003 22:44, Marsh Ray escribió:
Just out of curiosity, what does Debian make MySQL's rather bizarre
interpretaion of the GPL:

http://www.mysql.com/documentation/m...roduction.html
#Copyright --- begin quote ----

You need a commercial license:
[...]
When you distribute a non-|GPL| application that *only* works with
the |MySQL| software and ship it with the |MySQL| software. This type of
solution is considered to be linking even if it's done over a network.

--- end quote ----
"Linking over a network"? What stops some GPL'ed web server (or
commercial one for that matter) from demanding non-free licensing for
web clients that connect to it?


I would like to know what Debian is going to do with PHP and MySQL. There's
alot of talk about this in the PHP related lists.
PHP folks do think that there may be some sort of incompatibility between the
two licenses.


Basically, if you include MySQL connect libs in PHP and distribute it PHP
now falls under the GPL. Since PHP's license expressly forbids
relicensing, they are incompatible to distribute together. This was
caused by MySQL changing their connect libs from LGPL to GPL. It's why
PHP now no longer includes MySQL connect libs in their source tree.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #51
On Fri, 2003-10-10 at 12:54, Martin Marques wrote:
I would like to know what Debian is going to do with PHP and MySQL.


You can raise the issue with Debian's mysql package maintainer
(my***@packages .debian.org) and with the mailing list
de**********@li sts.debian.org.

--
Oliver Elphick Ol************@ lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
=============== =============== ==========
"He that covereth his sins shall not prosper; but whoso
confesseth and forsaketh them shall have mercy."
Proverbs 28:13
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #52
My experience with mysql and postgres was this. I had some apps that were
running on SQL Server and I wanted to get rid of it because it was
expensive. Didn't really do much for us that the others couldn't, and I
wanted to get rid of windows. Plus administrativel y SQL Server just seemed
to have a lot more weird problems than the other two. So I started porting
one of my apps simultaneously to both postgres and mysql. I got to a part
of my app that used unions. At that time mysql didn't support unions (I
realize that it does now). I was absolutely amazed. Needless to say I
dropped mysql right there and have used nothing but postgres ever since.
The learning curve was maybe a tiny, tiny bit steeper than mysql but that is
just because postgres tends to do things right and then make them simple
(for example having sequences and then adding the serial key word) whereas
mysql just makes them simple. Once I started figuring things out though I
lost any desire to ever look at mysql again because there were so many areas
where postgres excelled and mysql lacked.

crg

----- Original Message -----
From: "bob parker" <bo********@dod o.com.au>
To: "John Wells" <jb@sourceillus trated.com>; <pg***********@ postgresql.org>
Sent: Thursday, October 09, 2003 5:12 PM
Subject: Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

On Thu, 9 Oct 2003 01:28, John Wells wrote:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers.

I'm preparing to enter a discussion with management at my company
regarding going forward as either a MySql shop or a Postgresql shop.

It's my opinion that we should be using PG, because of the full ACID
support, and the license involved. A consultant my company hired before
bringing me in is pushing hard for MySql, citing speed and community
support, as well as ACID support.
Apologies for the empty reply - my mind is on brain death so I needed to
imitate it.

I'll address only the alleged community support for MySql because you will
get much better qualified replies to your other concerns from others.

About 18 months ago I had to choose a DB for my home grown small systems.
Knowing very little about them I lurked on the both this list and a MySql
list for a couple of months.

In contrast to this list, the MySql one not only had a high proportion of
brain dead questions, there were a fair few answers of the same grade too.

I quickly decided that Postgresql was the better product by far for that

and many other reasons.

HTH
Bob

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #53
>>>>> "sm" == scott marlowe <scott.marlow e> writes:
will ungracefully kill the DB process(es). Doesn't matter what DB (or
any other application) you're running, you *can* lose data this way.


sm> While it is possible to lose a non-committed transaction, WAL prevents the
sm> database from becoming corrupted. Assuming proper fsyncing of your hard
sm> drives (i.e. SCSI, or IDE with write cache disabled)

So you're saying it is not possible to corrupt the WAL if the process
is ungracefully killed by the OS?

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: kh***@kciLink.c om Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #54
Vivek Khera wrote:
>> "sm" == scott marlowe <scott.marlow e> writes: will ungracefully kill the DB process(es). Doesn't matter what DB (or
any other application) you're running, you *can* lose data this way.


sm> While it is possible to lose a non-committed transaction, WAL prevents the
sm> database from becoming corrupted. Assuming proper fsyncing of your hard
sm> drives (i.e. SCSI, or IDE with write cache disabled)

So you're saying it is not possible to corrupt the WAL if the process
is ungracefully killed by the OS?


Yes, it is impossible, even if the OS crashes too.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #55
On Fri, 10 Oct 2003, Vivek Khera wrote:
>> "sm" == scott marlowe <scott.marlow e> writes: will ungracefully kill the DB process(es). Doesn't matter what DB (or
any other application) you're running, you *can* lose data this way.


sm> While it is possible to lose a non-committed transaction, WAL prevents the
sm> database from becoming corrupted. Assuming proper fsyncing of your hard
sm> drives (i.e. SCSI, or IDE with write cache disabled)

So you're saying it is not possible to corrupt the WAL if the process
is ungracefully killed by the OS?


No, but it doesn't matter if it is corrupted, because the corrupted part
would be at the end, where a transaction was starting, and would just get
ignored. i.e. postgresql would replay only the parts of the WAL that
were complete and showed as committed.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #56
Vivek Khera <kh***@kcilink. com> writes:
I think it is a timing issue. The PG has no way to notify the OS that
it has finished exiting, so if it takes a long time to exit, the OS
will ungracefully kill the DB process(es). Doesn't matter what DB (or
any other application) you're running, you *can* lose data this way.


You most certainly will *not* lose data that way. Committed
transactions will stay committed, no matter how the Postgres processes die.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #57
In article <39************ *************** *******@mail.de vsea.com>,
John Wells <jb@devsea.co m> wrote:
Here's an interesting response from mysql.com sales. Frankly, I don't see
how using it on multiple internal servers violates the GPL?!?:


You're talking to a sales droid, a suit, someone whose brain
cells have died off because his tie was tied to tight.

So remember the old adage .. "never attribute to malice that
which can be adequately explained by stupidity."

Mike.
--
Never trust a statistic you didn't fake yourself.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #58
[sNip]
Do a shutdown -h on a live database machine with pg. It will gracefully
shut itself down.


Is that true for all OS flavors and is it dependent upon the DBA having
set up proper shutdown scripts?

[sNip]

When I tested this on PostgreSQL on Novell NetWare 6 it shut down
gracefully. I don't see why this would be different on other Operating
Systems since the code base is essentially the same (isn't it?).

--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.

Nov 12 '05 #59
[sNip]
"We have all the features they do! Nobody uses views or triggers!"


Which cave has that person been hiding in all these years? Views are a
very important part of SQL, and any SQL server that doesn't support Views is,
in my view (sorry, I couldn't resist), simply isn't suitable for large scale
applications (and even some small ones that will use a table in many
different ways).

--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.

Nov 12 '05 #60

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
1509
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A consultant my company hired before bringing me in is pushing hard for MySql, citing speed and community...
0
9855
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9697
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10906
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10292
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9426
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5682
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4482
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4064
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3132
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.