PHPackages                             mugomes/miphantdblite - 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. mugomes/miphantdblite

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

mugomes/miphantdblite
=====================

Crie tabelas e consulte, adicione, altere e exclua registros do SQLite3.

3.0.0(4mo ago)017MITPHP

Since Nov 4Pushed 4mo agoCompare

[ Source](https://github.com/mugomes/miphantdblite)[ Packagist](https://packagist.org/packages/mugomes/miphantdblite)[ Docs](https://github.com/mugomes/miphantdblite)[ Fund](https://apoia.se/profmu)[ Fund](https://mugomes.github.io)[ RSS](/packages/mugomes-miphantdblite/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (5)DependenciesVersions (6)Used By (0)

MiPhantDBLite
=============

[](#miphantdblite)

**MiPhantDBLite** é uma biblioteca **leve, minimalista e fluente escrita em PHP** para trabalhar com **SQLite3**, focada em **simplicidade**, **baixo consumo de recursos** e **controle total do SQL gerado**.

Ela é a versão **Lite** do MiPhantDB, pensada para cenários onde **SQLite** é a melhor escolha: aplicações desktop, CLIs, sistemas embarcados, ferramentas locais, cache persistente e pequenos bancos de dados.

Sem ORM pesado, sem abstrações mágicas, apenas **SQL claro, previsível e encadeável**.

---

✨ Características
-----------------

[](#-características)

- Abstração leve sobre **SQLite3**
- API fluente (encadeável)
- Suporte a **SELECT, INSERT, UPDATE, DELETE**
- Suporte opcional a **prepared statements**
- Construção dinâmica de `WHERE`, `ORDER BY` e `LIMIT`
- Suporte a `LIKE`, `IN`, `AND`, `OR`
- Criação de tabelas via código
- Modo **sandbox** para debug
- Zero dependências externas
- Compatível com **PHP 8.4 ou superior**

---

📦 Instalação
------------

[](#-instalação)

### Via Composer (recomendado)

[](#via-composer-recomendado)

```
composer require mugomes/miphantdblite
```

### Manual

[](#manual)

Copie os arquivos da pasta `MiPhantDBLite` para o seu projeto e utilize `require` ou autoload.

---

🔌 Conexão com o banco SQLite
----------------------------

[](#-conexão-com-o-banco-sqlite)

```
use MiPhantDBLite\database;

$db = new database(
    'database.sqlite',
    true // modo sandbox (erros exibidos na tela)
);
```

Também é possível usar opções de abertura:

```
$db = new database(
    'database.sqlite',
    false,
    database::READWRITE | database::CREATEONLY
);
```

---

📖 SELECT
--------

[](#-select)

```
use MiPhantDBLite\select;

$select = new select('database.sqlite');

$select->table('users')
    ->column('id')
    ->column('name')
    ->where('status', 'ativo')
    ->order('name')
    ->limit(0, 10)
    ->select();

while ($row = $select->fetch()) {
    echo $row['name'];
}

$select->close();
```

---

🔐 Prepared Statements
---------------------

[](#-prepared-statements)

```
$select->activatePrepared()
    ->table('users')
    ->where('id', 1)
    ->select();

$row = $select->fetch();
$select->close();
```

- Evita SQL Injection
- Ideal para dados dinâmicos
- Ativado explicitamente via `activatePrepared()`

---

➕ INSERT
--------

[](#-insert)

```
use MiPhantDBLite\insert;

$insert = new insert('database.sqlite');

$insert->activatePrepared()
    ->table('users')
    ->insertValue('name', 'João')
    ->insertValue('email', 'joao@email.com')
    ->insert();

$id = $insert->idInsert();
$insert->close();
```

---

✏️ UPDATE
---------

[](#️-update)

```
use MiPhantDBLite\update;

$update = new update('database.sqlite');

$update->activatePrepared()
    ->table('users')
    ->updateValue('email', 'novo@email.com')
    ->where('id', 1)
    ->update();

$update->close();
```

---

❌ DELETE
--------

[](#-delete)

```
use MiPhantDBLite\delete;

$delete = new delete('database.sqlite');

$delete->table('users')
    ->where('id', 1)
    ->delete();

$delete->close();
```

---

🧱 Criação de tabelas
--------------------

[](#-criação-de-tabelas)

```
use MiPhantDBLite\table;

$table = new table('database.sqlite');

$table->table('users')
    ->setInt()->primaryKey()->autoIncrement()->insertColumn('id')
    ->insertColumn('name')
    ->insertColumn('email')
    ->create();

$table->close();
```

---

🔒 Encerrando a conexão (`close`)
--------------------------------

[](#-encerrando-a-conexão-close)

```
$db->close();
```

### O que o `close()` faz?

[](#o-que-o-close-faz)

- Libera resultados ativos
- Finaliza prepared statements (quando usados)
- Fecha corretamente a conexão SQLite
- Evita vazamento de recursos em scripts longos ou CLIs

> 💡 **Boa prática:**Embora o PHP finalize a conexão ao fim do script, o uso explícito de `close()` é altamente recomendado em aplicações CLI, loops e processos persistentes.

---

🧠 Outras Informações
--------------------

[](#-outras-informações)

- SQLite continua sendo SQLite
- Sem ORM pesado
- Sem reflexão ou proxies mágicos
- SQL previsível e fácil de depurar
- Ideal para projetos pequenos, locais ou embarcados

---

👤 Autor
-------

[](#-autor)

**Murilo Gomes Julio**

🔗

📺

---

🤝 Support
---------

[](#-support)

- GitHub Sponsors:
- Apoie o projeto:

---

📜 License
---------

[](#-license)

Copyright (c) 2025-2026 Murilo Gomes Julio

Licensed under the [MIT](https://github.com/mugomes/miphantdblite/blob/main/LICENSE).

All contributions to the MiPhantDBLite are subject to this license.

###  Health Score

33

—

LowBetter than 75% of packages

Maintenance76

Regular maintenance activity

Popularity6

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity39

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.

###  Release Activity

Cadence

Every ~17 days

Total

5

Last Release

128d ago

Major Versions

1.0.2 → 2.0.02025-11-17

2.0.0 → 3.0.02026-01-10

### Community

Maintainers

![](https://www.gravatar.com/avatar/e782d9d31b820ca2583dce523269edf91ef2db0d5c48af08384fad35324643cd?d=identicon)[mugomesoficial](/maintainers/mugomesoficial)

---

Top Contributors

[![mugomes](https://avatars.githubusercontent.com/u/214032302?v=4)](https://github.com/mugomes "mugomes (18 commits)")

---

Tags

phpsqlite3

### Embed Badge

![Health badge](/badges/mugomes-miphantdblite/health.svg)

```
[![Health](https://phpackages.com/badges/mugomes-miphantdblite/health.svg)](https://phpackages.com/packages/mugomes-miphantdblite)
```

###  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)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

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

Reliese Components for Laravel Framework code generation.

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

PHPackages © 2026

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