PHPackages portrino/px\_dbsequencer - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. portrino/px\_dbsequencer ActiveTypo3-cms-extension[Database & ORM](/categories/database) portrino/px\_dbsequencer ======================== With this extension you can ensure different unique keys for the configured tables (e.g.: pages, tt\_content) 13.1.3(5mo ago)17.0k—0%[1 PRs](https://github.com/portrino/px_dbsequencer/pulls)GPL-2.0-or-laterPHPPHP ^8.2CI passing Since Dec 14Pushed 3mo ago5 watchersCompare [ Source](https://github.com/portrino/px_dbsequencer)[ Packagist](https://packagist.org/packages/portrino/px_dbsequencer)[ RSS](/packages/portrino-px-dbsequencer/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (5)Dependencies (13)Versions (26)Used By (0) TYPO3 extension `px_dbsequencer` ================================ [](#typo3-extension-px_dbsequencer) [![Latest Stable Version](https://camo.githubusercontent.com/d4b4bc271228d5ea3271546542de5865113f0f9ddc4faac8ae2f3ee558d38323/68747470733a2f2f706f7365722e707567782e6f72672f706f727472696e6f2f70785f646273657175656e6365722f762f737461626c65)](https://packagist.org/packages/portrino/px_dbsequencer)[![TYPO3 13](https://camo.githubusercontent.com/2cf6570821614808899422f68a66a381a2de1dd0746ba9cdba6155def1f4f396/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5459504f332d31332d6f72616e67652e737667)](https://get.typo3.org/version/13)[![Total Downloads](https://camo.githubusercontent.com/2664bfcbc7d74eaf810fcaba1d51c41569f2024fe206306f45d367a7c9be1829/68747470733a2f2f706f7365722e707567782e6f72672f706f727472696e6f2f70785f646273657175656e6365722f646f776e6c6f616473)](https://packagist.org/packages/portrino/px_dbsequencer)[![Monthly Downloads](https://camo.githubusercontent.com/aa4dfb6f4abb1f80aa5b66a6a9fe3447c03f4a456280ea7b533090d537d4e198/68747470733a2f2f706f7365722e707567782e6f72672f706f727472696e6f2f70785f646273657175656e6365722f642f6d6f6e74686c79)](https://packagist.org/packages/portrino/px_dbsequencer)[![CI](https://github.com/portrino/px_dbsequencer/actions/workflows/ci.yml/badge.svg)](https://github.com/portrino/px_dbsequencer/actions/workflows/ci.yml) > Database Sequencer for TYPO3 1 Features ---------- [](#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-usage) ### 2.1 Installation [](#21-installation) #### Installation using Composer [](#installation-using-composer) The **recommended** way to install the extension is using [composer](https://getcomposer.org/). Run the following command within your Composer based TYPO3 project: ``` composer require portrino/px_dbsequencer ``` #### Installation as extension from TYPO3 Extension Repository (TER) [](#installation-as-extension-from-typo3-extension-repository-ter) Download and install the [extension](https://extensions.typo3.org/extension/px_dbsequencer) with the extension manager module. ### 2.2 Setup [](#22-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: ``` return [ ... 'EXTENSIONS' => [ ... 'px_dbsequencer' => [ 'offset' => 10, 'system' => 1, 'tables' => 'be_groups,be_users,pages,sys_category,sys_template,tt_content', ], ... ], ... ]; ``` and in `config/system/additional.php` could be something like: ``` // contextual environment settings $applicationContext = \TYPO3\CMS\Core\Utility\GeneralUtility::trimExplode( '/', \TYPO3\CMS\Core\Core\Environment::getContext(), true ); switch ($applicationContext[0]) { case 'Development': switch ($applicationContext[1]) { case 'Staging': // TYPO3_CONTEXT: Development/Staging $GLOBALS['TYPO3_CONF_VARS']['EXTENSIONS']['px_dbsequencer']['system'] = 2; break; case 'Local': // TYPO3_CONTEXT: Development/Local $GLOBALS['TYPO3_CONF_VARS']['EXTENSIONS']['px_dbsequencer']['system'] = 3; break; } break; case 'Production': $GLOBALS['TYPO3_CONF_VARS']['EXTENSIONS']['px_dbsequencer']['system'] = 1; break; } ``` 3 Compatibility --------------- [](#3-compatibility) PxDbsequencerTYPO3PHPSupport / Development13.x13.48.2 - 8.3features, bugfixes, security updates0.12.x12.48.1 - 8.2features, bugfixes, security updates0.11.x11.57.4 - 8.1bugfixes, security updates0.10.x10.47.2 - 7.4none0.9.x9.57.2 - 7.4none0.7.x8.77.0 - 7.4none0.6.x7.65.5 - 7.3none4 Authors --------- [](#4-authors) - See the list of [contributors](https://github.com/portrino/px_dbsequencer/graphs/contributors) who participated in this project. ### Health Score 54 — FairBetter than 97% of packages Maintenance76 Regular maintenance activity Popularity25 Limited adoption so far Community12 Small or concentrated contributor base Maturity86 Battle-tested with a long release history Bus Factor1 Top contributor holds 73.9% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~217 days Recently: every ~81 days Total 18 Last Release 116d ago Major Versions 0.13.0 → 13.1.02025-02-28 ### Community Maintainers ![](https://www.gravatar.com/avatar/03867e1d2497d7cb7feb932fb301387e143503bfd17c584ef90347b3d7942cf1?d=identicon)[portrino-dev](/maintainers/portrino-dev) --- Top Contributors [![EvilBMP](https://avatars.githubusercontent.com/u/540478?v=4)](https://github.com/EvilBMP "EvilBMP (34 commits)")[![tgriessbach](https://avatars.githubusercontent.com/u/11647324?v=4)](https://github.com/tgriessbach "tgriessbach (11 commits)")[![aWuttig](https://avatars.githubusercontent.com/u/726519?v=4)](https://github.com/aWuttig "aWuttig (1 commits)") ### Code Quality Static AnalysisPHPStan Code StylePHP CS Fixer Type Coverage Yes ### Embed Badge ![Health badge](/badges/portrino-px-dbsequencer/health.svg) ``` [![Health](https://phpackages.com/badges/portrino-px-dbsequencer/health.svg)](https://phpackages.com/packages/portrino-px-dbsequencer) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter a PHP SQL highlighting library 3.9k115.1M102](/packages/jdorn-sql-formatter)[reliese/laravel Reliese Components for Laravel Framework code generation. 1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application. 7511.7M13](/packages/wildside-userstamps)[usmanhalalit/laracsv A Laravel package to easily generate CSV files from Eloquent model. 6151.7M4](/packages/usmanhalalit-laracsv)[hipsterjazzbo/landlord A simple, single database multi-tenancy solution for Laravel 5.2+ 613270.0k1](/packages/hipsterjazzbo-landlord) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)