DuckDB Plugin for Xojo

EinhugurDuckDB.Connection Class (console safe)

Connection object representing DuckDB database connection. A database object can have zero to many connections.

Object
   Connection

class EinhugurDuckDB.Connection

Constructors

ConnectionPrivate constructor.

Properties

ErrorReturns true if error occurred, else false.
ErrorMessageReturns descriptive message for last error.

Methods

BeginTransactionBegins a new transaction.
CommitCommits current transaction.
CreateAppenderCreates appender object for a given table.
PrepareCreates prepared statement object taking in sql string.
RollbackRolls current transaction back.
SQLExecuteExecutes SQL query without returning result.
SQLSelectExecutes SQL query, returning the result as EinhugurDuckDB.Recordset or nil.

Examples

With the DuckDB instance, you can create one or many Connection instances using the Connect method on the Database object. While connections should be thread-safe, they will be locked during querying. It is therefore recommended that each thread uses its own connection if you are in a multithreaded environment.

Supported Platforms:

  • macOS Intel 32 bit
  • macOS Intel 64 bit
  • macOS Apple Silicon
  • Windows 32 bit
  • Windows 64 bit
  • Windows ARM 64 bit
  • Linux 32 bit
  • Linux 64 bit
  • Linux ARM 32 bit