Community mailing list archives

community@mail.odoo.com

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

by
Andi Becker
- 01/05/2016 06:29:28
:-)

You simply see it the way developers like to see it! It is very common unfortunately. Unfortunately customers usually are no developers and they host usually with one of those great hosting giants like 1 and 1 and similar one. Most of those giants try to avoid offering postgres. As a company you have now the chance to simply try to get the customer using Postgres by changing the hoster, mostly one he has been hosting since years without any problems etc. or the much easier way is to offer them an alternative. At the end the result for you will be enumeration and your effort will be much greater enumerated by that customer if you get things done right the way, fast and simply understandable and perfect.

So for customers who stick to MySQL we simply don't start a discussion about what DBMS should be used, we simply change the ERP ;-)

If a customer wants to have MySQL we usually check if the Hoster is offering also MariaDB (some already do that but not all) and than ERPNext is the first choice. MariaDB offers in its current version already encryption which no  other DBMS is doing right now. 


So this is no argument for a customer to say: Hey Customer why don't you wait until Postgres in its upcoming version 10 perhaps offers more security that MariaDB already does and than start with Odoo (perhaps it is meanwhile Version 10 or Eleven and you don't have to worry about the features as they are perhaps less than that ERPNext will offer to you in it Community Edition.)

We prefer to sell the customer instead a stable solution,
if it is 100% Free Open Source Software without Enterprise special costy features even better.
if there are no future license changes coming up, what has been the case with Odoo nearly every 2 years than even much much better.
Who cares at that point really about the DB's as MariaDB is great and Postgres is great - for us even easy. But the customer is actually the one giving the goal to reach and what he is willing to pay and how long he is willing to wait!

Usually you really do much better to simply sell them in the cases someone sticks to MySQL/MariaDB the most suitable system for that case, especially if he wants to have a 100% mobile friendly and really fast reacting ERP to. So there is not much other choice than simply using ERPNext. You will save a lot of time, a lot of discussion with the customers and the customer will have his ERPNext more or less in one week time.

For customers who are willing to invest much more money, for many features they perhaps not need in its standard set and who are willing to switch a hoster and have time to wait for future releases we still do ERP/websites in Odoo too. Both are Python, one with cleaner code and even able to be setup by noprogrammers, the other one with many more modules and where you really need a developer with experience to get through the setup.

Yes Postgres has documentation as MariaDB and MySQL has too but check out Literature which is accessible for customers and they will see mostly MySQL ;-). As a programmer you will love Postgres even it is getting slower with each version as it is easy like a blackbox you don't need to touch at all. but as a customer in a usual use case it still will be MySQL / MariaDB which will get the job finally!

As a company owner you like to get things done and earn money - so why waiting at all, when there is already a better, faster, reliable and well coded system available and it is 100% really Open Source without Enterprise features or commercial costy addons which might cause a vendor login in future releases.

Yes it hurts to hear that postgre is not well documented as if it would have been so well documented much more hosters would simply use and even prefer!
Yes there are features in Postgres Odoo is using and there are features in MariaDB ERPNext is suing to do actually the same job. Simply don't worry about what ERP you are selling to your customer if you can sell him an erp at all. And to be honest many NGO Organisations really have a Problem with the License Changes of Odoo in the past years and its tendency to close source more and more.

Instead of loosing those customers simply offer them ERPNext and I guarantee you that they will be more than happy with it! With all others try to improve ODOO Community Version so that they will stay at ODOO also in future releases. Also here ERPNext can be a great resource as the comparison of MaterialDesign Google and orientation on Apple Apps has shown. Those system s learn from each other, copy each other and you really do good to simply do the same for the benefit of your customers.

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 5:43 PM, Dave Ellison <dave.e@time-tele.com> wrote:
Hi,

Postgres is not documented to the point of being a "black box"? I came from years of loving MySQL, PHPmyAdmin and  the tools that came with it. In fact I lived in the LAMP stack for many of them. When I first touched upon Postgres, I felt it was such a "different beast" from MySQL. However, Postgres has great documentation and was fairly easy to learn. It almost reminds me of Oracle in some places, where it's features are more "enterprise". Point being, it's not a bad DBMS to learn and is very good at what it does. I feel people like to stick to the DBMS they have used and love, to some extent I can understand this.

Personally these days, I use the database engine that is right for the job. Postgres has many features MySQL doesn't (though I'd like to avoid a MySQL vs Postgres flame war), I believe 9.5 of Postgres coming soon will have record level security, amongst other features. Whether people like Odoo SA will utilise that functionality is up to them. But the features are perfect for ERP systems.

So for Odoo, I don't see why anyone would want MySQL. For Odoo SA, Postgres is the choice and I'm sure it can be hacked for MySQL, just don't see the point.

Thanks
Dave

On 05/01/16 04:53, Andreas Becker wrote:
<blockquote cite="mid:CAEJSRZvWvud8c6Qp=wfNG6O1&#43;wK3i_jb33qVrF7XyrgPNjnyUA@mail.gmail.com" type="cite">
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


_______________________________________________
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