Creating a Read-only Instance

[Roosteridk]

Is there a way to open a read-only connection to a database similar to the Python client?

[jraymakers]

Yes, you can use the configuration option access_mode, set to READ_ONLY.

See https://duckdb.org/docs/stable/configuration/overview.html#global-configuration-options

Example:

import { DuckDBInstance } from '@duckdb/node-api';
const instance = await DuckDBInstance.create('my_existing.db', { access_mode: 'READ_ONLY' });
const connection = await instance.connect();