HPE GreenLake Administration
- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Linux
- >
- PostgreSQL vs MySQL
Operating System - Linux
1830211
Members
3101
Online
109999
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2003 07:03 AM
01-15-2003 07:03 AM
Hello all,
I installed RedHat 8.0 before. I need to prepare a free database for clients. I know that I need to pay money for the commercial usage of MySQL. So, I would like to try PostgreSQL.
Is there any difference between PostgreSQL and MySQL? Which one is better?
Please feel free to share your experience on the database usage of RedHat Linux.
Thanks in advance :)
I installed RedHat 8.0 before. I need to prepare a free database for clients. I know that I need to pay money for the commercial usage of MySQL. So, I would like to try PostgreSQL.
Is there any difference between PostgreSQL and MySQL? Which one is better?
Please feel free to share your experience on the database usage of RedHat Linux.
Thanks in advance :)
We master OpenView, my Lord masters us.
Solved! Go to Solution.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2003 02:57 PM
01-15-2003 02:57 PM
Solution
Many differences, mostly in the SQL commands they support, as well as some of the extended features.
For postgres, start by reading the first few chapters of:
http://www.postgresql.com/idocs/index.php
For MySQL, do the same (Unfortunately their site is down at the time of writing, so I can't get an exact URL for you). They have a very impressive online manual.
We use MySQL here in the office for most of our non-critical things (for those we use either custom written stuff, or Interbase).
MySQL at it's core is a very simple DB, and very quick. It supports a feature rich environment, and makes SQL statements quite useful (very little need to post-process).
The newer table formats also support a decent amount of the features to make it a force to be reconed with.
Unfortunately (the last I looked) it was still lacking in things like Triggers and stored procedures. (has been a while since I updated).
I've never activly used Postgres, but I've been told it is quite good.
Poke 'em, prod 'em, see how you like 'em.
My preference is for MySQL because of it's simpler interfaces and database maintenance.. But by the same token, I've been using it for years.
For postgres, start by reading the first few chapters of:
http://www.postgresql.com/idocs/index.php
For MySQL, do the same (Unfortunately their site is down at the time of writing, so I can't get an exact URL for you). They have a very impressive online manual.
We use MySQL here in the office for most of our non-critical things (for those we use either custom written stuff, or Interbase).
MySQL at it's core is a very simple DB, and very quick. It supports a feature rich environment, and makes SQL statements quite useful (very little need to post-process).
The newer table formats also support a decent amount of the features to make it a force to be reconed with.
Unfortunately (the last I looked) it was still lacking in things like Triggers and stored procedures. (has been a while since I updated).
I've never activly used Postgres, but I've been told it is quite good.
Poke 'em, prod 'em, see how you like 'em.
My preference is for MySQL because of it's simpler interfaces and database maintenance.. But by the same token, I've been using it for years.
One long-haired git at your service...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2003 03:32 PM
01-15-2003 03:32 PM
Re: PostgreSQL vs MySQL
We use both MySQL and PostgreSQL, and we've used Interbase in the past. In general, each has its advantages and disadvantages. We find MySQL to be best for high throughput, relatively low complexity transactional databases. We prefer PostgreSQL for heavily relational or object-relational stuff because Postgre tends to support a wider subset of SQL. We sort of got fed up with Interbase back when Borland couldn't make up its mind if it really was/wasn't going to support Interbase (IMHO a common concern with many Borland products--great though they may be at any given point in time).
Make sure you really understand the license for anything you use. Last I knew you could freely use MySQL to produce commercial databases. You just couldn't binary incorporate the SQL software into a commercial product or sell a modification of the MySQL software. If they've changed their license, then you could always find and use an older version of MySQL that follows the license arrangement I just described.
Make sure you really understand the license for anything you use. Last I knew you could freely use MySQL to produce commercial databases. You just couldn't binary incorporate the SQL software into a commercial product or sell a modification of the MySQL software. If they've changed their license, then you could always find and use an older version of MySQL that follows the license arrangement I just described.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
Company
Events and news
Customer resources
© Copyright 2025 Hewlett Packard Enterprise Development LP