/ 
DBD-SQLite-1.56
River stage four • 518 direct dependents • 1146 total dependents
⭐ Starred 28 GitHub stars
Security Advisories (15)
CVE-2020-13434 (2020-05-24)

SQLite through 3.32.0 has an integer overflow in sqlite3_str_vappendf in printf.c.

CVE-2020-11656 (2020-04-09)

In SQLite through 3.31.1, the ALTER TABLE implementation has a use-after-free, as demonstrated by an ORDER BY clause that belongs to a compound SELECT statement.

CVE-2020-9327 (2020-02-21)

In SQLite 3.31.1, isAuxiliaryVtabOperator allows attackers to trigger a NULL pointer dereference and segmentation fault because of generated column optimizations.

CVE-2018-20506 (2019-04-03)

SQLite before 3.25.3, when the FTS3 extension is enabled, encounters an integer overflow (and resultant buffer overflow) for FTS3 queries in a "merge" operation that occurs after crafted changes to FTS3 shadow tables, allowing remote attackers to execute arbitrary code by leveraging the ability to run arbitrary SQL statements (such as in certain WebSQL use cases). This is a different vulnerability than CVE-2018-20346.

CVE-2020-13630 (2020-05-27)

ext/fts3/fts3.c in SQLite before 3.32.0 has a use-after-free in fts3EvalNextRow, related to the snippet feature.

CVE-2019-8457 (2019-05-30)

SQLite3 from 3.6.0 to and including 3.27.2 is vulnerable to heap out-of-bound read in the rtreenode() function when handling invalid rtree tables.

CVE-2020-15358 (2020-06-27)

In SQLite before 3.32.3, select.c mishandles query-flattener optimization, leading to a multiSelectOrderBy heap overflow because of misuse of transitive properties for constant propagation.

CVE-2020-13632 (2020-05-27)

ext/fts3/fts3_snippet.c in SQLite before 3.32.0 has a NULL pointer dereference via a crafted matchinfo() query.

CVE-2020-13631 (2020-05-27)

SQLite before 3.32.0 allows a virtual table to be renamed to the name of one of its shadow tables, related to alter.c and build.c.

CVE-2020-13435 (2020-05-24)

SQLite through 3.32.0 has a segmentation fault in sqlite3ExprCodeTarget in expr.c.

CVE-2020-11655 (2020-04-09)

SQLite through 3.31.1 allows attackers to cause a denial of service (segmentation fault) via a malformed window-function query because the AggInfo object's initialization is mishandled.

CVE-2019-19646 (2019-12-09)

pragma.c in SQLite through 3.30.1 mishandles NOT NULL in an integrity_check PRAGMA command in certain cases of generated columns.

CVE-2019-19645 (2019-12-09)

alter.c in SQLite through 3.30.1 allows attackers to trigger infinite recursion via certain types of self-referential views in conjunction with ALTER TABLE statements.

CVE-2018-20346 (2018-12-21)

SQLite before 3.25.3, when the FTS3 extension is enabled, encounters an integer overflow (and resultant buffer overflow) for FTS3 queries that occur after crafted changes to FTS3 shadow tables, allowing remote attackers to execute arbitrary code by leveraging the ability to run arbitrary SQL statements (such as in certain WebSQL use cases), aka Magellan.

CVE-2018-8740 (2018-03-17)

In SQLite through 3.22.0, databases whose schema is corrupted using a CREATE TABLE AS statement could cause a NULL pointer dereference, related to build.c and prepare.c.

Changes for version 1.56 - 2018-02-28

  • Switched to a production version.

Changes for version 1.55_07 - 2018-01-27

  • This is a developer release to help testing DBIx::Class
  • Upgraded SQLite to 3.22.0
  • Disabled two STAT compile time options (tentatively), which fixes RT-124227 anyway

Changes for version 1.55_06 - 2018-01-27

  • This is a developer release to help testing DBIx::Class
  • Downgraded SQLite to 3.19.3 because of a SQLite regression (RT-124227, ribasushi++)
  • Fixed some tests to adapt to a change in error format introduced by the latest DBI
  • Remove no warnings test from t/43_fts.t which failed under some environments

Changes for version 1.55_05 - 2017-12-16

  • Implemented ParamValues statement handle attribute (RT-123886)

Changes for version 1.55_04 - 2017-11-22

  • Updated SQLite to 3.21.0
  • Resolved #122581: statistics_info() doesn't work correctly (John Deighan)
  • Fixed typo (GH#26, ReneNyffenegger)
  • Silenced some warnings (GH#25, Jacques Germishuys)
  • Fixed no dot in @INC issue (GH#24, ribasushi)
  • Fixed zero-length BLOB value is retrieved as undef (GH#23, SATO Kentaro)
  • Fixed VirtualTable::PerlData to use new ops added in SQLite 3.21.0 (GH#28, fschlich)
  • noted on sqlite_extended_result_codes handle attribute

Changes for version 1.55_03 - 2017-02-14

  • Updated SQLite to 3.17.0

Changes for version 1.55_02 - 2017-01-08

  • Updated SQLite to 3.16.2
  • Fixed statistics_info when only unique indexes were requested (Dave Rolsky++). GitHub #21

Changes for version 1.55_01 - 2017-01-04

  • Updated SQLite to 3.16.0

Documentation

DBD::SQLite::Cookbook
The DBD::SQLite Cookbook
DBD::SQLite::Fulltext_search
Using fulltext searches with DBD::SQLite

Modules

DBD::SQLite
Self-contained RDBMS in a DBI Driver
DBD::SQLite::Constants
common SQLite constants
DBD::SQLite::VirtualTable
SQLite virtual tables implemented in Perl
DBD::SQLite::VirtualTable::FileContent
virtual table for viewing file contents
DBD::SQLite::VirtualTable::PerlData
virtual table hooked to Perl data

Provides

DBD::SQLite::VirtualTable::Cursor
in lib/DBD/SQLite/VirtualTable.pm
DBD::SQLite::VirtualTable::FileContent::Cursor
in lib/DBD/SQLite/VirtualTable/FileContent.pm
DBD::SQLite::VirtualTable::PerlData::Cursor
in lib/DBD/SQLite/VirtualTable/PerlData.pm

Other files