---
name: "Class::DBI::SQLite"
section: "3pm"
platform: "linux"
package: "libclass-dbi-sqlite-perl"
version: "0.11-6"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Class::DBI::SQLite"
---

# Class::DBI::SQLite(3pm)

Extension to Class::DBI for sqlite

## NAME

Class::DBI::SQLite - Extension to Class::DBI for sqlite

## SYNOPSIS

```
  package Film;
  use base qw(Class::DBI::SQLite);
  __PACKAGE__->set_db('Main', 'dbi:SQLite:dbname=dbfile', '', '');
  __PACKAGE__->set_up_table('Movies');
  package main;
  my $film = Film->create({
     name  => 'Bad Taste',
     title => 'Peter Jackson',
  });
  my $id = $film->id;           # auto-incremented
```

## DESCRIPTION

Class::DBI::SQLite is an extension to Class::DBI for DBD::SQLite. It allows you to populate an auto-incremented row id after insert.

The `"set_up_table"` method automates the setup of columns and primary key(s) via the SQLite PRAGMA statement.

## AUTHOR

Tatsuhiko Miyagawa \<miyagawa@bulknews.net\>

`"set_up_table"` implementation by Tomohiro Ikebe \<ikebe@cpan.org\>

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

## SEE ALSO

Class::DBI, DBD::SQLite