473,701 Members | 2,704 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Mysql Vs. Postgresql

Perhaps posted it on wrong forums initially as I got only one response
(which was helpful but I was looking for more). Please help if you can!

=============== =============== =============== ==

Hi Database Gurus,

Not to start a war among fanatics, but I just wanted to get honest
opinion/advise of smart folks like you about this. We are about to begin
development for a data intensive web based application and are faced with
the choice of database software. We (at least currently) are focusing on
free software. Some basic research has indicated both Postgresql and Mysql
as the best of lot.

Can people please advise as to pros/cons of each of these ? I am looking
from the following angles:

a.. Performance (Scalability)
b.. Reliability
c.. Ease of use
d.. Extensibility and portability (If we were to migrate to some other
database engine in the future, for example Oracle)
e.. Feature rich-ness
f.. Rich-ness of other tools available around the database engine
g.. Anything else that I have missed.

Are there any pointers to any online work that has done comparisons
between these two ?

Please do reply. Any help/guidance will be truly appreciated.

Thanks in advance!

=============== =============== =============== =============== =========
Email : myoda0001 AT yahoo.com
Website: http://www.eruditionhome.com [Excellent site for data mining
tutorials and resouces]
=============== =============== =============== =============== =========
Sep 29 '06 #1
2 3513
I suggest you take a look at wikipedia, in particular:

http://en.wikipedia.org/wiki/Compari...gement_systems
http://en.wikipedia.org/wiki/Comparison_of_SQL_syntax

my*******@yahoo .com wrote:
Perhaps posted it on wrong forums initially as I got only one response
(which was helpful but I was looking for more). Please help if you can!

=============== =============== =============== ==

Hi Database Gurus,

Not to start a war among fanatics, but I just wanted to get honest
opinion/advise of smart folks like you about this. We are about to begin
development for a data intensive web based application and are faced with
the choice of database software. We (at least currently) are focusing on
free software. Some basic research has indicated both Postgresql and Mysql
as the best of lot.

Can people please advise as to pros/cons of each of these ? I am looking
from the following angles:

a.. Performance (Scalability)
b.. Reliability
c.. Ease of use
d.. Extensibility and portability (If we were to migrate to some other
database engine in the future, for example Oracle)
e.. Feature rich-ness
f.. Rich-ness of other tools available around the database engine
g.. Anything else that I have missed.

Are there any pointers to any online work that has done comparisons
between these two ?

Please do reply. Any help/guidance will be truly appreciated.

Thanks in advance!

=============== =============== =============== =============== =========
Email : myoda0001 AT yahoo.com
Website: http://www.eruditionhome.com [Excellent site for data mining
tutorials and resouces]
=============== =============== =============== =============== =========
Oct 3 '06 #2
Here are some links by me too:
I needed also to compare some features of mySQL and PostgresSQL for a
certain project.

PostGres is the most Oracle look-alike in the free-world
databases.MySQL used to be a runner-up behind PostGres,but as from
version 5.0 and 5.1 it has many new must-have features:
http://www.databasejournal.com/featu...le.php/3592726

First,read these 2 articles with all the forum posts in them (huge) ,
dedicated mainly to comparison between the two databases:
http://www.phpbuilder.com/columns/tim20001112.php3
http://www.phpbuilder.com/columns/tim20000705.php3

then:
http://www.databasejournal.com/featu...le.php/3288951
http://www-css.fnal.gov/dsg/external...-vs-mysql.html
http://sql-info.de/mysql/gotchas.html#1_1 ( a bit outdated )

Some things I found frustrating about mySQL:

They do not offer the the FETCH .. syntax for more than one row at a
time, i.e. you will have to loop and fetch 1 by 1 row. In PostGres you
can fetch as many rows as you want.

The LOB fieldsa are just ordinary Fields in mySQL , i.e. it is NOT so
flexible and it has some memory limitations as well. In PostGres they
are much like the Oracle LOBs ,where you have many options on them.
Both PostGres and mySQL do NOT provide any array interface for
manipulating large SELECT-like result statements. mySQL can be used
with an 3rd party library to emulate arrays:
http://datacharmer.blogspot.com/2005...outine_28.html
You are probably going to use some API to access mySQL or PostgresSQL .
For mySQL C API I can tell you that there are some frustrating
limitations ,but it is good anyway. Their APIs both support most of the
new features. If you need more info about that ( I am using mySQL C API
right now ) , email me.

Cheers,
Dragomir Stanchev

Oct 3 '06 #3

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

Similar topics

0
3483
by: Marek Lewczuk | last post by:
Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't availble in MySQL. Well, after installation and moving my MySQL dbs into PostgreSQL I decided to...
29
2579
by: smorrey | last post by:
I've been thinking on this long and hard, and I can't seem to come up with an answer on it. Why is it almost always assumed the MySQL will be the server for nearly any PHP app? Why is it MySQL and not PostGRES or SQLite? At this point the only reason I can think of is that MySQL has a much more friendly name. But is that really it?
33
5581
by: Joshua D. Drake | last post by:
Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake
74
8016
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...
3
2266
by: Marek Lewczuk | last post by:
Hello, I have changed DB from MySQL to PostgreSQL. When I have run my application on PostgreSQL it was disaster - it was much slower than MySQL... I have tried to change PG configuration file etc.. no luck. After many long days of thinking what is wrong I have made several tests with "EXPLAIN" statement, and to my amusement there was many SeqScan - MySQL didn't show that things. I have made some changes in PG db structure (new indexes...
175
11437
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I think is PostgreSQL would have less USP's (Uniqe Selling Points
67
12535
by: Bob Powell | last post by:
To whom it may concern: I find the recent articles in various trade publications a little disturbing due to the lack of PostgrSQL mention. I continue to see articles about how IBM may be considering MYSQL for development an open_source web database. Why isn't PostgreSQL being considered or talked about by major industry giants? As a DBA I know that Postgres is far superior to MYSQL but if the industry directs it's energies towards...
1
3358
by: Richard Huxton | last post by:
On Thursday 12 February 2004 20:25, Prashanthi Muthyala wrote: > Hi Richard Hi Prashanthi - nice to hear from you again. I've taken the liberty of cc-ing the general list on this, since there may be others who can help here. > I am trying to migrate the database and its tables from mysql in my > windows machine to postgresql in my new red hat linux . I was following > your links which has converstions from msaccess,mysql to postgresql...
11
9941
by: Mark Cubitt | last post by:
the reason I ask is I have always used postgres at home and work, but my new web host only has mysql :( I want to know what sort of differences I will have in regards to programming php/perl webpages using the database. I current use sequences in postgres and understand this will be different in mysql, so can you tell me what the difference will be and if there are any other differences I should look out for.
12
1806
by: howa | last post by:
any side effect for PHP? what do you think?
0
8738
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
8649
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
9085
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8936
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
7829
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
5905
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4411
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
3104
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
3
2036
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.