We use PostgreSQL in a lot of projects. I think that this system is really good. It has a large community and it is open-source and flexible. The choise of database system depends on concrete project. For some purposes postgresql in better, for another one - oracle. :)
In regards database security, David Litchfield et al. (2005) mentioned in "the database Hacker's Handbook" chapter one in an answer to "Which Database is the Most Secure?" the Following:
"By default, PostgreSQL is possibly the most security-aware database available--but you can't connect to it over the network unless you explicitly enable that functionality".
Note that the Authors of the book examined many RDBMS including : Oracle, DB2, Informix, Sybase ASE, MySQL and SQL Server.
@Miren Karamta: To answer to your question, better that you look at PostGIS,
I think PostgreSQL is increasingly entering into companies that would chose Oracle a few years ago. The system is stable and should suit to a large number of applications. I've seen PostgreSQL used in Hospital applications, patient genetic data mgmt and even as the database for an important B2B company in Brazil.
Having said that, there are areas that postgreSQL must improve. For the processing of huge amount of data, parallel query processing techniques is a need. Oracle has a long story of supporting parallelism within its engine and with the acquisition of Sun it put in place the Exadata architecture combining hardware and software into a scalable integrated platform.
Another issue that some applications, especially in the web, are looking for relates to their deployment into a cloud (public or private). This may point you even to a different direction in which NoSQL systems are leading the edge.
Thus, the answer always depends on what your application business needs are.
Hi, i'm still working with postgres and it is a great DBMS, as many people say here, its free and i recommend it for all that you have to do with databases. Oracle is a big big monster, but you need a bigger DBMS than this?...
it depend on what operating system and security software you are running PostgreSQL. I will assume that you are running on Windows; you will need to know the following parameters:
- Your Lan IP address Range ( or scope ), where the clients computers.
- The IP and Port that PostgreSQL is running on; usually the computer IP address, where as port for PostgreSQL is 5432.
- Users' names,assigned IP addresses and access permission, where PostgreSQL can restrict the such access.
the configurations for accessing are divided into two section : The Operating system access security system ( that is the Firewall) and the PostgreSQL Configuration system.
For instructions, the following links provide sufficient documentation:
PostgreSQL is a very good database, but there's no question that Oracle is a far more advanced database. Oracle generally has higher performance, and it has a lot of functionality for which there is no equivalent in PostgreSQL. Clustering, for example, is not so easy with PostgreSQL, and that's just a relatively trivial example. Change data capture is another thing that's much easier with Oracle (using LogMiner or Streams). And so on.
Both are widely used.
Having said that, for many purposes, perhaps even most, PostgreSQL is more than sufficient, and the price is unbeatable.
Open source relational database management system (RDBMS)
Different applications use MySQL: Joomla, word press etc...
MySQL is also used in many high-profile, large-scale World Wide Web products, including, Wikipedia, Google, Facebook, Twitter, Flickr, Nokia.com, YouTube
well, u need to think about all w.r.t ACID. Its a good research Topic. As each contains its own advantages and drawbacks. u cant say this one is best and this one not.... Now adays trend is going to be shifted toward NoSQL(that was functional 30 years ago). So concluding remarks...... NoSQL is going to replace in near future...
I would be interested in knowing, from the respondents who have made the comment, by what is meant by "the best". I've used all the RDBMSs in the market for a myriad of production systems and I fail to see how Oracle is "the best", unless you want a RDBMS that has probably the highest ROI cost of any of them.
Also, if you search comp.databases for example, there is always someone who asks which is better, Oracle and Informix. 100% of the people who answer this (and have exposure to both) will tell you Informix is a better database, and from a person who has spent considerable time with both, I totally concur.
Like all software, some do things better than others. Databases are no different, and perhaps instead of just "using" Oracle (or any other database here), you should first find out what it is you want to do and what package better supports your requirements.
Under "the best", most of the people understand scalability, reliability, speed and the power of the SQL dialect (PL/SQL).
Oracle, MS Access :) , Informics, Interbase, MS SQL Server, Sybase, Adabase, DBase, Clipper, FoxPro, MySQL, PostgreSQL, etc. Every one of these have their own pros and cons.
In my opinion (as you can see, other people share it), Oralce offers greatest scalability - from small home projects to "Big Data" projects.
If you implement all reliability measures, you will got "unbreakable" database (powered by Oracle Unbreakable Linux).
On proper hardware Oracle offers top 2/3/5/10/100/500 speed (transactions/sec., I/O/sec., recovery time, etc.).
PL/SQL offers manipulation of millions of rows in real or near real time speed.
There are a few F1 databases, compared to long row of "different than F1".
Given your answer, it's obvious to me that you have considerable experience in the Oracle world. However, as I stated originally, would you have the same opinion if you had exposure in a production environment utilizing other RDBMSs? Most people don't, especially those whose life revolves around Oracle.
And, for what it's worth, if you dig deeper, companies like FedEx, UPS, Chase Credit Worldwide and Hilton Worldwide reservations don't use Oracle. So, is that to say that they are ignorant? Or, is it possible that they looked at the ROI and what the RDBMS of choice had to offer and was able to provide for their particular needs?
If a person in the middle of the jungle only sees a Fiat, they might think it's great, until they see a Mercedes. Same logic applies here.
The question is "Which is the most powerful database system postgresql or oracle?".
If every one of these databases are installed on developers recommended hardware, Oracle will win every kind of power related competition.
If we start to add additional variables to the equation, may be other database will win.
As example, if we compare acquisition price and in addition the price of recommended hardware, Postgre will win. The same is for other comparison parameters.
In my opinion, the simple answer to the simple primary question is - Oracle.
And on Joe's question about FedEx...
Large companies are very conservative about changes in information systems that they use and may be this is the answer on the question "Why they use this or that database?".
"If we start to add additional variables to the equation, maybe other database will win".
Translation: some other database CAN be better than oracle. It's up to a company to decide what their requirements are, THEN optimally select the database system they need in order to provide the best overall service.
Large companies might not be conservative. It might be that they used my logic above and realized that Oracle is not the panacea that everyone thinks it is. It's like the old adage: nobody ever got fired for buying IBM. In the database world, that's Oracle.
Oracle has large plat-form facilitate different tools to integrate Database, where we can develop Internet Applications via FORM BUILDER, report applications via REPORT BUILDER, and PLSQL. Moreover, Oracle supports full security for Database as compare to PostgreSQL.
Very simple example to compare both Databases tools in my experience that in PostgreSQL you can easily get/view the data in PGAdmin and also transfer the data to another machine but in Oracle we can not see the actual place of data and also can not move the data (need to create dump files or use to export/import utility).
In my point of view, if we are going to plan for big system such as ERP where we may need all other tools for supporting our application system then ORACLE is best option as compare to PostgreSQL.
* I have worked on Oracle9i more than 3 Years, and also my recent work on PostgreSQL since six months.