Does Platform Use Special Features Of Each DBMS That Support

This forum is for the exchange of ideas and suggestions regarding the 1C:Developer Network

People who like this:0Yes/0No
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.


1C:Enterprise Platform supports PostgreSQL, MS SQL Server, IBM DB2 and Oracle DBMS. Each DBMS support special features for working with it (like support of CAP Theorem - Consistency, Availability, Partition Tolerance, like many features of each DBMS).

Does Platform Use Each Special Features In DBMS?

If yes, can anyone give some exaples? Or any documentation(s) that explain Platform's working principles with PostgreSQL, MS SQL Server, IBM DB2 and Oracle? Of course it expected to be noted in documentation the releases of DBMS.

People who like this:0Yes/0No
Timofey Bugaevsky


You should understand that 1C supports several DBMS at a time, that is why not 100% of capabilities are utilized. But ones that are required for platform needs are utilized.
At the same time one DBMS provides one set of capabilities and another provides different set. If some functionality is required for the platform but DBMS does not support it - this functionality will be emulated.

To understand the platform operation with specific DBMS one should use a debugger to see which queries are generated instead of ones that you write for 1C:Enterprise platform.

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.