---
name: "DBIx::DBSchema::DBD::SQLite"
section: "3pm"
platform: "linux"
package: "libdbix-dbschema-perl"
version: "0.47-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/DBIx::DBSchema::DBD::SQLite"
---

# DBIx::DBSchema::DBD::SQLite(3pm)

SQLite native driver for DBIx::DBSchema

## NAME

DBIx::DBSchema::DBD::SQLite - SQLite native driver for DBIx::DBSchema

## SYNOPSIS

use DBI; use DBIx::DBSchema;

`$dbh` = DBI-\>connect('dbi:SQLite:tns\_service\_name', 'user','pass'); `$schema` = new\_native DBIx::DBSchema `$dbh`;

## DESCRIPTION

This module implements a SQLite-native driver for DBIx::DBSchema.

## AUTHORS

Jesse Vincent \<jesse@bestpractical.com\>

Nathan Anderson \<http://1id.com/=nathan.anderson\>

## API

- columns CLASS DBI\_DBH TABLE

  Given an active DBI database handle, return a listref of listrefs (see perllol), each containing six elements: column name, column type, nullability, column length, column default, and a field reserved for driver-specific use (which for sqlite is whether this col is a primary key)

- primary\_key CLASS DBI\_DBH TABLE

  Given an active DBI database handle, return the primary key for the specified table.

- unique CLASS DBI\_DBH TABLE

  Given an active DBI database handle, return a hashref of unique indices.  The keys of the hashref are index names, and the values are arrayrefs which point a list of column names for each.  See "HASHES OF LISTS" in perldsc and DBIx::DBSchema::ColGroup.

- index CLASS DBI\_DBH TABLE

  Given an active DBI database handle, return a hashref of (non-unique) indices. The keys of the hashref are index names, and the values are arrayrefs which point a list of column names for each.  See "HASHES OF LISTS" in perldsc and DBIx::DBSchema::ColGroup.