From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

NAME

UR::DataSource::SQLite - base class for datasources using the SQLite3 RDBMS

SYNOPSIS

In the shell:

ur define datasource sqlite

Or write the singleton to represent the source directly:

class Acme::DataSource::MyDB1 {
is => 'UR::DataSource::SQLite',
has_constant => [
server => '/var/lib/acme-app/mydb1.sqlitedb'
]
};

You may also use a directory containing *.sqlite3 files. The primary database must be named main.sqlite3. All the other *.sqlite3 files are attached when the database is opened.

class Acme::DataSource::MyDB2 {
is => 'UR::DataSource::SQLite',
has_constant => [
server => '/path/to/directory/'
]
};