PHPackages                             esplora/spire - 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. esplora/spire

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

esplora/spire
=============

Easy Tools for Production Environment of Laravel SQLite Database

0.0.4(2mo ago)22.8kMITPHPPHP ^8.0CI passing

Since Mar 8Pushed 2mo ago3 watchersCompare

[ Source](https://github.com/esplora/spire)[ Packagist](https://packagist.org/packages/esplora/spire)[ RSS](/packages/esplora-spire/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (4)Dependencies (12)Versions (5)Used By (0)

Spire
=====

[](#spire)

Spire is a Laravel package designed to provide easy tools specifically tailored for optimizing SQLite databases in production environments.

Installation
------------

[](#installation)

To install Spire into your Laravel project, you can use Composer:

```
composer require esplora/spire
```

Usage
-----

[](#usage)

Once installed, you can utilize Spire's commands via the Artisan CLI.

### Commands

[](#commands)

#### Enable WAL Journal

[](#enable-wal-journal)

To enable WAL journal on SQLite databases for performance optimization:

```
php artisan sqlite:wal-enable
```

Enabling WAL journaling can enhance database concurrency, reduce contention, and improve overall database performance, especially in high-traffic production environments.

#### Optimize Database

[](#optimize-database)

To optimize the SQLite database by running PRAGMA optimize:

```
php artisan sqlite:optimize
```

This combined optimization process ensures comprehensive optimization of the database file, resulting in improved performance and efficient storage utilization.

#### Run VACUUM

[](#run-vacuum)

To optimize the SQLite database by running VACUUM:

```
php artisan sqlite:vacuum
```

VACUUM rebuilds the database file, reclaims unused disk space, and can help to improve database performance by optimizing storage utilization.

### Schedule

[](#schedule)

For efficient database maintenance, it's highly recommended to schedule some of these commands as cron jobs. For instance, you can optimize the SQLite database periodically by adding a cron job to your scheduler:

```
// Optimize SQLite database every minute,
// see https://www.sqlite.org/pragma.html#pragma_optimize
$schedule->command('sqlite:optimize')->everyMinute();
```

###  Health Score

41

—

FairBetter than 89% of packages

Maintenance85

Actively maintained with recent releases

Popularity23

Limited adoption so far

Community8

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 ~241 days

Total

4

Last Release

77d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/3c47797b11041f37c2eec74b09bc6619c8997467d690797ebad0e6ab7cb232b7?d=identicon)[tabuna](/maintainers/tabuna)

---

Top Contributors

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

---

Tags

laravelsqlite

###  Code Quality

TestsPHPUnit

Code StyleLaravel Pint

### Embed Badge

![Health badge](/badges/esplora-spire/health.svg)

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

###  Alternatives

[anourvalar/eloquent-serialize

Laravel Query Builder (Eloquent) serialization

11120.2M21](/packages/anourvalar-eloquent-serialize)[overtrue/laravel-versionable

Make Laravel model versionable.

585308.0k5](/packages/overtrue-laravel-versionable)[abbasudo/laravel-purity

elegant way to add filter and sort in laravel

514330.5k1](/packages/abbasudo-laravel-purity)[statamic-rad-pack/runway

Eloquently manage your database models in Statamic.

135192.6k5](/packages/statamic-rad-pack-runway)[dragon-code/laravel-deploy-operations

Performing any actions during the deployment process

240173.5k2](/packages/dragon-code-laravel-deploy-operations)[stayallive/laravel-eloquent-observable

Register Eloquent model event listeners just-in-time directly from the model.

2928.9k7](/packages/stayallive-laravel-eloquent-observable)

PHPackages © 2026

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