This plug-in collection provides a complete set of functionality to manage native connections and SQL statements to various Database servers, storage systems and intermediary libraries. The software design of all drivers is multi-platform and works fluently width AGE Database Connectivity (ADBC).
Currently the collection consists of the following native DB drivers:
Considerations for using Database drivers vs ADBC
Both technologies provide functionality for managing and executing SQL statements, and both can be used as SaaS solution onto the AGE infrastructure.
Nevertheless, these days the SQL standard is not strictly respected by the database providers and numerous dialects are currently in use. These dialects not only differs from the standard SQL statements but also provide a server specific functionality.
As a software developer, you should consider your engineering approach of when to use standard SQL statements vs DB server specific query statements or commands.
BINETIX® AGE™ gives you the full flexibility to choose or combine both techniques in one software solution. For example, to manage generic database tasks or to design standard GUI with DB controllers you should consider to use ADBC. However, quite often the maintenance tasks for particular database server require direct access with the native DB drivers provided by this collection.
Your software development depends also on what kind of configuration you use in order to setup one or multiple DB connections. The bad news is that each database controller has its own configuration requirements. However, width ADBC and AGE The Node functionality you could achieve some unification of these configurations.
