PHPackages                             danidoble/database - 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. danidoble/database

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

danidoble/database
==================

ORM mysql mariadb Database

v1.0.1(4y ago)027MITPHPPHP ^8.0

Since Apr 13Pushed 2mo ago1 watchersCompare

[ Source](https://github.com/danidoble/database)[ Packagist](https://packagist.org/packages/danidoble/database)[ Docs](https://github.com/danidoble/database)[ RSS](/packages/danidoble-database/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (3)Versions (5)Used By (0)

database
========

[](#database)

Mini ORM

installation
------------

[](#installation)

```
composer require danidoble/database

```

or

```
composer.phar require danidoble/database

```

Configuration
-------------

[](#configuration)

If you use a loader of credentials like `vlucas/phpdotenv` add inside of file `.env` add this credentials

- `DB_NAME="YOUR_DB_NAME"`
- `DB_USER="YOUR_DB_USER"`
- `DB_HOST="YOUR_DB_HOST"`
- `DB_PASS="YOUR_DB_PASS"`

If you don't use libraries to load credentials you can add in your code ` NOT RECOMMENDED`

- `$_ENV['DB_NAME']="YOUR_DB_NAME";`
- `$_ENV['DB_USER']="YOUR_DB_USER";`
- `$_ENV['DB_HOST']="YOUR_DB_HOST";`
- `$_ENV['DB_PASS']="YOUR_DB_PASS";`

How to use
----------

[](#how-to-use)

You can configurate name of id doing: `Sql::from('users')->id('name_id')`

### GET

[](#get)

To get all data

```
use Danidoble\Database\Sql;

$users = Sql::from('users')->get();

var_dump($users);
```

To paginate data

```
use Danidoble\Database\Sql;

$users = Sql::from('users')->get();

var_dump($users);
```

Get only one

```
use Danidoble\Database\Sql;

$user = Sql::from('users')->first();

var_dump($user);
```

Get only selected by id

```
use Danidoble\Database\Sql;

$user = Sql::from('users')->find(1);

var_dump($user);
```

### INSERT

[](#insert)

```
use Danidoble\Database\Sql;

$user = new Sql();
$user->name = "Gregory";
$user->last_name = "Hui";
$user->save();
```

### UPDATE

[](#update)

update after get

```
use Danidoble\Database\Sql;

$user = Sql::from('users')->id('name_id')->find(1);
$user->name = "somthing else";
$user->save();
```

update without get

```
use Danidoble\Database\Sql;

$user = Sql::from('users')
    ->set('name','Pedro')
    ->set('last_name','Crox')
    ->where('name','Gregory','=')
    ->update();
```

### DELETE

[](#delete)

soft delete (needed field `deleted_at` in database) otherwise is deleted

```
use Danidoble\Database\Sql;

$user = Sql::from('users')->find(1);
$user->delete();
```

hard delete

```
use Danidoble\Database\Sql;

$user = Sql::from('users')->find(1);
$user->forceDelete();
```

###  Health Score

34

—

LowBetter than 77% of packages

Maintenance56

Moderate activity, may be stable

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity56

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

Every ~0 days

Total

4

Last Release

1494d ago

Major Versions

v0.x-dev → v1.x-dev2022-04-13

PHP version history (2 changes)v1.0.1PHP ^8.0

v0.0.2PHP ^7.3|^7.4

### Community

Maintainers

![](https://www.gravatar.com/avatar/2215f99c2b8dd234059f7658a737822ef9a79850dd0babf44658625f694ca086?d=identicon)[danidoble](/maintainers/danidoble)

---

Top Contributors

[![danidoble](https://avatars.githubusercontent.com/u/20725260?v=4)](https://github.com/danidoble "danidoble (9 commits)")

---

Tags

databaseormmysqlmariadbdanidoble

### Embed Badge

![Health badge](/badges/danidoble-database/health.svg)

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

###  Alternatives

[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58523.9M36](/packages/scienta-doctrine-json-functions)[longitude-one/doctrine-spatial

Doctrine multi-platform support for spatial types and functions, compliant with Doctrine 2.19, 3.1, and dev ones (3.2 and 4.0).

891.4M1](/packages/longitude-one-doctrine-spatial)[tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.

845.7k](/packages/tommyknocker-pdo-database-class)[ramadan/easy-model

A Laravel package for enjoyably managing database queries.

101.6k](/packages/ramadan-easy-model)

PHPackages © 2026

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