PHP download

Download the PHP package maba/database-inconsistency-finder without Composer

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

Table of contents
Download maba/database-inconsistency-finder
More information about maba/database-inconsistency-finder
Files in maba/database-inconsistency-finder

Vendor maba
Package database-inconsistency-finder
Short Description Library that helps finding inconsistencies between database tables or different databases
License MIT

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?

Example code of maba/database-inconsistency-finder

Informations about the package database-inconsistency-finder

Database inconsistency finder

Library that helps to find orphaned records (if they should be removed when nothing points to them), references to non-existing records and invalid number of references to those records.

When could this be helpful?

you don't use foreign keys and could have invalid references. This could happen due to different reasons:
- you have several different databases, for example when sharding or using microservices;
- you don't use foreign keys for easier database structure migrations;
- you have application that just does not use foreign keys;
you want to find orphaned records. For example, you can have Files in a database table and if nothing points to this record, we want to delete the file itself.

Normally, these restrictions would be guaranteed by your application. Unfortunately, stuff happens and there might be some inconsistencies that just occur time to time.

Installation

Configuration and usage

Currently all work is done synchronously. You can configure this by implementing JobDistributorFactoryInterface and related JobDistributorInterface. In this case create service tree yourself, do not use the Factory class.

Internals

Consistency validation is performed in the following manner:

ID range is queried from the database (from-to IDs in the main table)
range is divided into separate intervals for job distribution
each job is given to concrete worker
worker validates consistency by using SUM query to the database, which is relatively fast
if inconsistencies are found in the interval, it's split into even smaller intervals
with each smaller interval SUM query is repeated
for those intervals where inconsistencies are found, inconsistency seeking algorithm is ran

Inconsistency seeking algorithm

all IDs and their corresponding reference counts are fetched from the database
all related tables are iterated over and all IDs are fetched from there
fetched data is looped to find any inconsistencies

These actions are performed in-memory, so it's essential that interval in this stage would be already quite small.

Consistency validation

Consistency is validated by issuing SUM queries to database. To avoid false positives, we select not the sum of reference counts, but sum of CRC32 of referenced IDs (and sum them that many times how many times they were referenced).

Semantic versioning

This library follows semantic versioning.

See Symfony BC rules for basic information about what can be changed and what not in the API.

Running tests

Contributing

Feel free to create issues and give pull requests.

You can fix any code style issues using this command:

All versions of database-inconsistency-finder with dependencies

PHP Build Version

Package Version

Version 0.1.0 Release 07. Aug 2019
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of database-inconsistency-finder from vendor maba

Requires php Version >=7.2
ext-pdo_mysql Version *
predis/predis Version ^1.1
doctrine/dbal Version 2.9.2

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 maba/database-inconsistency-finder contains the following files

Loading the files please wait ....