Skip to content
Machbase DBMS Manual
11. Development and Application Integration

11. Development and Application Integration

Choose an integration method for your application, then review SDK installation, APIs, and shared operational principles. Use SDK pages for language-specific implementations and the selection, concepts, and support pages for guidance shared across SDKs.

Reading Order

  1. Choose an Integration Method for your language and input pattern.
  2. Review authentication, time values, binding, transactions, and retries in Common Integration Concepts.
  3. Compare actual support in SDK Feature Support.
  4. Follow the relevant SDK page for installation, connections, and executable code.
  5. Apply task-specific procedures in Data Ingestion and Export. For SQL ROWID semantics, see ROWID. For partial ARRAY input in Machbase DBMS 8.7.0, see Sparse ARRAY and Selected-Column Append API.

SDK References

EnvironmentDocumentation
Native C/C++ or ODBCMachbase SQLCLI and ODBC
Java/SpringJDBC
PythonPython
Node.js/TypeScriptNode.js / TypeScript
C#/VB.NET.NET Connector
Native Go/database/sqlGo

Common Connection Information

ItemDefaultDescription
HOST127.0.0.1Server host name or IP address
PORT5656Server port (PORT_NO in machbase.conf)
USERSYSUser ID
PASSWORDMANAGERUser password

Use a dedicated user with the minimum required privileges in production. See Accounts, Privileges, and Access Control for account and authentication settings.

Existing Support Links

See SDK Feature Support for NULL/PRIMARY KEY metadata, ROWID, Append, and AUTH KEY support by SDK.

Last updated on