PHPackages                             keygenqt/yii2-vertica - 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. [Search & Filtering](/categories/search)
4. /
5. keygenqt/yii2-vertica

ActiveYii2-extension[Search & Filtering](/categories/search)

keygenqt/yii2-vertica
=====================

Vertica integration and ActiveRecord for the Yii framework

1.0.0(5y ago)57.4k10Apache-2.0PHPPHP >=5.4.0

Since May 28Pushed 3y ago1 watchersCompare

[ Source](https://github.com/keygenqt/Vertica)[ Packagist](https://packagist.org/packages/keygenqt/yii2-vertica)[ RSS](/packages/keygenqt-yii2-vertica/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependencies (1)Versions (2)Used By (0)

Vertica Query and ActiveRecord for Yii 2
========================================

[](#vertica-query-and-activerecord-for-yii-2)

[![GitHub](https://camo.githubusercontent.com/da49a78e76ee797560b74a5c0c480057a62c9b6eff400f315209c552607cc88d/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f6b657967656e71742f796969322d76657274696361)](https://camo.githubusercontent.com/da49a78e76ee797560b74a5c0c480057a62c9b6eff400f315209c552607cc88d/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f6b657967656e71742f796969322d76657274696361)[![Packagist Downloads](https://camo.githubusercontent.com/0a946d06b9a78ef51434875d1748a276dda83e29bf69b7b50d81dadb221594ca/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6b657967656e71742f796969322d76657274696361)](https://camo.githubusercontent.com/0a946d06b9a78ef51434875d1748a276dda83e29bf69b7b50d81dadb221594ca/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6b657967656e71742f796969322d76657274696361)

This extension provides the [vertica](https://my.vertica.com/vertica-documentation/) integration for the Yii2 framework. It includes basic querying/search support and also implements the `ActiveRecord` pattern that allows you to store active records in vertica.

Powered by odbc\_connect();

To use this extension, you have to configure the Connection class in your application configuration:

```
return [
    //....
    'components' => [
        'vertica' => [
            'class' => 'yii\vertica\Connection',
            'dsn' => 'Driver=Vertica;Server=localhost;Database=my-database;',
            'username' => 'dbadmin',
            'password' => 'password-base',
        ],
    ]
];
```

and console.php for migrate

```
return [
    'controllerMap' => [
        'migrate-vertica' => 'yii\vertica\controllers\MigrateVerticaController',
    ],
];
```

Requirements
------------

[](#requirements)

Performance tested on version 7.1.2

Installation
------------

[](#installation)

The preferred way to install this extension is through [composer](http://getcomposer.org/download/).

Either add

```
{
    "require": {
        "keygenqt/yii2-vertica": "*",
    }
}
```

to the require section of your composer.json.

Using the ActiveRecord
----------------------

[](#using-the-activerecord)

The following is an example model called `Admins`:

```
namespace app\models;

use \yii\data\ActiveDataProvider;
use \yii\vertica\ActiveRecord;

class Admins extends ActiveRecord
{
    public static function tableName()
    {
        return 'admins';
    }

    /**
    * @return array validation rules for model attributes.
    */
    public function rules()
    {
        return [
            [['username', 'password_hash', 'blocked_at', 'role', 'created_at', 'updated_at'], 'safe']
        ];
    }

    //...

    public function search($params)
    {
        $query = Admins::find();
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

        if (!($this->load($params) && $this->validate())) {
            return $dataProvider;
        }

        $query->andFilterWhere(['like', 'username', $this->username]);
        $query->andFilterWhere(['like', 'password_hash', $this->password_hash]);
        $query->andFilterWhere(['=', 'created_at', $this->created_at]);
        $query->andFilterWhere(['=', 'updated_at', $this->updated_at]);

        return $dataProvider;
    }
}
```

###  Health Score

29

—

LowBetter than 60% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity26

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity50

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% 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

Unknown

Total

1

Last Release

2175d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/caeb1b1bfd81d9317b8317e13ff3bb8e89189e97efb42aa73a3af10f17878605?d=identicon)[keygenqt](/maintainers/keygenqt)

---

Top Contributors

[![keygenqt](https://avatars.githubusercontent.com/u/9665914?v=4)](https://github.com/keygenqt "keygenqt (24 commits)")

---

Tags

extensionsyii2searchyii2active-recordfulltextvertica

### Embed Badge

![Health badge](/badges/keygenqt-yii2-vertica/health.svg)

```
[![Health](https://phpackages.com/badges/keygenqt-yii2-vertica/health.svg)](https://phpackages.com/packages/keygenqt-yii2-vertica)
```

###  Alternatives

[yiisoft/yii2-elasticsearch

Elasticsearch integration and ActiveRecord for the Yii framework

4371.9M15](/packages/yiisoft-yii2-elasticsearch)[yiisoft/yii2-sphinx

Sphinx full text search engine extension for the Yii framework

180997.7k5](/packages/yiisoft-yii2-sphinx)[vintage/yii2-search

Search in Active Record models for Yii2

294.6k](/packages/vintage-yii2-search)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)