Download the PHP package portrino/px_dbsequencer without Composer
On this page you can find all versions of the php package portrino/px_dbsequencer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download portrino/px_dbsequencer
More information about portrino/px_dbsequencer
Files in portrino/px_dbsequencer
Package px_dbsequencer
Short Description With this extension you can ensure different unique keys for the configured tables (e.g.: pages, tt_content)
License GPL-2.0-or-later
Informations about the package px_dbsequencer
TYPO3 extension px_dbsequencer
Database Sequencer for TYPO3
1 Features
The PxDbsequencer extension enables the possibility to define different unique keys for the configured tables (e.g.: pages, pages_language_overlay, tt_content).
That means, you define a global identifier, e.g. per environment, and every identifier/ primary key of the configured table(s) will be sequenced in steps of a defined offset (default: 10).
So, if configure the global identifier "1" for your production system, then every configured table will have identifiers/ primary keys like 1, 11, 21, 31 and so on. For your staging system, you may define the global identifier "2", which than results in table identifiers like 2, 12, 22, 32 and so on.
In addition, every developer of the project can have his own global identifier as well. Therefor the risk of overriding data, that has to be migrated between systems (e.g. pages and content elements for a new feature), will be minimized.
2 Usage
2.1 Installation
Installation using Composer
The recommended way to install the extension is using composer.
Run the following command within your Composer based TYPO3 project:
Installation as extension from TYPO3 Extension Repository (TER)
Download and install the extension with the extension manager module.
2.2 Setup
After finishing the installation, head over to the extension settings and set the system identifier, the offset and the tables you'd like to sequence.
The extension settings, like the system identifier, can also be configured depending on the current TYPO3_CONTEXT
via
config/system/additional.php
SO, a possible configuration in config/system/settings.php
could look like:
and in config/system/additional.php
could be something like:
3 Compatibility
PxDbsequencer | TYPO3 | PHP | Support / Development |
---|---|---|---|
13.x | 13.4 | 8.2 - 8.3 | features, bugfixes, security updates |
0.12.x | 12.4 | 8.1 - 8.2 | features, bugfixes, security updates |
0.11.x | 11.5 | 7.4 - 8.1 | bugfixes, security updates |
0.10.x | 10.4 | 7.2 - 7.4 | none |
0.9.x | 9.5 | 7.2 - 7.4 | none |
0.7.x | 8.7 | 7.0 - 7.4 | none |
0.6.x | 7.6 | 5.5 - 7.3 | none |
4 Authors
- See the list of contributors who participated in this project.