Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: About MySQL support

by
zahid
- 02/09/2016 06:38:10
+1 @Graeme


Odoo Integrator,
Data integration
BI and IT consulting.

j.zahid@auriumtechnologies.com
tél  0661360233 - 0636898882
fax 0528215738

On Tue, Feb 9, 2016 at 10:34 AM, Graeme Gellatly <gdgellatly@gmail.com> wrote:

It's not whether the database driver adheres to the pep standard, most do, it's whether or not the sql works. How would mysql for example interpret a postgres materialized view or even boolean datatype for that matter which aren't part of the sql standard.

What about un accenting searches, again not part of the standard. Maybe the syntax is identical, I don't know. 

Personally I think mysql support would be good only because it potentially expands the community. There is no technical benefits only added costs, and slower development.


On Tue, 9 Feb 2016 10:42 PM Luca Vercelli <luca.vercelli.to@gmail.com> wrote:

Thank you all for your opinions.
The scenario I have in mind is the following: a company has "its own datacenter" (tipically SQL server), with good technicians and good backups already configured, and they don't want even ear about saving data into a different database.

Personally, I did't imagine that this modification were such a big effort. I thought that it were possible, for example, let Odoo to communicate to postgresql through an intermediate level, a "common driver interface" [1].
At that point, it would be easy (?!) to change the underlying storage, just changing driver.

Anyway, before developing anything, I will first look at other solutions, such as Tryton and ERPnext.

Thank you.

[1] https://wiki.python.org/moin/DatabaseInterfaces


Il 09/02/2016 10:23, Dave Ellison ha scritto:

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


_______________________________________________
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