[tryton] use oracle or sqlserver as a database for tryton

[ajohniba]

good afternoon

My name is Akers Ibañez, I'm from Barranquilla, Colombia

I want to know if I can use tryton with oracle or sqlserver databases, what changes are needed to use these databases.

Thanks for the collaboration

[Cédric Krier]

Post by ajohniba
I want to know if I can use tryton with oracle or sqlserver databases,
what changes are needed to use these databases.

Tryton is developed with database abstraction layer by using python-sql
which follows SQL standard.
So theoretically, if the database respects the SQL standard there should
be no difficulties to create a backend.
At B2CK, we have made a prototype for Oracle few years ago:
http://hg.b2ck.com/trytond_backend_oracle/
But it was for 3.7 development series and we do not maintain it because
we had no incentive.

Indeed there are not real incentive to support backend for proprietary
databases when we have already PostgreSQL which is as good as the others
(and even better on some points). Also it is quite difficult to ensure
continuous integration testing without proper licenses (which has a
cost).

[a***@mazurkiewicz.org]

Post by ajohniba
good afternoon
My name is Akers Ibañez, I'm from Barranquilla, Colombia
I want to know if I can use tryton with oracle or sqlserver databases, what changes are needed to use these databases.
Thanks for the collaboration

I have a friend - lawyer. Here in Poland he has taken part in several court cases between his clients and Oracle.

Oracle is no more typical technological company. They have moved towards very complicated licences and try to sue customers for not complying them.

If you are looking for troubles go to Oracle.

My personal advice - move to postgres. It is a mature database with a lot of interesting features, icluding, I think, mature replication.
It offers many languages for stored procedures.
It offers foreign data wrappers for direct access of other databases (https://wiki.postgresql.org/wiki/Foreign_data_wrappers).
Excelent for integration of information from many different databases.
Excelent for development.

My love for more than 20 years now :) :) :)

Regards
Andrzej Mazurkiewicz