生产系统中的ADBC和AMDP [英] ADBC and AMDP in Production systems

问题描述

在生产中建议使用ADBC或AMDP吗？
如果没有，为什么？谢谢您的提前评论！

解决方案

两者都是为生产目的而设计的。

您应该更喜欢OpenSQL，因为它简化了许多方面，例如客户端处理，并使编程变得容易，例如因为它可以整洁地读取类型化的结构和表。

<如果您的操作对于OpenSQL而言过于复杂，则AMDP应该是您的第二选择，例如，因为您需要执行一系列选择才能达到目标。请注意它们引发的异常，如果您使用特定于数据库的功能（例如SAP HANA的模糊搜索）。

如果无法达到目标，ADBC应该是您的最后选择达到上述两个目标的目的，例如因为您需要连接到另一个数据库或需要使用具有不同授权的辅助数据库连接。同样，请注意它们引发的异常。另外，要注意客户的处理，这种方式不是自动的。

Is it advisable to use ADBC or AMDP in Production? If not, why? Thank you for your comments in advance!

解决方案

Both are designed for production usage.

You should prefer OpenSQL because it simplifies many aspects, for example client handling, and makes programming easy, for example because it neatly reads into typed structures and tables.

AMDPs should be your second choice if what you are doing is too complex for OpenSQL, for example because you need to perform a sequence of selects to reach your aim. Pay attention to the exceptions they throw, and if you use database-specific features, such as SAP HANA's fuzzy search.

ADBC should be your last resort if you cannot reach your goals with the above two, for example because you need to connect to another database or need to use a secondary database connection with different authorizations. Again, pay attention to the exceptions they throw. Also, pay attention to the client handling, which in this way is not automated.

这篇关于生产系统中的ADBC和AMDP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！