Community mailing list archives
Re: Using Mysql as database system manager instead of postgresql for Odooby
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
On Tue, Jan 5, 2016 at 6:17 AM, Dominique Chabord <email@example.com> wrote:
- It has been useful to implement SQLite and Oracle solutions- The fact is that Tryton is architectured to support different database engines.Hello,a short word about Tryton because it has been cited twice in this discussion, and almost recommanded regarding mysql compatibility :
- Supporting mysql as well proves this design.
- 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.#my2cts2016-01-04 21:28 GMT+01:00 Yassine Teimi <firstname.lastname@example.org>:Thanks a lot Andreas for these valuable informations.Kind Regards.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.AndiI 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 DBAHi,<blockquote cite="mid:CAJn9K88Svgb0U1WEf7hgkuJqANAC7vKwowMweGOtn14-=SXMCw@mail.gmail.com" type="cite">
That's version 5???
On 04/01/16 12:24, Yassine Teimi wrote:
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 <email@example.com>:
You cannot use MySQL.
Mustafa SarkaziTechnology Consultant
On Fri, Jan 1, 2016 at 8:29 AM, Adrian Merrall <firstname.lastname@example.org> 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.
On 1 January 2016 at 14:13, Graeme Gellatly <email@example.com> wrote:
Mainly because you can't.
On Fri, 1 Jan 2016 11:44 AM Yassine Teimi <firstname.lastname@example.org> wrote:
Is there any precise tutorial, demonstrating how to use mysql instead of postgres ?
What are in your opinion the advantages to use it ?
Consultant & Odoo Project ManagerTEL : +212 6-87 71 41 18
Consultant & Odoo Project ManagerTEL : +212 6-87 71 41 18
--CordialementYassine TEIMIConsultant & Odoo Project ManagerTEL : +212 6-87 71 41 18