Download the PHP package marshmallow/laravel-database-sync without Composer

On this page you can find all versions of the php package marshmallow/laravel-database-sync. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

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 PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • 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.
Please rate this library. Is it a good library?

Informations about the package laravel-database-sync

Laravel Database Sync

A powerful Laravel package that enables seamless synchronization of data from a remote database to your local development environment.

Table of Contents

Requirements

Installation

You can install the package via composer:

Configuration

Publish the configuration file:

Environment Variables

Add these variables to your .env file:

Important: When connecting to a Forge-provisioned database server, you must use the main database user that was created during the initial server provisioning. Other database users created afterward may not have the necessary privileges to execute the required database commands for synchronization.

Usage

Basic Synchronization

To sync your remote database to local:

By default, the package uses batch file transfers for optimal performance, transferring all table data in a single file to minimize network overhead.

Advanced Options

The sync command supports several options:

Available options:

Per-Table Sync Tracking

The package now tracks the last sync date for each individual table, preventing data loss when syncing single tables. This means:

Viewing Sync Status

To see the last sync date for all tables:

This will display a table showing each table name and its last sync date, helping you track which tables have been synced recently and which might need attention.

How It Works

  1. Sync Start Timestamp: The sync timestamp is captured when the sync process begins
  2. Individual Table Tracking: Each table's sync date is stored separately in the cache file
  3. Atomic Updates: Cache is only updated when the entire sync process completes successfully
  4. Automatic Fallback: If no table-specific date exists, the global sync date is used
  5. Backward Compatibility: Existing installations continue to work without any changes
  6. Debug Information: When running with -vvv (debug mode), you'll see which sync date is being used for each table
  7. Error Recovery: If sync fails, the cache remains unchanged with the previous sync dates

File Transfer Optimization

The package uses batch file transfers by default to minimize network overhead:

Configuration

Control the transfer mode in config/database-sync.php:

Or via environment variable:

Benefits of Batch Transfer

When Individual Transfers Are Used

Table Configuration

You can exclude specific tables from synchronization in the config/database-sync.php file:

Timeout Configuration

For large databases, you may need to adjust the process timeout to prevent operations from timing out:

You can also set this via environment variable:

This timeout applies to:

Synchronization Suites

Define custom synchronization suites in the configuration file to group tables for specific sync tasks:

Then use the suite option:

Multi-Tenant Support

The package supports multi-tenant architectures. Enable it in the configuration:

Configure tenant-specific settings in your configuration file and use the --tenant option to sync specific tenant databases:

Testing

This package uses Pest PHP for testing. To run the tests:

To run tests with coverage report:

Test Structure

The test suite includes:

Writing Tests

To add new tests, create a new test file in either the tests/Unit or tests/Feature directory. The package uses Pest's expressive syntax:

Security

Support

For support, please email [email protected]

License

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


All versions of laravel-database-sync with dependencies

PHP Build Version
Package Version
Requires php Version ^8.2
laravel/framework Version ^10.0|^11.0|^12.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package marshmallow/laravel-database-sync contains the following files

Loading the files please wait ....