@type t() :: %Duckdbex.Config{
  abort_on_wal_failure: boolean(),
  access_mode: :automatic | :read_only | :read_write,
  allocator_background_threads: boolean(),
  allocator_bulk_deallocation_flush_threshold: pos_integer() | nil,
  allocator_flush_threshold: pos_integer() | nil,
  allow_community_extensions: boolean(),
  allow_unredacted_secrets: boolean(),
  allow_unsigned_extensions: boolean(),
  allowed_directories: [binary()] | nil,
  allowed_paths: [binary()] | nil,
  autoinstall_extension_repo: binary() | nil,
  autoinstall_known_extensions: boolean(),
  autoload_known_extensions: boolean(),
  buffer_manager_track_eviction_timestamps: boolean(),
  checkpoint_on_shutdown: boolean(),
  checkpoint_wal_size: pos_integer() | nil,
  custom_extension_repo: binary() | nil,
  custom_user_agent: binary() | nil,
  database_path: binary() | nil,
  database_type: binary() | nil,
  default_block_alloc_size: pos_integer() | nil,
  default_block_header_size: pos_integer() | nil,
  disable_database_invalidation: boolean(),
  disabled_compression_methods: [compressionType()] | [] | nil,
  disabled_optimizers: [optimizer_type()] | [] | nil,
  duckdb_api: binary() | nil,
  enable_external_access: boolean(),
  extension_directory: binary() | nil,
  external_threads: pos_integer(),
  force_bitpacking_mode:
    :auto | :constant | :constant_delta | :delta_for | :for,
  force_checkpoint: boolean(),
  force_compression: compressionType() | nil,
  http_metadata_cache_enable: boolean(),
  http_proxy: binary() | nil,
  http_proxy_password: binary() | nil,
  http_proxy_username: binary() | nil,
  initialize_default_database: boolean(),
  load_extensions: boolean(),
  lock_configuration: boolean(),
  maximum_memory: pos_integer() | nil,
  maximum_swap_space: pos_integer() | nil,
  maximum_threads: pos_integer() | nil,
  memory_allocator: :duckdb | :erlang,
  serialization_compatibility: binary() | nil,
  temp_file_encryption: boolean(),
  temporary_directory: binary() | nil,
  trim_free_blocks: boolean(),
  unrecognized_options: [{binary(), any()}] | nil,
  use_direct_io: boolean(),
  use_temporary_directory: boolean(),
  user_options: [{binary(), any()}] | nil,
  zstd_min_string_length: pos_integer() | nil
}

DuckDB database instance configuration type.

:database_path: Database file path. May be empty for in-memory mode. Default: nil.

:database_type: Database type. If empty, automatically extracted from database_path, where a type:path syntax is expected. Default: nil.

:access_mode: Access mode of the database. Maybe :automatic, :read_only or :read_write. Default: :automatic.

:checkpoint_wal_size: Checkpoint when WAL reaches this size. Default: nil (16777216 ~16MB). In bytes.

:use_direct_io: Whether or not to use Direct IO, bypassing operating system buffers. Default: false.

:load_extensions: Whether extensions should be loaded on start-up. Default: true.

:autoload_known_extensions: Whether known extensions are allowed to be automatically loaded when a query depends on them. Default: true.

:autoinstall_known_extensions: Whether known extensions are allowed to be automatically installed when a query depends on them. , Default: true.

:custom_extension_repo: Override for the default extension repository. Default: nil.

:autoinstall_extension_repo: Override for the default autoload extension repository. Default: nil.

:maximum_memory: The maximum memory used by the database system (in bytes). Default: nil (80% of System available memory)

:maximum_swap_space: The maximum size of the temp_directory folder when set (in bytes). Default: nil (90% of available disk space).

:maximum_threads: The maximum amount of native CPU threads used by the database system. Default: nil (all available).

:external_threads: The number of external threads that work on DuckDB tasks. Must be smaller or equal to maximum_threads. Default: 1.

:use_temporary_directory: Whether or not to create and use a temporary directory to store intermediates that do not fit in memory. Default: true

