NAME

DBIO::SQLite::Introspect - Introspect a SQLite database via sqlite_master and PRAGMAs

VERSION

version 0.900000

DESCRIPTION

DBIO::SQLite::Introspect reads the live state of a SQLite database via sqlite_master and the relevant PRAGMA statements and returns a unified model hashref. It is the source side of the test-deploy-and- compare strategy used by DBIO::SQLite::Deploy.

my $intro = DBIO::SQLite::Introspect->new(dbh => $dbh);
my $model = $intro->model;
# $model->{tables}, $model->{columns}, $model->{indexes}, $model->{foreign_keys}

The model shape mirrors DBIO::PostgreSQL::Introspect so the same diff/deploy patterns apply, but only covers what SQLite actually has (no schemas, types, functions, RLS).

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.