Community mailing list archives

community@mail.odoo.com

Re: Using Mysql as database system manager instead of postgresql for Odoo

by
Andi Becker
- 01/04/2016 23:50:05
Yep Dominique that is true, as Postgres was the base of all same as Odoo and MySQL etc came much later. 

Unfortunately many customers who ask for and ERP are with hosters which still don't provide Postgres and MySQL is available everywhere. Additionally Postgres seems for many like a big black box while MySQL is very well documented and understandable and it has PHPmyAdmin which is far ahead of any tool managing postgres DBs.

For customers looking for an ERP System which rund on MySQL I really recommend using ERPNext - it actually is using MariaDB. You can simply try it with their virtual box https://erpnext.com/download
and than compare it with the Odoo solution.

Even better is to create a 30 day account for both and than compare them:

ERPNext has a very good tutorial in how to setup your business step by step and when you finished all steps you are fully set to start business.


This is also a good guideline if you setup a business in Odoo by the way!
But don't wonder if you have to look at many many different places in Odoo to get the same simply setup running like in ERPNext.

ERPNext has a very intuitive approach in comparison to Odoo. It might be that Odoo already exists since long long time and as time went by many new modules and features came, while in ERPNext it is actually pretty new system and the approach of them seemed to have a very close look to tinyerp and OpenERP as well es sugarcrm or vtiger before they even started to setup up a system as a whole system and not only as a connection of many parts.

So I think ERPNext took lots of ideas from its main competitor ODOO and enhanced them with focus on usability and easiness for regular users, This is IMHO also the reason why its code base is much much cleaner than the one of Odoo and therefore it is also much faster.

On the other Hand I think meanwhile ODOO sees this competition and now many features and usability facts which have been brought to ERPNext get now copied back to Odoo. 

Website Builder or the Mobile friendly Material Design etc are only some of the examples.

Concerning the Website Builder ERPNext is now behind Odoo due to the fact that Odoo has really tired to get frontend editing including everywhere, which is a huge plus for regular users.

Like said before simply try it your self.

Create an Account here: https://erpnext.com
an another one here: https://www.odoo.com

Follow the"frappe" tutorial step by step.
or try to find a simple to understand tutorial (one red line to follow) which will guide you through all those simply necessary steps for each company in Odoo.
Even your letter head looks great.

Take time on how long it took to get everything up and running.
Next start working with both for a week to compare the effort you need to get used to it.
You will quite fast realise what a huge difference it is in terms of usability.

At the end of your tests compare the time you needed to learn and invest each system.
Compare the TCO, especially what additional costs have been involved or would be needed for each system to fit your needs.
Finally think about that the one who developed the system will do a license change - or another license change - or will try to force you to buy enterprise features by making those hard to achieve in the community editions. 

I guess in all above points you will prefer choosing ERPNext.

Unfortunately if you now have multilingual customers, with Languages which are not fully ported to ERPNext you also will see the effort a developing company would need to take to get things done. In that point (it is more or less the only one) ERPNext will really loose ground. The advertised 30 Languages are actually only 5 Languages which have been really translated so the system would be usable in that language. In Odoo you will have much more languages available which are supported much better.

If you are looking for an intergrated solution with POS they are even, while the ERPNxt is really mobile friendly from start. Actually the complete system is build to be used on mobiles. Here Odoo even in Enterprise lacks behind and Community Edition is far behind mobile-usability! Even the material design advertised here on the list is not at all mobile friendly, unfortunately not using all the great stuff material designs brings with it.


It is ggod that both systems influence each other and I hope more and more usability parts will be found also in ODOO Community in future

Andi






With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
Cordialement,
с сердечным приветом,
เรื่องที่เกี่ยวกับชนิด,
與親切的問候,

 ANDI BECKER

CEO/General Manager LisAndi Co., Ltd.

--------------------------------------------------

LisAndi Co. Ltd., Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

Mobile: +66 (0)81 606 3378
VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk/Facetime/eMail:  andi@lisandi.com

--------------------------------------------------

This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Tue, Jan 5, 2016 at 6:17 AM, Dominique Chabord <dominique.chabord@sisalp.org> wrote:
Hello,

a short word about Tryton because it has been cited twice in this discussion, and almost recommanded regarding mysql compatibility :

- The fact is that Tryton is architectured to support different database engines.
- Supporting mysql as well proves this design.
- It has been useful to implement SQLite and Oracle solutions
- I don't see mysql/mariadb as the preferred database engine for Tryton. Mysql appeared to be deceptive.
- Compatibility doesn't mean engines are equal. Tryton + Postgresql is optimal and Tryton makes use of its advanced features.

