PHPackages                             fereydooni/unixtime - 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. fereydooni/unixtime

ActiveLibrary[Utility & Helpers](/categories/utility)

fereydooni/unixtime
===================

a Laravel package that automatically adds UNIX timestamp equivalents

1.0.3(5mo ago)025MITPHP

Since Nov 11Pushed 5mo agoCompare

[ Source](https://github.com/Behnamfe76/laravel-unixtime)[ Packagist](https://packagist.org/packages/fereydooni/unixtime)[ RSS](/packages/fereydooni-unixtime/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (1)DependenciesVersions (5)Used By (0)

Laravel UnixTime
================

[](#laravel-unixtime)

Automatically keep Unix timestamp mirrors (e.g. `created_at_unix`) for every datetime column in your Laravel models. The package detects relevant columns, creates the `_unix` columns for you, keeps them in sync any time the model is saved/retrieved, and even rewrites `orderBy`, `latest`, and `oldest` calls so they transparently use the faster integer columns.

> Why it exists: while building large datasets I found the ORM constantly ordering and filtering on datetime columns, which meant string comparisons or expensive casting. Integer indexes (`*_unix`) make those same range/ordering queries consistently faster, so this package automates the boring part—adding, filling, and maintaining the mirrored integer fields.

Features
--------

[](#features)

- 🔁 Keeps Unix timestamp equivalents in sync for all datetime/timestamp/date columns.
- ⚙️ Artisan command that scans your app, adds the missing `_unix` columns, and can backfill legacy data.
- 🧱 Schema Builder macros to add/drop Unix columns directly in migrations.
- 🔍 Smart auto-detection of datetime fields from the schema (casts are only a fallback).
- 🎛️ Per-model configuration for suffixes, explicit include/exclude lists, and helper methods like `getUnixTimestamp()`.

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

[](#installation)

```
composer require fereydooni/unixtime
```

The service provider is auto-discovered, so no manual registration is required.

Quick Start
-----------

[](#quick-start)

1. **Use the trait on your model**

    ```
    use Fereydooni\Unixtime\HasTimestampEquivalents;

    class Customer extends Model
    {
        use HasTimestampEquivalents;
    }
    ```
2. **Add the Unix columns**

    - **Existing tables:** run the sync command (see below).
    - **New migrations:** call `$table->timestampEquivalents();` at the end of the migration.
3. **Enjoy the new attributes**

    ```
    $customer = Customer::find(1);
    echo $customer->created_at_unix;        // 1731341349
    echo $customer->last_order_date_unix;   // Also managed automatically
    ```

Adding Columns for Existing Tables
----------------------------------

[](#adding-columns-for-existing-tables)

Use the included Artisan command to scan all models that use the trait and create any missing `_unix` columns.

```
php artisan timestamp-equivalents:sync
```

Common options:

OptionDescription`--model="App\\Models\\Customer"`Limit the sync to one or more fully-qualified models (option may be repeated).`--dry-run`Show the pending changes without touching the database.`--backfill`After adding the columns, backfill existing rows using the database’s native Unix conversion functions.Example (specific model with backfill):

```
php artisan timestamp-equivalents:sync --model="App\\Models\\Customer" --backfill
```

Adding Columns in New Migrations
--------------------------------

[](#adding-columns-in-new-migrations)

The service provider registers Schema Builder macros so you can add Unix columns directly in migrations.

```
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

Schema::create('orders', function (Blueprint $table) {
    $table->timestamp('confirmed_at')->nullable();
    $table->timestamps();
    $table->softDeletes();

    // Adds confirmed_at_unix, created_at_unix, updated_at_unix, deleted_at_unix
    $table->timestampEquivalents();
});
```

Need only one column?

```
$table->timestamp('verified_at')->nullable();
$table->timestampEquivalent('verified_at'); // Adds verified_at_unix (nullable, indexed)
```

Cleanup helper:

```
$table->dropTimestampEquivalents(['verified_at', 'created_at']);
```

Model Configuration
-------------------

[](#model-configuration)

Everything works out-of-the-box, but you can fine-tune behavior with optional properties:

```
class Customer extends Model
{
    use HasTimestampEquivalents;

    // Only manage these columns (otherwise they are auto-discovered from the DB)
    protected $timestampEquivalentColumns = ['created_at', 'last_order_date'];

    // Skip columns even if they look like datetimes
    protected $excludedTimestampColumns = ['date_of_birth'];

    // Customize suffix (default: '_unix')
    protected $timestampColumnSuffix = '_timestamp';
}
```

Helper methods:

```
$customer->getUnixTimestamp('created_at'); // => 1731341349
$customer->hasTimestampColumn('created_at_unix'); // true/false
```

Query Builder Enhancements
--------------------------

[](#query-builder-enhancements)

The trait swaps in a custom Eloquent builder so ordering helpers automatically use the `_unix` columns whenever they exist. This keeps your queries fast without changing call sites.

```
// Uses created_at_unix behind the scenes
Customer::latest()->take(50)->get();

// orderByDesc('shipped_at') becomes shipped_at_unix when available
Order::orderByDesc('shipped_at')->paginate();
```

Testing
-------

[](#testing)

Run the package test suite from your app:

```
php artisan test --filter=HasTimestampEquivalentsTest
```

License
-------

[](#license)

The Laravel UnixTime package is open-sourced software licensed under the [MIT license](LICENSE).

###  Health Score

32

—

LowBetter than 72% of packages

Maintenance71

Regular maintenance activity

Popularity6

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity38

Early-stage or recently created project

 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

Every ~4 days

Total

4

Last Release

175d ago

### Community

Maintainers

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

---

Top Contributors

[![Behnamfe76](https://avatars.githubusercontent.com/u/101217538?v=4)](https://github.com/Behnamfe76 "Behnamfe76 (13 commits)")

### Embed Badge

![Health badge](/badges/fereydooni-unixtime/health.svg)

```
[![Health](https://phpackages.com/badges/fereydooni-unixtime/health.svg)](https://phpackages.com/packages/fereydooni-unixtime)
```

###  Alternatives

[rehankanak/laravel-notion-renderer

Laravel Package for Converting Notion Pages to Web Pages

164.5k](/packages/rehankanak-laravel-notion-renderer)

PHPackages © 2026

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