Laravel Packages

Laravel DynamoDB Eloquent Models and Query Builder

Published
Laravel DynamoDB Eloquent Models and Query Builder image

Laravel DynamoDB is a DynamoDB-based Eloquent model and Query builder for Laravel. Using the provided Dynamo driver, models extend the Eloquent base model:

use Kitar\Dynamodb\Model\Model;

class ProductCatalog extends Model
{
    // Required
    protected $table = 'ProductCatalog';

    // Name of the partition key (required)
    protected $primaryKey = 'Id';

    // Name of the sort key (optional)
    protected $sortKey = 'Subject';

    // Default sort key value when we
    // call find without a sort key.
    protected $sortKeyDefault = 'profile';

    protected $fillable = ['Id', 'Price', 'Title'];
}

Here are a few examples from the readme of queries and operations you can expect using this package:

// Get all models
$products = ProductCatalog::scan();
// or
$products = ProductCatalog::all();

// Paginated
$products = ProductCatalog::limit(5)->scan();

// Creating a user
$user = User::create([
    'email' => 'foo@bar.com',
    // Sort key. If we don't specify this,
    // sortKeyDefault will be used.
    'type' => 'profile',
]);

// Instantiate a model and then save.
$user = new User([
    'email' => 'foo@bar.com',
    'type' => 'profile'
]);

$user->save();

// Update an existing model
$user->update([
    'name' => 'foobar'
]);

This package includes more advanced usage of Dynamo, including a query builder that you can use without models (and outside of Laravel too). Also, the query builder supports things such as Condition Expressions. For example:

DB::table('ProductCatalog')
    ->condition('Id', 'attribute_not_exists')
    ->orCondition('Price', 'attribute_not_exists')
    ->putItem([/*...*/]);

Here's an example of filter expressions, which can filter results with expressions before results are returned from the database:

$response = DB::table('Thread')
    ->filter('LastPostedBy', '=', 'User A')
    ->scan();

// orFilter()
$response = DB::table('Thread')
    ->filter('LastPostedBy', '=', 'User A')
    ->orFilter('LastPostedBy', '=', 'User B')
    ->scan();

// filterIn
$response = DB::table('Thread')
    ->filterIn('LastPostedBy', ['User A', 'User B'])
    ->scan();

// filterBetween
$response = DB::table('ProductCatalog')
    ->filterBetween('Price', [0, 100])
    ->scan();

The Laravel DynamoDB package also has detailed instructions on using a DynamoDB model for user authentication. You can learn more about this package, get full installation instructions, and view the source code on GitHub.


This package was submitted to our Laravel News Links section. Links is a place the community can post packages and tutorials around the Laravel ecosystem. Follow along on Twitter @LaravelLinks

Paul Redmond photo

Staff writer at Laravel News. Full stack web developer and author.

Sponsored

laravelcloud logo
Laravel Cloud

Easily create and manage your servers and deploy your Laravel applications in seconds.

Visit Laravel Cloud

The latest

View all →
Laravel AI SDK 1.4 Lets Agents Recover From Tool Failures image

Laravel AI SDK 1.4 Lets Agents Recover From Tool Failures

Read article
Laravel Read Replicas: Check if a Replica Has Caught Up image

Laravel Read Replicas: Check if a Replica Has Caught Up

Read article
UUID Request Input and Migration Failure Events in Laravel 13.42 image

UUID Request Input and Migration Failure Events in Laravel 13.42

Read article
Replay Missed Laravel Scheduled Tasks With Schedule Catchup image

Replay Missed Laravel Scheduled Tasks With Schedule Catchup

Read article
Search Polymorphic Relations and Filament Tables With Laravel Searchable image

Search Polymorphic Relations and Filament Tables With Laravel Searchable

Read article
Laravel Rest Api 3.0: Typed Fields, Metrics, and OpenAPI Docs image

Laravel Rest Api 3.0: Typed Fields, Metrics, and OpenAPI Docs

Read article