Technical mailing list archives

Re: About MySQL support

Open For Small Business Ltd, Graeme Gellatly
- 02/08/2016 16:30:05
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 <> 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


Am 08.02.2016 um 13:41 schrieb Leonardo Pistone <>:


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
<> wrote:
> I already opened this discussion on github,
> 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: > Post to: > Unsubscribe:

Post to:

Post to: