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\DatabaseManager
that was registered as singleton is discarded and replaced with a new one. - Information on the connected database managed by
DatabaseManager
is 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