---
name: "Jifty::DBI::Handle::SQLite"
section: "3pm"
platform: "linux"
package: "libjifty-dbi-perl"
version: "0.78-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Jifty::DBI::Handle::SQLite"
---

# Jifty::DBI::Handle::SQLite(3pm)

## NAME

```
  Jifty::DBI::Handle::SQLite -- A SQLite specific Handle object
```

## SYNOPSIS

## DESCRIPTION

This module provides a subclass of Jifty::DBI::Handle that  compensates for some of the idiosyncrasies of SQLite.

## METHODS

### database\_version

Returns the version of the SQLite library which is used, e.g., "2.8.0". SQLite can only return short variant.

### insert

Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.

### case\_sensitive

Returns 1, since SQLite's searches are case sensitive by default. Note, however, SQLite's `"like"` operator is case *in*sensitive.

### distinct\_count STATEMENTREF

takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result count

### rename\_column ( table =\> $table, column =\> $old\_column, to =\> $new\_column )

rename column

## AUTHOR

Jesse Vincent, jesse@fsck.com

## SEE ALSO

[**perl**(1)](/perl/1.md), Jifty::DBI