PHPackages keboola/db-extractor-common - 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. [Utility & Helpers](/categories/utility) 4. / 5. keboola/db-extractor-common ActiveLibrary[Utility & Helpers](/categories/utility) keboola/db-extractor-common =========================== Common library from Keboola Database Extractors 17.2.3(3mo ago)012.8k↑22.2%[17 issues](https://github.com/keboola/db-extractor-common/issues)MITPHPPHP >=8.2CI passing Since Feb 11Pushed 3mo ago16 watchersCompare [ Source](https://github.com/keboola/db-extractor-common)[ Packagist](https://packagist.org/packages/keboola/db-extractor-common)[ RSS](/packages/keboola-db-extractor-common/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (10)Dependencies (24)Versions (155)Used By (0) Database Extractor Common \[DBC\] ================================= [](#database-extractor-common-dbc) --- Common classes for creating vendor specific database extractors. Extractors using DBC -------------------- [](#extractors-using-dbc) - [MySQL](https://github.com/keboola/db-extractor-mysql) - [MSSQL](https://github.com/keboola/db-extractor-mssql) - [PgSQL](https://github.com/keboola/db-extractor-pgsql) - [Oracle](https://github.com/keboola/db-extractor-oracle) (private repository) - [Impala](https://github.com/keboola/db-extractor-impala) - [Firebird](https://github.com/keboola/db-extractor-firebird) - [DB2](https://github.com/keboola/db-extractor-db2) - [Redshift](https://github.com/keboola/db-extractor-redshift) - [Snowflake](https://github.com/keboola/db-extractor-snowflake) Development and running tests ----------------------------- [](#development-and-running-tests) ``` docker compose build docker compose run --rm tests # runs the tests ``` Usage ----- [](#usage) Add the library to your component's composer: ``` php composer.phar require db-extractor-common ``` composer.json ``` { "require": "db-extractor-common": ^8.0 } ``` Usage ----- [](#usage-1) Create entrypoint script file `run.php` like this one for Mysql extractor: Note that as of version 7, configuration rows are supported so it is not necessary to support .yml configs or table array configurations. The $config is loaded from the `config.json` file. You have to provide values for the `data_dir` and `extractor_class` keys. `extractor_class` is the main class of derived extractor, it should extend `Keboola\DbExtractor\Extractor\Extractor`. You will need to implement the following methods: - `createConnection(array $params)` - `testConnection()` - `simpleQuery(array $table, array $columns = array()): string` - `getTables(?array $tables = null): array;` Note that to support identifier sanitation, the getTables method should return a `sanitizedName` property for each column. This `sanitizedName` should be created using `Keboola\php-utils\sanitizeColumnName` If you want to implement incremental fetching, you must implement `validateIncrementalFetching(array $table, string $columnName, ?int $limit = null): void` Please see the sample in the `Common` class: The namespace of your extractor class shoud be `Keboola\DbExtractor\Extractor` and the name of the class should corespond to DB vendor name i.e. PgSQL, Oracle, Impala, Firebrid, DB2 and so on. Please check the existing implementations above for help getting started. Check username -------------- [](#check-username) Check username functionality compares - value of the `KBC_REALUSER` environment variable - and username of the database user from the configuration. If enabled, values must be same to run the component. If a service account is used, check is skipped. For more information see `UsernameChecker` class. **Example image / stack parameters** ``` { "checkUsername": { "enabled": true } } ``` Service account can be defined by regular expression: ``` { "checkUsername": { "enabled": true, "serviceAccountRegexp": "~^service_~i" } } ``` Or user account can be defined by regular expression (inverted logic): ``` { "checkUsername": { "enabled": true, "userAccountRegexp": "~^[0-9]{3}_" } } ``` License ------- [](#license) MIT licensed, see [LICENSE](./LICENSE) file. ### Health Score 58 — FairBetter than 98% of packages Maintenance79 Regular maintenance activity Popularity24 Limited adoption so far Community21 Small or concentrated contributor base Maturity94 Battle-tested with a long release history Bus Factor2 2 contributors hold 50%+ of commits 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 ~26 days Recently: every ~104 days Total 141 Last Release 113d ago Major Versions 12.2.0 → 13.0.02020-04-23 13.3.0 → 14.0.02020-08-14 14.6.0 → 15.0.02021-12-13 15.0.1 → 16.0.02022-08-05 16.2.2 → 17.0.02024-06-05 PHP version history (5 changes)0.0.1PHP >=5.6 9.0.0PHP >=7.1 13.0.0PHP >=7.4 16.2.0PHP >=8.1 16.2.1PHP >=8.2 ### Community Maintainers ![](https://www.gravatar.com/avatar/101dbf2551a0709ddab522f97669f13a2c4cc2d0a1e8d009f3af6ba80accb1a9?d=identicon)[Keboola](/maintainers/Keboola) --- Top Contributors [![pivnicek](https://avatars.githubusercontent.com/u/569139?v=4)](https://github.com/pivnicek "pivnicek (276 commits)")[![ondrajodas](https://avatars.githubusercontent.com/u/12143866?v=4)](https://github.com/ondrajodas "ondrajodas (164 commits)")[![MiroCillik](https://avatars.githubusercontent.com/u/1488015?v=4)](https://github.com/MiroCillik "MiroCillik (99 commits)")[![michaljurecko](https://avatars.githubusercontent.com/u/19371734?v=4)](https://github.com/michaljurecko "michaljurecko (75 commits)")[![AdamVyborny](https://avatars.githubusercontent.com/u/27994036?v=4)](https://github.com/AdamVyborny "AdamVyborny (43 commits)")[![odinuv](https://avatars.githubusercontent.com/u/4319320?v=4)](https://github.com/odinuv "odinuv (32 commits)")[![Actimel](https://avatars.githubusercontent.com/u/4041679?v=4)](https://github.com/Actimel "Actimel (13 commits)")[![romantmb](https://avatars.githubusercontent.com/u/228957?v=4)](https://github.com/romantmb "romantmb (7 commits)")[![tomasfejfar](https://avatars.githubusercontent.com/u/642928?v=4)](https://github.com/tomasfejfar "tomasfejfar (7 commits)")[![ujovlado](https://avatars.githubusercontent.com/u/419849?v=4)](https://github.com/ujovlado "ujovlado (6 commits)")[![Halama](https://avatars.githubusercontent.com/u/903531?v=4)](https://github.com/Halama "Halama (5 commits)")[![kacurez](https://avatars.githubusercontent.com/u/1412120?v=4)](https://github.com/kacurez "kacurez (4 commits)")[![ErikZigo](https://avatars.githubusercontent.com/u/1726727?v=4)](https://github.com/ErikZigo "ErikZigo (2 commits)")[![ondrejhlavacek](https://avatars.githubusercontent.com/u/497675?v=4)](https://github.com/ondrejhlavacek "ondrejhlavacek (1 commits)")[![sykora-ji](https://avatars.githubusercontent.com/u/29491790?v=4)](https://github.com/sykora-ji "sykora-ji (1 commits)") ### Code Quality Static AnalysisPHPStan Type Coverage Yes ### Embed Badge ![Health badge](/badges/keboola-db-extractor-common/health.svg) ``` [![Health](https://phpackages.com/badges/keboola-db-extractor-common/health.svg)](https://phpackages.com/packages/keboola-db-extractor-common) ``` ### Alternatives [jaxon-php/jaxon-core Jaxon is an open source PHP library for easily creating Ajax web applications 73142.3k25](/packages/jaxon-php-jaxon-core)[aedart/athenaeum Athenaeum is a mono repository; a collection of various PHP packages 245.2k](/packages/aedart-athenaeum) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)