Download the PHP package codemonster-ru/database without Composer

codemonster-ru/database

A lightweight, framework-agnostic database layer for PHP.
Part of the Codemonster ecosystem — but works fully standalone.

Installation

Usage

1. Database Manager

You can define multiple connections and select them by name:

• For MySQL/MariaDB use driver => 'mysql'.
• For SQLite use driver => 'sqlite' and only database is required (file path or :memory:).
• Other PDO drivers can be wired via driver + DSN-compatible options; the query layer is driver-agnostic, while the schema builder is primarily tuned for MySQL-like syntax and SQLite.

2. Query Builder

SELECT

SELECT with aliases

INSERT

UPDATE

DELETE

Debug SQL

Raw expressions

Join support

Group By / Having

Aggregates

Exists

Value / Pluck

Value / Pluck with aliases

Pagination

Empty whereIn / whereNotIn

Available behaviors:

• EMPTY_CONDITION_NONE (default for whereIn) -> executes 0 = 1
• EMPTY_CONDITION_ALL (default for whereNotIn) -> executes 1 = 1
• EMPTY_CONDITION_EXCEPTION -> throws InvalidArgumentException

You can override whereNotIn separately:

3. Transactions

4. Global Helpers (with codemonster-ru/support)

If you also install codemonster-ru/support and register bindings in your container, you can use global helpers:

Helpers are thin wrappers around DatabaseManager and the connection’s schema() / transaction() methods.

Schema Builder

The package includes a lightweight schema builder.

Note: The schema grammar is focused on MySQL/MariaDB and SQLite.
For other PDO drivers, the query builder will work, but schema operations may not be fully supported.

Creating a table

Modifying a table

SQLite notes

• SQLite supports ALTER TABLE only for a subset of operations; some drop operations are ignored.
• Foreign keys are emitted inline during CREATE TABLE.

Dropping a table

Supported Column Types

• Integers: id, integer, bigInteger, mediumInteger, smallInteger, tinyInteger
• Floats: decimal, double, float
• Text: string, char, text, mediumText, longText
• Boolean: boolean
• JSON: json
• Dates & time: date, datetime, timestamp, time, year
• UUID: uuid
• Indexes: index, unique, primary
• Foreign keys with foreign() / references() / on() and onDelete() / onUpdate() helpers

Migrations

The package includes a migration system (designed to be used via the CLI).

• migrate
• migrate:rollback
• migrate:status
• make:migration
• seed
• make:seed

Example migration

Seeders

The package includes a lightweight seeding system (via the CLI).

Example seeder

ORM (ActiveRecord / Eloquent‑style)

Since 1.3.0, the package includes a complete ORM layer:

• Model
• ModelQuery
• ModelCollection
• Lazy & eager loading
• $fillable, $guarded, $hidden
• Attribute casting (int, json, datetime, etc.)
• created_at / updated_at
• SoftDeletes

Example model

Fetching models

Creating / updating / deleting

Relationships

Available relations:

• HasOne
• HasMany
• BelongsTo
• BelongsToMany

Example

Lazy loading

Eager loading

Soft Deletes

• $user->delete() → sets deleted_at
• $user->restore()
• User::onlyTrashed()
• User::withTrashed()

CLI Tool

A standalone CLI ships with the package:

Running migrations

Rollback

Status

Wipe database

Force wipe without confirmation:

Clean database data (keep migrations table)

Force clean without confirmation:

Create a migration

Migration names must be CamelCase using only Latin letters (e.g., CreateUsersTable). Names that include other symbols or casing styles are rejected.

Default migrations directory:

You can override paths via the migration kernel/path resolver:

Running seeders

Create a seeder

Seed names must be CamelCase using only Latin letters (e.g., UsersSeeder). Names that include other symbols or casing styles are rejected.

Default seeds directory:

You can override paths via the seed kernel/path resolver:

Tests

Author

Kirill Kolesnikov

License

MIT