PHPackages                             nikolav/dblite-php - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. nikolav/dblite-php

ActiveLibrary[Database & ORM](/categories/database)

nikolav/dblite-php
==================

sqlite3 wrapper

019[1 PRs](https://github.com/nikolav/dblite-php/pulls)PHP

Since Sep 17Pushed 1y ago1 watchersCompare

[ Source](https://github.com/nikolav/dblite-php)[ Packagist](https://packagist.org/packages/nikolav/dblite-php)[ RSS](/packages/nikolav-dblite-php/feed)WikiDiscussions master Synced 1w ago

READMEChangelogDependenciesVersions (2)Used By (0)

dblite-php
==========

[](#dblite-php)

lightweight wrapper for [php sqlite3](http://php.net/SQLite3) database
----------------------------------------------------------------------

[](#lightweight-wrapper-for-php-sqlite3-database)

```
deps:
  php5+
  SQLite3

about:
  sqlite3 wrapper
  Iterator

APIs:

  dblite{}:

    instance:

      .q      // holds qstatus{} with last query stats
      .status // 'success-flag' for last query (0 'OK', other '!OK')

      .close(void)           // release result, close db, 0-fy dblite{} state
      .exec(string)          // SQLite3#exec()
      .ins(string, matrix2D) // insert data
      .ls(void)              // list tables
      .open(dbconn)          // load a database file
      .q(string)             // SQLite3#querySingle()
      .query(string)         // query, save result, set dblite#q{} query status
      .schema([string])      // get table description{}(s)

    static:
      .esc(string)           // SQLite3#escapeString
      .start(string [, int]) // factory

  dbpool{}:

    instance:

      .db // active dblite{}

      .ls(void)          // list database aliases
      .main(string)      // set dblite{} aliased by parameter as active
        .active          // method alias for .main
      .rm([, ...string]) // remove(all) specified dblite{}(s) by alias(es)

    static:
      .init(void)  // fetch dbpool singleton

  dbconn{}:

    instance:

      .mode(void) // getter
      .path(void) // getter

  qstatus{}

    instance:

      .changes     // (int) affected rows
      .code        // (int) error code
      .error       // (Exception or null) error thrown
      .insert_id   // (int)
      .last_query  // (string)
      .message     // (string) error message

usage example #1:

// get singleton database-list instance
// to be populated with db connection objects
$pool = dbpool::init();

// populate it with sample db objects
$pool->app_admin = dblite::start('data/app_admin.sqlite3.db');
$pool->app_forum = dblite::start('data/app_forum.sqlite3.db');
$pool->app_x     = dblite::start('data/app_x.sqlite3.db');

// load admin database, send sql, loop results
$pool->main('app_admin');
foreach ($pool->db->query('select stuff from admin_tables') as $data)
  process($data);

// load, crud, loop, etc.
$pool->main('app_forum');

// sample post table schema:
create table
  tbl_post (
    id       integer  primary key,
    title    text     not null,
    content  text     not null,
    post_id  integer  null
  );

$query = q($query));

usage example #2:

  $b = dblite::start('data/app.sqlite3.db');
  foreach ($b->query("select stuff from tables") as $record)
    process($record);

```

###  Health Score

19

—

LowBetter than 10% of packages

Maintenance30

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity30

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/52c1f899917344187fc76a0b346ef2894fbc469616824aeec024014014cc90c0?d=identicon)[nikolav](/maintainers/nikolav)

---

Top Contributors

[![nikolav](https://avatars.githubusercontent.com/u/6069116?v=4)](https://github.com/nikolav "nikolav (22 commits)")

### Embed Badge

![Health badge](/badges/nikolav-dblite-php/health.svg)

```
[![Health](https://phpackages.com/badges/nikolav-dblite-php/health.svg)](https://phpackages.com/packages/nikolav-dblite-php)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90440.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps

Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application.

7511.7M13](/packages/wildside-userstamps)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)