tina4stack/tina4php-sqlite3

Tina4 PHP Sqlite3 Database Driver

Maintainers

Package info

github.com/tina4stack/tina4php-sqlite3

pkg:composer/tina4stack/tina4php-sqlite3

Statistics

Installs: 3 638

Dependents: 6

Suggesters: 0

Stars: 1

Open Issues: 0

Security

Advisories: 0

Aikido package health analysis

v2.0.7 2026-03-14 19:29 UTC

Requires

Requires (Dev)

MIT c64d2070bde5102beed34b7cbeefad900b460545

This package is auto-updated.

Last update: 2026-03-14 19:37:38 UTC

README

SQLite3 database driver for the Tina4 PHP framework.

Installation

composer require tina4stack/tina4php-sqlite3

Requirements

  • PHP >= 8.1
  • ext-sqlite3
  • tina4stack/tina4php-database ^2.0

Usage

// Connection format: path to .db file (no user/pass needed)
$DBA = new \Tina4\DataSQLite3("test.db");

// Execute queries
$DBA->exec("create table users (id integer primary key, name varchar(200))");
$DBA->commit();

// Insert with parameters
$DBA->exec("insert into users (id, name) values (?, ?)", 1, "Alice");

// Fetch records
$result = $DBA->fetch("select * from users");
$records = $result->asArray();

// Fetch with limit and offset
$result = $DBA->fetch("select * from users", 10, 0);

// Fetch single record
$record = $DBA->fetchOne("select * from users where id = 1");

// Check if table exists
$exists = $DBA->tableExists("users");

// Get database metadata
$metadata = $DBA->getDatabase();

Testing

composer test

License

MIT - see LICENSE

Our Sponsors

Sponsored with 🩵 by Code Infinity

Code Infinity

Supporting open source communities • Innovate • Code • Empower