ahoicloud/laravel-sqlite-optimize

Optimizing SQLite in Laravel

v1.0.3 2024-06-16 14:53 UTC

Requires

• php: ^8.2
• illuminate/contracts: ^10.0||^11.0
• spatie/laravel-package-tools: ^1.16

Requires (Dev)

• larastan/larastan: ^2.9
• laravel/pint: ^1.14
• nunomaduro/collision: ^8.1.1||^7.10.0
• orchestra/testbench: ^9.0.0||^8.22.0
• pestphp/pest: ^2.34
• pestphp/pest-plugin-arch: ^2.7
• pestphp/pest-plugin-laravel: ^2.3
• phpstan/extension-installer: ^1.3
• phpstan/phpstan-deprecation-rules: ^1.1
• phpstan/phpstan-phpunit: ^1.3

MIT

• Arne Breitsprecher

• sqlite
• laravel
• ahoicloud
• AHOI
• laravel-sqlite-optimize
• sqllite
• sqlite-optimize
• sqlite-performance

README

This package should optimize SQLite for usage in Laravel. Inspired by the Article from Italo Baeza Cabrera

Installation

You can install the package via composer:

composer require ahoicloud/laravel-sqlite-optimize

Usage

Enable WAL

php artisan sqlite:wal-enable sqlite

Where sqlite is the connection name.

Perform database backup

php artisan sqlite:backup

Puts a backup for the sqlite file in the directory database_path(backup/) path

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Arne Breitsprecher
• Italo Baeza Cabrera
• All Contributors

License

The MIT License (MIT). Please see License File for more information.