PHPackages                             georgechem/sqlite-db - 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. georgechem/sqlite-db

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

georgechem/sqlite-db
====================

Allow quickly create/use sqlite database as a storage.

v1.1.0(4y ago)1241MITPHPPHP >=8.0.0

Since Oct 26Pushed 4y ago1 watchersCompare

[ Source](https://github.com/georgechem/packagist-sqlite-db)[ Packagist](https://packagist.org/packages/georgechem/sqlite-db)[ RSS](/packages/georgechem-sqlite-db/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (1)Versions (2)Used By (1)

### Simple Sqlite Storage

[](#simple-sqlite-storage)

---

Storage should be used only for simple key-pair data. Objects storage should be avoided as bad practice however it is fully supported. To store objects it is better to create separate class and extends abstract Db class.

ex:

```
class User extends Db {
    self::$pdo - object is available

    ... add your methods like:
    public function insertUser() ... etc.

    Methods that must be implemented (required by abstarct class Db)

    public function create(){}
    public function destroy(){}
    public function empty(){}

}
```

```
mixed $value - it can be any type (under the hood $value is serialized and
unserialized so type is preserved);

string $key - as it states must be a string
```

Install using composer:

```
composer require georgechem/sqlite-db

```

Require autoloader as normal:

```
require __DIR__ . '/vendor/autoload.php';
```

Usage

---

```
$storage = new Storage();

// save value associated with certain key in database (keys are unique)
$storage->save(string 'key_name', mixed $value);

// if you want to overwrite certain key set appropriate flag
$storage->save(string 'key_name', mixed $value, true);

// To read value associated wit certain key
$storage->read(string 'test');

// returns array of all available key in storage OR empty array if none
$storage->getAllKeys();

// empty storage (delete only entries but keep table)
$storage->empty();

// destroy storage
$storage->destroy();
```

###  Health Score

26

—

LowBetter than 40% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity56

Maturing project, gaining track record

 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.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

1757d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/54766527?v=4)[Grzegorz Chrymecki](/maintainers/georgechem)[@georgechem](https://github.com/georgechem)

---

Top Contributors

[![georgechem](https://avatars.githubusercontent.com/u/54766527?v=4)](https://github.com/georgechem "georgechem (25 commits)")

---

Tags

php8sqlite3

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/georgechem-sqlite-db/health.svg)

```
[![Health](https://phpackages.com/badges/georgechem-sqlite-db/health.svg)](https://phpackages.com/packages/georgechem-sqlite-db)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.8k117.8M121](/packages/jdorn-sql-formatter)[backup-manager/backup-manager

A framework agnostic database backup manager with user-definable procedures and support for S3, Dropbox, FTP, SFTP, and more with drivers for popular frameworks.

1.7k1.6M11](/packages/backup-manager-backup-manager)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M88](/packages/propel-propel1)[insolita/yii2-migration-generator

Set of gii tools for generating files for migration by schema of table , phpdoc or table data

108508.0k5](/packages/insolita-yii2-migration-generator)[xpdo/xpdo

A PDO-based Object/Relational Bridge Library

7088.4k4](/packages/xpdo-xpdo)[voku/session2db

A PHP library acting as a wrapper for PHP's default session handling functions which stores data in a MySQL database, providing both better performance and better security and protection against session fixation and session hijacking.

2920.0k](/packages/voku-session2db)

PHPackages © 2026

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