If you are driven by mysql compatibility, Tryton is probably not first choice, or, as  a mysql specialist, you can endorse and improve this part of the project.
#my2cts


2016-01-04 21:28 GMT+01:00 Yassine Teimi <yteimi01@gmail.com>:
Thanks a lot Andreas for these valuable informations. 

Kind Regards.

2016-01-04 17:28 GMT+00:00 Andreas Becker <andi@lisandi.com>:
Have a look here:


If you are looking for a erp system which is running on MySQL or MariaDB and is still python than have a look to erpnext. 
It is much faster than Odoo, much easier to handle, but depending on the features you need and the country you need it for it might be a lot of work to do to get it localised for your needs.

this can cause you a lot of work if you are not in Germany Finnland or any other country which has most of it already translated!

Enterprise Feutres and Mobile Friendly are included in erpnext - no enterprise or proprietary version and the code base is much much cleaner!

And best of all ist actually that ERPNext is GPL v.3 100% Free Open Source Software and people are contributing always in GPL v.3 again! No headaches with unpredictable license changes.

Tutorial Documentation and Videos are great.

By the way I guess the Material Design idea for Odoo is actually coming from erpNext as it is really mobile friendly

---

You could also have a look at Tryton as it also runs on MySQL or MariaDB and it is using already Python 3 and is also GNU GPL v. 3 withot any fear that more and more stuff gets to be proprietary.

ERPNext names Odoo at place number 1 as an alternative to ERPNext and they also explain there point of view so it is up to you what you want to use.


Andi




With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
Cordialement,
с сердечным приветом,
เรื่องที่เกี่ยวกับชนิด,
與親切的問候,

 ANDI BECKER

CEO/General Manager LisAndi Co., Ltd.

--------------------------------------------------

LisAndi Co. Ltd., Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk/Facetime/eMail:  andi@lisandi.com

--------------------------------------------------

This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Mon, Jan 4, 2016 at 9:01 PM, Gustavo Orrillo <gustavo.orrillo@moldeointeractive.com.ar> wrote:
I think so... check the year in the post... 2009...
Actually Tryton supports MySQL (to the best of my knowledge)

Thing is... if you  are implementiing an ERP the database is the least of your concerns. In many places Odoo runs without the help of a DBA

On Mon, Jan 4, 2016 at 10:41 AM, Dave Ellison <dave.e@time-tele.com> wrote:
Hi,

That's version 5???

Thanks

On 04/01/16 12:24, Yassine Teimi wrote:
<blockquote cite="mid:CAJn9K88Svgb0U1WEf7hgkuJqANAC7vKwowMweGOtn14-=SXMCw@mail.gmail.com" type="cite">
Thanks for your answers, 

So it's not possible to use Mysql instead of Postgresql, but why there is a tutorial showing how it can be done : http://openerp-team.blogspot.de/2009/08/open-erp-server-with-mysql.html  ?

2016-01-04 12:07 GMT+00:00 Mustafa Sarkazi <sarkazimustafa@gmail.com>:
You cannot use MySQL.

--

Best Regards,

Mustafa Sarkazi
Technology Consultant

On Fri, Jan 1, 2016 at 8:29 AM, Adrian Merrall <adrianmerrall@gmail.com> wrote:
Odoo have (wisely IMHO) decided to focus solely on Postgresql rather than using the ORM layer to provide database portability such as you would usually get with Spring or Hibernate.

If you are currently a MySQL only shop, there are loads of tutorials etc. around and I can also recommend some of the commercial web based training that EnterpriseDB offer for PG.

If you are thinking of cloud, there are various PG cloud providers and I believe that adding PG to the databases for Google Cloud is one of the most requested features.

Cheers,

Adrian




On 1 January 2016 at 14:13, Graeme Gellatly <gdgellatly@gmail.com> wrote:

No.

Mainly because you can't.


On Fri, 1 Jan 2016 11:44 AM Yassine Teimi <yteimi01@gmail.com> wrote:
Dears, 

Is there any precise tutorial, demonstrating how to use mysql instead of postgres ? 

What are in your opinion the advantages to use it ?

Thanks.

--

Cordialement

Yassine TEIMI

Consultant & Odoo Project Manager
TEL : +212 6-87 71 41 18

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

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


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


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




--

Cordialement

Yassine TEIMI

Consultant & Odoo Project Manager
TEL : +212 6-87 71 41 18

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


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


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


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




--

Cordialement

Yassine TEIMI

Consultant & Odoo Project Manager
TEL : +212 6-87 71 41 18

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


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