PHPackages                             rdr/snowflakejodo - 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. rdr/snowflakejodo

ActiveLibrary[Database & ORM](/categories/database)

rdr/snowflakejodo
=================

SnowflakeJodo: A Snowflake wrapper for Laravel, designed to optimize connection times within Laravel applications.

0532↓50%PHP

Since Jun 12Pushed 1y ago1 watchersCompare

[ Source](https://github.com/dhirajlochib/SnowflakeJodo)[ Packagist](https://packagist.org/packages/rdr/snowflakejodo)[ RSS](/packages/rdr-snowflakejodo/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

SnowflakeJodo - A Laravel Bridge to Snowflake
=============================================

[](#snowflakejodo---a-laravel-bridge-to-snowflake)

[![Latest Version on Packagist](https://camo.githubusercontent.com/1560ca6611400a8ab7f31a4b4a535b21a4550bb5e9e16f20853ecb5860c241c2/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f7264722f736e6f77666c616b656a6f646f2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/rdr/snowflakejodo)[![Total Downloads](https://camo.githubusercontent.com/7e03f51ee3df40f21a0da34321a1da54728c8dc5b45d45f4c9d22d994f504efb/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f7264722f736e6f77666c616b656a6f646f2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/rdr/snowflakejodo)[![License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)

SnowflakeJodo provides a convenient way to integrate your Laravel application with a Snowflake data warehouse via a dedicated Node.js API. It simplifies data retrieval and reduces connection overhead common in direct Snowflake interactions.

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

[](#installation)

1. **Require the Package:** Use Composer to install the package in your Laravel project:

    ```
    composer require rdr/snowflakejodo
    ```

    This will install the package and its dependencies.
2. **Publish Configuration:** Publish the package configuration file:

    ```
    php artisan vendor:publish --tag=snowflakejodo-config
    ```

    This will create a `config/snowflakejodo.php` file in your project.
3. **Configure API URL:** Update the `api_url` value in your `.env` file to point to your running Node.js API endpoint:

    ```
    SNOWFLAKE_JODO_API_URL=http://localhost:3001
    ```

    Replace `http://localhost:3001` with the actual URL of your API.
4. **Create and Run Node.js API:** Set up and run a separate Node.js API that handles the direct communication with Snowflake. Make sure the API is running and accessible at the URL you configured in `.env`.

Usage
-----

[](#usage)

### Establish a Connection

[](#establish-a-connection)

Create an instance of SnowflakeJodo using the `connect()` method:

```
use Rdr\SnowflakeJodo\SnowflakeJodo;

// In a controller:
class MyController extends Controller
{
    protected $snowflake;

    public function __construct()
    {
        $this->snowflake = SnowflakeJodo::connect();
    }

    // ... your controller methods ...
}
```

### Execute Queries

[](#execute-queries)

Use the `query()` method on the connection object to run Snowflake SQL queries:

```
$results = $this->snowflake->query("SELECT * FROM users WHERE id = ?", [1]);
```

### Error Handling

[](#error-handling)

SnowflakeJodo throws a `Rdr\SnowflakeJodo\Exceptions\SnowflakeConnectionException` if there are errors connecting to your API or if the API returns an error from Snowflake. Handle this exception gracefully in your application.

### Security

[](#security)

- Securely Configure Node.js API: Follow security best practices when configuring and deploying the API, such as using environment variables to store credentials.
- API Authentication (Optional): Enhance security by implementing an authentication mechanism between your Laravel application and the Node.js API (e.g., API keys, JWTs).

Contributing
------------

[](#contributing)

Thank you for considering contributing to SnowflakeJodo! Please read the [Contribution Guide](CONTRIBUTING.md) before submitting a pull request.

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

---

**Dhiraj Lochib**

- GitHub: [@dhirajlochib](https://github.com/dhirajlochib)

###  Health Score

18

—

LowBetter than 8% of packages

Maintenance26

Infrequent updates — may be unmaintained

Popularity16

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity18

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.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/83211536?v=4)[Dhiraj Lochib](/maintainers/dhirajlochib)[@dhirajlochib](https://github.com/dhirajlochib)

---

Top Contributors

[![dhirajlochib](https://avatars.githubusercontent.com/u/83211536?v=4)](https://github.com/dhirajlochib "dhirajlochib (19 commits)")

### Embed Badge

![Health badge](/badges/rdr-snowflakejodo/health.svg)

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

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90440.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps

Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application.

7511.7M13](/packages/wildside-userstamps)

PHPackages © 2026

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