PHPackages cubettech/lacassa - 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. cubettech/lacassa ActiveLibrary[Database & ORM](/categories/database) cubettech/lacassa ================= Cassandra based query builder for laravel. v1.1(9y ago)358.5k↓25%19[9 issues](https://github.com/cubettech/lacassa/issues)MITPHP Since Mar 29Pushed 2y ago4 watchersCompare [ Source](https://github.com/cubettech/lacassa)[ Packagist](https://packagist.org/packages/cubettech/lacassa)[ RSS](/packages/cubettech-lacassa/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (2)Dependencies (1)Versions (3)Used By (0) **Lacassa** ----------- [](#lacassa) A Query builder with support for Cassandra, using the original Laravel API. This library extends the original Laravel classes, so it uses exactly the same methods. **Table of contents** --------------------- [](#table-of-contents) - Installation - Configuration - Query Builder - Schema - Extensions - Examples **Installation** ---------------- [](#installation) Make sure you have the DataStax PHP Driver for Apache Cassandra installed. You can find installation instructions at or *datastax php-driver requires php version 5.6+* Installation using composer: ``` composer require cubettech/lacassa ``` And add the service provider in config/app.php: ``` Cubettech\Lacassa\CassandraServiceProvider::class, ``` **Configuration** ----------------- [](#configuration) Change your default database connection name in config/database.php: ``` 'default' => env('DB_CONNECTION', 'cassandra'), ``` And add a new cassandra connection: ``` 'cassandra' => [ 'driver' => 'Cassandra', 'host' => env('DB_HOST', 'localhost'), 'port' => env('DB_PORT', 7199), 'keyspace' => env('DB_DATABASE', 'cassandra_db'), 'username' => env('DB_USERNAME', ''), 'password' => env('DB_PASSWORD', ''), ], ``` ### **Auth** [](#auth) You can use Laravel's native Auth functionality for cassandra, make sure your config/auth.php looks like ``` 'providers' => [ // 'users' => [ // 'driver' => 'eloquent', // 'model' => App\User::class, // ], 'users' => [ 'driver' => 'database', 'table' => 'users', ], ], ``` **Schema** ---------- [](#schema) The database driver also has (limited) schema builder support. You can easily manipulate tables and set indexes: ``` Schema::create( 'users', function ($table) { $table->int('id'); $table->text('name'); $table->text('email'); $table->text('password'); $table->text('remember_token'); $table->setCollection('phn', 'bigint'); $table->listCollection('hobbies', 'text'); $table->mapCollection('friends', 'text', 'text'); $table->primary(['id']); }); ``` DROP table ``` Schema::drop('users'); ``` **CQL data types supported** ============================ [](#cql-data-types-supported) text('a') bigint('b') blob('c') boolean('d') counter('e') decimal('f') double('g') float('h') frozen('i') inet('j') nt('k') listCollection('l', 'text') mapCollection('m', 'timestamp', 'text') setCollection('n', 'int') timestamp('o') timeuuid('p') tuple('q', 'int', 'text', 'timestamp') uuid('r') varchar('s') varint('t') ascii('u') **Primary Key** primary(\['a', 'b'\]) **Query Builder** The database driver plugs right into the original query builder. When using cassandra connections, you will be able to build fluent queries to perform database operations. ``` $emp = DB::table('emp')->get(); $emp = DB::table('emp')->where('emp_name', 'Christy')->first(); ``` If you did not change your default database connection, you will need to specify it when querying. ``` $emp = DB::connection('cassandra')->table('emp')->get(); ``` **Examples** ### **Basic Usage** [](#basic-usage) **Retrieving All Records** ``` $emp = DB::table('emp')->all(); ``` **Indexing columns** CREATE INDEX creates a new index on the given table for the named column. ``` DB::table('users')->index(['name']); ``` **Selecting columns** ``` $emp = DB::table('emp')->where('emp_no', '>', 50)->select('emp_name', 'emp_no')->get(); $emp = DB::table('emp')->where('emp_no', '>', 50)->get(['emp_name', 'emp_no']); ``` **Wheres** The WHERE clause specifies which rows to query. In the WHERE clause, refer to a column using the actual name, not an alias. Columns in the WHERE clause need to meet one of these requirements: - The partition key definition includes the column. - A column that is indexed using CREATE INDEX. ``` $emp = DB::table('emp')->where('emp_no', '>', 50)->take(10)->get(); ``` **And Statements** ``` $emp = DB::table('emp')->where('emp_no', '>', 50)->where('emp_name', '=', 'Christy')->get(); ``` **Using Where In With An Array** ``` $emp = DB::table('emp')->whereIn('emp_no', [12, 17, 21])->get(); ``` **Order By** ORDER BY clauses can select a single column only. Ordering can be done in ascending or descending order, default ascending, and specified with the ASC or DESC keywords. In the ORDER BY clause, refer to a column using the actual name, not the aliases. ``` $emp = DB::table('emp')->where('emp_name','Christy')->orderBy('emp_no', 'desc')->get(); ``` **Limit** We can use limit() and take() for limiting the query. ``` $emp = DB::table('emp')->where('emp_no', '>', 50)->take(10)->get(); $emp = DB::table('emp')->where('emp_no', '>', 50)->limit(10)->get(); ``` **Distinct** Distinct requires a field for which to return the distinct values. ``` $emp = DB::table('emp')->distinct()->get(['emp_id']); ``` Distinct can be combined with **where**: ``` $emp = DB::table('emp')->where('emp_sal', 45000)->distinct()->get(['emp_name']); ``` **Count** ``` $number = DB::table('emp')->count(); ``` Count can be combined with **where**: ``` $sal = DB::table('emp')->where('emp_sal', 45000)->count(); ``` **Truncate** ``` $sal = DB::table('emp')->truncate(); ``` ### **Filtering a collection set, list, or map** [](#filtering-a-collection-set-list-or-map) You can index the collection column, and then use the CONTAINS condition in the WHERE clause to filter the data for a particular value in the collection. ``` $emp = DB::table('emp')->where('emp_name','contains', 'Christy')->get(); ``` After [indexing the collection keys](https://docs.datastax.com/en/cql/3.1/cql/cql_reference/create_index_r.html#reference_ds_eqm_nmd_xj__CreatIdxCollKey) in the venues map, you can filter on map keys. ``` $emp = DB::table(emp')->where('todo','contains key', '2014-10-02 06:30:00+0000')->get(); ``` **Raw Query** The CQL expressions can be injected directly into the query. ``` $emp = DB::raw('select * from emp'); ``` **Inserts, updates and deletes** Inserting, updating and deleting records works just like the original QB. **Insert** ``` DB::table('emp')->insert(['emp_id' => 11, 'emp_city' => '{"kochi", "tvm", "kollam"}', 'emp_name' => 'Christy', 'emp_phone' => 12345676890, 'emp_sal' => 500]); ``` **Updating** To update a model, you may retrieve it, change an attribute, and use the update method. ``` DB::table('emp')->where('emp_id', 11)->update(['emp_city' => 'kochi', 'emp_name' => 'Christy jos', 'emp_phone' => 1234567890]); ``` ### **Updating a collection set, list, and map** [](#updating-a-collection-set-list-and-map) Update collections in a row. The method will be like ``` updateCollection(collection_type, column_name, operator, value); ``` Collection\_type is any of set, list or map. Column\_name is the name of column to be updated. Operator is + or -, + for adding the values to collection and - to remove the value from collection. Value can be associative array for map type and array of string/number for list and set types. ``` DB::table('users')->where('id', 1)->updateCollection('set', 'phn', '+', [123, 1234,12345])->update(); DB::table('users')->where('id', 1)->updateCollection('set', 'phn', '-', [123])->update(); DB::table('users')->where('id', 1)->updateCollection('list', 'hobbies', '+', ['reading', 'cooking', 'cycling'])->update(); DB::table('users')->where('id', 1)->updateCollection('list', 'hobbies', '-', ['cooking'])->update(); DB::table('users')->where('id', 1)->updateCollection('map', 'friends', '+', ['John' => 'Male', 'Rex' => 'Male'])->update(); DB::table('users')->where('id', 1)->updateCollection('map', 'friends', '-', ['John'])->update(); ``` **Deleting** To delete a model, simply call the delete method on the instance. We can delete the rows in a table by using deleteRow method: ``` $emp = DB::table('emp')->where('emp_city', 'Kochi')->deleteRow(); ``` We can also perform delete by the column in a table using deleteColumn method: ``` $emp = DB::table('emp')->where('emp_id', 3)->deleteColumn(); ``` ### Health Score 36 — LowBetter than 82% of packages Maintenance15 Infrequent updates — may be unmaintained Popularity35 Limited adoption so far Community17 Small or concentrated contributor base Maturity64 Established project with proven stability Bus Factor1 Top contributor holds 69.4% 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 ~0 days Total 2 Last Release 3336d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/f38fc74d3e337da7f4cd19e2cd8f5f5347a4c632515ba837fd8a156a72a8eac6?d=identicon)[cubettech](/maintainers/cubettech) --- Top Contributors [![cubetsijoy](https://avatars.githubusercontent.com/u/19144427?v=4)](https://github.com/cubetsijoy "cubetsijoy (25 commits)")[![rennymroy](https://avatars.githubusercontent.com/u/26161767?v=4)](https://github.com/rennymroy "rennymroy (10 commits)")[![cubettech](https://avatars.githubusercontent.com/u/2525619?v=4)](https://github.com/cubettech "cubettech (1 commits)") --- Tags laraveldatabasenosqlquery buildercassandracqllacassa ### Embed Badge ![Health badge](/badges/cubettech-lacassa/health.svg) ``` [![Health](https://phpackages.com/badges/cubettech-lacassa/health.svg)](https://phpackages.com/packages/cubettech-lacassa) ``` ### Alternatives [datastax/php-driver DataStax PHP Driver for Apache Cassandra 437521.5k19](/packages/datastax-php-driver)[mroosz/php-cassandra A pure-PHP client for Apache Cassandra and ScyllaDB with support for CQL binary protocol v3, v4 and v5 (Cassandra 2.1+ incl. 3.x-5.x; ScyllaDB 6.2 and 2025.x), synchronous and asynchronous APIs, prepared statements, batches, result iterators, object mapping, SSL/TLS, and LZ4 compression. 205.6k2](/packages/mroosz-php-cassandra)[wayofdev/laravel-cycle-orm-adapter 🔥 A Laravel adapter for CycleORM, providing seamless integration of the Cycle DataMapper ORM for advanced database handling and object mapping in PHP applications. 3516.7k3](/packages/wayofdev-laravel-cycle-orm-adapter)[soosyze/queryflatfile The Queryflatfile is PHP library for simple database not SQL 181.0k1](/packages/soosyze-queryflatfile) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)