view release on metacpan or  search on metacpan

lib/DBIO/DuckDB.pm  view on Meta::CPAN

=head1 METHODS

=head2 connection

Overrides L<DBIO/connection> to force C<+DBIO::DuckDB::Storage> as
C<storage_type>.

=head1 TESTING

Tests use in-memory DuckDB databases and do not require external
credentials. The C<t/> directory contains user-level smoke scripts
(not automated TAP tests) for manually verifying the driver end-to-end
against a real libduckdb install.

=head1 AUTHOR

DBIO Authors

=head1 COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors

share/skills/dbio-duckdb-database/SKILL.md  view on Meta::CPAN

FKs are **readable but NOT emitted** in install DDL. DuckDB validates the
referenced column tuple against the parent PK/unique *in the same column
order* at CREATE TABLE time; DBIO FK condition hashes are alphabetically
sorted and often mismatch. Since FKs have no runtime effect in 1.x, install
DDL skips them; introspect/diff can still round-trip user-added FKs.

## Testing Env Vars

`DBIO_TEST_DUCKDB_DSN`, `DBIO_TEST_DUCKDB_DBUSER`, `DBIO_TEST_DUCKDB_DBPASS`
(`DBIO::DuckDB::Test`). If `DBIO_TEST_DUCKDB_DSN` is unset, tests default to
`dbi:DuckDB:dbname=:memory:` with no external credentials.