Download the PHP package crhg/laravel-sqlite-named-memory-connection without Composer
On this page you can find all versions of the php package crhg/laravel-sqlite-named-memory-connection. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download crhg/laravel-sqlite-named-memory-connection
More information about crhg/laravel-sqlite-named-memory-connection
Files in crhg/laravel-sqlite-named-memory-connection
Package laravel-sqlite-named-memory-connection
Short Description SQLite connector which supports named in-memory database connection
License MIT
Informations about the package laravel-sqlite-named-memory-connection
DESCRIPTION
This package provides sqlite-named driver that extends Laravel's sqlite driver.
Using this driver allows you to specify a database in the form named-memory:<name>.
(<name> is an arbitrary string (including empty string))
It connects to SQLite's in-memory database as well as :memory:.
:memory: creates a new database for each connection, whereas :named-memory:<name> returns the same connection
if <name> is same.
INSTALL
CONFIGURATION
Specify sqlite-named fordriver in config/database.php.
config/database.php:
.env:
BACKGROUND
SQLite's in-memory database is effective to speed up tests using the database.
However, using refreshApplication() caused the problem of emptying the database.
This is due to the following reasons.
- Since the IoC container is regenerated,
\Illuminate\Database\DatabaseManagerthat was registered as singleton is discarded and replaced with a new one. - Information on the connected database managed by
DatabaseManageris not passed to the newly generatedDatabaseManager. - When a connection to the DB is requested for the first time after
refreshApplication(), the DatabaseManager has no connection, so a new connection to:memory:is generated - The connection to
:memory:is a connection to a newly created empty in-memory database.
If you use :named-memory:<name> instead of :memory:,
this problem can be avoided by returning the connection identified by <name>
which was used before refreshApplication ().
All versions of laravel-sqlite-named-memory-connection with dependencies
ext-pdo Version *
illuminate/support Version ^5.5 || ^6.0 || ^7.0
illuminate/database Version ^5.5 || ^6.0 || ^7.0