Download the PHP package nielspeen/rqlite-laravel-driver without Composer
On this page you can find all versions of the php package nielspeen/rqlite-laravel-driver. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download nielspeen/rqlite-laravel-driver
More information about nielspeen/rqlite-laravel-driver
Files in nielspeen/rqlite-laravel-driver
Package rqlite-laravel-driver
Short Description RQLite driver for Laravel
License MIT
Homepage https://github.com/nielspeen/rqlite-laravel-driver
Informations about the package rqlite-laravel-driver
RQLite Driver for Laravel
Supported
- Eloquent Queries
- Read Consistency: Strong, Weak or None
- Read Freshness & Strict Freshness
- Queued Writes
- Optional direct reading of SQLite database
Not (yet) Supported
- Bulk Writes
- Bulk Selects
- Transactions
Installation
Install using composer:
Setup
Sample configuration:
Note that the database db name is ignored as RQLite currently supports only a single database. I recommend you specify a database name anyway, for maximum compatibility with Laravel.
Usage
By default, all queries are executed with strong consistency. You can specify the consistency level by using the methods show below.
Using a Model Trait
Extended RQLite Models
Using the query builder:
PDO
Sometimes you want to access the PDO object directly. For example:
Warning
The consistency level is not reset after a query is executed. Consecutive queries will use the same consistency level unless a new consistency level is set using the Trait, the Models, or the query builder.
This approach ensures that eager loading uses the same consistency level as the primary model being queried.
Directly reading from SQLite
If you have a high traffic website, the overhead of going through RQLite can be significant. With some precautions, you can boost performance by reading directly from SQLite. This is applied to queries with None consistency only.
In your database.php add a sqlite parameter pointing directly and the dabase:
Secondly, you need to ensure your Laravel application has read-only access to the SQLite database.
Do NOT give your Laravel application write access to the SQLite database. This will corrupt the database! Even in read-only mode, SQLite will occasionally make modifications to the database incompatible with RQLite.
Credits
- [nielspeen][https://github.com/nielspeen)
- hushulin
- All Contributors
License
The MIT License (MIT). Please see License File for more information.