Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: About MySQL support

by
Dave Ellison
- 02/09/2016 04:17:12
Hi,

I highly doubt that Odoo SA will look at other databases. However yes as people have said, there are examples like the ORM in Django. In theory Odoo coud have an ORM, allowing people to choose the database they want. Personally working on something like this, is a waste of resources. I cannot see a reason to add in MySQL support to an already working stack. There are people who prefer one to another, but personally there is nothing wrong with PostgreSQL for this particular stack. Not to point of putting effort in to allow the use of other databases. I have yet to see one plausable reason for switching databases.

Dave

On 08/02/16 21:36, Graeme Gellatly wrote:
Tryton has MySQL support.  You could start by looking at how they do it.  Same with Django.  I think at one point v5 maybe there was also a working implementation based on SQLAlchemy, although probably best to use the same approach as Django/Tryton.

Personally I love postgres, having come from LAMP stacks, but I can see why people might want to use MySQL especially for throwaway dev and testing environments.  I doubt you'd get much support or encouragement from the existing community, who by definition are already using postgres. 

Both Mysql and postgres don't strictly follow the SQL standard so I imagine that there will be a few gotchas, although that is probably handled for the most part by the driver as python has a standard for it.  It probably isn't as hard to do as it looks.  Odoo expects transaction isolation by default, so it may be that a standard mysql install is no good, or it might just work and requires an ACID compliant one but idk, I've not looked at MySQL in years, maybe they made it robust by default now.

On Tue, Feb 9, 2016 at 1:57 AM, Wolfgang Pichler <wpichler@callino.at> wrote:

Hi all,


an other way to use „some“ foreign tables - is to use postgres foreign table support. I was able to include some tables from a mysql server in postgres - and did map them into modules. This way i was able to make crud operations native with Odoo on a mysql database

br,
Wolfgang

Am 08.02.2016 um 13:41 schrieb Leonardo Pistone <leonardo.pistone@camptocamp.com>:

Hi,

I share the opinion that to do that would be a really huge effort, and
in addition to that it would break hundreds of community modules in
subtle ways.

In the case someone has already MySQL infrastructure in place, I think
the effort to set up a postgresql server (even with default settings),
train the people, maybe pay someone to maintain them if needed would
be hugely cheaper and better than attempting a port.

On Mon, Feb 8, 2016 at 1:27 PM, Luca Vercelli
<luca.vercelli.to@gmail.com> wrote:
> I already opened this discussion on github,
> https://github.com/odoo/odoo/issues/10804
> and they suggested me to ask the mailing lists. I hope this is the right > mailing list. > > I would like to have more than 1 DB supported, say MySQL, SQL server, ... > I think this feature would allow Odoo to reach a larger public. > > So, what classes should I modify? > > Is somebody else interested in the project? > > Btw, I /don't/ think we need to modify all instances of "cr.execute()". > Probably we should just modify the cr.execute() method itself. > > Luca > > _______________________________________________ > Mailing-List: https://www.odoo.com/groups/community-framework-62 > Post to: mailto:expert-framework@mail.odoo.com > Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-framework-62
Post to: mailto:expert-framework@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-framework-62
Post to: mailto:expert-framework@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-framework-62
Post to: mailto:expert-framework@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe