Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

4

Why Postgresql database using in OpenERP?

By
Remya
on 7/12/13, 10:00 AM 4,696 views

why we use postgresql in openerp? What are the benefits of using postgresql?

1

Grover Menacho

--Grover Menacho--
2523
| 5 7 8
La Paz, Bolivia
--Grover Menacho--

Systems Engineer + MBA

Grover Menacho
On 7/12/13, 11:00 AM

It's because the size of the application. If you want to use large databases you have to use it. It supports rollbacks something that It's really useful with OpenERP. And the referential integrity, mysql has it with InnoDB but it's really problematic when you want to export it.

1
dave ellis
On 7/12/13, 10:48 AM

Hi,

There could be another 2 replies after this disagreeing with me. However, PostgreSQL is seen to be better when utilising "enterprise" applications. If you just want a quick dirty basic database driven website, MySQL would be much better.

Personally, if I want a full enterprise DBMS, I go PostgreSQL all the way. But if I want a small/basic application or website with a database backend, then I'd go MySQL. This is not based on volume of users or visitors, but mainly what you want from a DBMS. Or if I have a big website that's not needing extra DB features PostgreSQL need and just need a DB storage engine, then MySQL is the way to go.

I am sure some could argue MySQL could easily be used for OpenERP I'm sure.

Additionally, there is the whole Oracle owning MySQL issue, but that's less of an issue now with Maria DB (fork of MySQL).

I have added a link, again some are personal views. But it gives you an idea:

http://stackoverflow.com/questions/110927/would-you-recommend-postgresql-over-mysql

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 7/12/13, 10:00 AM
Seen: 4696 times
Last updated: 10/28/15, 6:14 AM