Download the PHP package mnapoli/sqlite-s3 without Composer
On this page you can find all versions of the php package mnapoli/sqlite-s3. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package sqlite-s3
Serverless dev database: SQLite backed by S3
Why?
A "serverless" SQL database:
- For development and testing purposes
- Costs $0
- As simple to use as possible
- Ideal for serverless environments like AWS Lambda
Not for production use-cases. It does not handle concurrent updates (in which case some data might be lost) and performances are not production-grade.
How?
The SQLite database (a file) is stored on S3. The PHP class will transparently download the file locally on every request, and upload it back at the end.
This has two obvious implications:
- If two concurrent requests download the database file, update it (separately), and upload it back, then the last to upload the modified file will overwrite the changes of the other request.
- There is extra latency added to the request (and it wouldn't work well with huge databases).
That is why this solution is best for testing scenarios (e.g. testing a fully deployed application, where there is one test running at a time). It could also work for development environments with only one active user at a time, where an extra 50ms-100ms per request is acceptable.
Setup
You will need an AWS S3 bucket (where the database will be stored). The S3 bucket must exist, but the SQLite database file will automatically be created if it doesn't.
Install the package with Composer:
Usage
With Laravel
Update .env (or set environment variables) to set:
DB_CONNECTION=sqliteDB_DATABASE='s3://the-s3-bucket-name/a-file-name.sqlite'
The DB_DATABASE usually contains a file name, but here it will contain a S3 URL. That URL will be automatically detected to retrieve the database from S3.
The database will be uploaded to S3 on every request. When running on AWS Lambda with Bref, it will be uploaded/synced on every AWS Lambda invocation too.
Outside of Lambda (for example in test code), call DB::purge(); to force the database to be synced to S3.
Generic PHP application
Instead of:
Use:
The database will be uploaded back to S3 when the $db instance is destroyed (i.e. when the PDO connection is closed).
Configuration
If needed, set the AWS region:
The AWS credentials will automatically be picked up by the AWS SDK. The Async-AWS library is used under the hood, check out its documentation.
Without PDO
If you are using the SQLite3 class directly, replace it with the SQLiteS3 class:
All versions of sqlite-s3 with dependencies
ext-pdo Version *
ext-sqlite3 Version *
async-aws/simple-s3 Version ^1|^2
bref/bref Version ^2.1.10
bref/logger Version ^1.0