:temporary_directory: Directory to store temporary structures that do not fit in memory. Default: nil (current)

:trim_free_blocks: Whether or not to invoke filesystem trim on free blocks after checkpoint. This will reclaim space for sparse files, on platforms that support it. Default: false

:buffer_manager_track_eviction_timestamps: Record timestamps of buffer manager unpin() events. Usable by custom eviction policies. Default false.

:allow_unredacted_secrets: Whether or not to allow printing unredacted secrets. Default: false.

:disable_database_invalidation: Disables invalidating the database instance when encountering a fatal error. Default: false.

:enable_external_access: Enable COPY and related commands. Default: true.

:http_metadata_cache_enable: Whether or not the global http metadata cache is used. Default: false.

:http_proxy: HTTP Proxy config as hostname:port. Default: nil.

:http_proxy_username: HTTP Proxy username for basic auth. Default: nil.

:http_proxy_password: HTTP Proxy password for basic auth. Default: nil.

:force_checkpoint: Force checkpoint when CHECKPOINT is called or on shutdown, even if no changes have been made. Default: false.

:checkpoint_on_shutdown: Run a checkpoint on successful shutdown and delete the WAL, to leave only a single database file behind. Default: true.

:serialization_compatibility: Serialize the metadata on checkpoint with compatibility for a given DuckDB version. Default: nil (latest version of DuckDB).

:initialize_default_database: Initialize the database with the standard set of DuckDB functions. You should probably not touch this unless you know what you are doing. Default: true.

:disabled_optimizers: The set(elixir list) of disabled optimizers. Default: nil.

:zstd_min_string_length: The average string length required to use ZSTD compression. Default: 4096.

:force_compression: Force a specific compression method to be used when checkpointing (if available). Maybe :auto, :uncompressed, :constant, :rle, :dictionary, :pfor_delta, :bitpacking, :fsst, :chimp, :patas. Default: :auto.

:disabled_compression_methods: The set of disabled compression methods. Default nil.

:force_bitpacking_mode: Force a specific bitpacking mode to be used when using the bitpacking compression method. Maybe :auto, :constant, :constant_delta, :delta_for, :for. Default: :auto.

:extension_directory: Directory to store extension binaries in. Default: nil.

:allow_unsigned_extensions: Whether unsigned extensions should be loaded. Default: false.

:allow_community_extensions: Whether community extensions should be loaded. Default: true.

:user_options: Default: The set of user-provided options. nil.

:unrecognized_options: The set of unrecognized (other) options. Default: nil.

:lock_configuration: Whether or not the configuration settings can be altered. Default: false.

:allocator_flush_threshold: The peak allocation threshold at which to flush the allocator after completing a task (1 << 27, ~128MB). In bytes. Default: nil (134217728 bytes);

:allocator_bulk_deallocation_flush_threshold: If bulk deallocation larger than this occurs, flush outstanding allocations (1 << 30, ~1GB). Default: nil (536870912 in bytes)

:allocator_background_threads: Whether the allocator background thread is enabled. Default: false.

:duckdb_api: DuckDB API surface. Default: nil.

:custom_user_agent: Metadata from DuckDB callers. Default: nil.

:temp_file_encryption: Encrypt the temp files. Default: false.

:default_block_alloc_size: The default block allocation size for new duckdb database files (new as-in, they do not yet exist). In bytes. Default: nil (DUCKDB_BLOCK_ALLOC_SIZE = 262144 ULL)

:default_block_header_size: The default block header size for new duckdb database files.. In bytes. Default: nil (DUCKDB_BLOCK_HEADER_STORAGE_SIZE = 8ULL ULL)

:abort_on_wal_failure: Whether or not to abort if a serialization exception is thrown during WAL playback (when reading truncated WAL). Default: false.

:allowed_paths: Paths that are explicitly allowed, even if enable_external_access is false. Default: nil.

:allowed_directories: Directories that are explicitly allowed, even if enable_external_access is false. Default: nil.

:memory_allocator: The memory allocator used by the database system. Maybe :duckdb - native DuckDB allocator or :erlang - erlang void *enif_alloc(size_t size) allocator. Default: :duckdb.