Odoo Help

4

Why Postgresql database using in OpenERP?

By
Remya
on 7/12/13, 10:00 AM 5,122 views

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

1

Grover Menacho

--Grover Menacho--
2543
| 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

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

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