tueen / database

v1.0.0-alpha.1 2026-10-10 22:31 UTC

Requires

• php: >=8.4
• ext-json: *
• ext-pdo: *
• doctrine/dbal: ^4.0
• doctrine/migrations: ^3.8
• doctrine/orm: ^3.0
• psr/simple-cache: ^3.0
• symfony/cache: ^7.0 || ^8.0
• symfony/console: ^7.0 || ^8.0
• symfony/dependency-injection: ^7.0 || ^8.0
• symfony/dotenv: ^7.0 || ^8.0
• symfony/event-dispatcher: ^7.0 || ^8.0
• symfony/password-hasher: ^7.0 || ^8.0
• symfony/security-core: ^7.0 || ^8.0
• symfony/serializer: ^7.0 || ^8.0
• symfony/uid: ^7.0 || ^8.0
• symfony/validator: ^7.0 || ^8.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.60
• phpstan/phpstan: ^2.0
• phpunit/phpunit: ^11.0
• rector/rector: ^2.0

MIT

• Tueen Ecosystem Team

• database
• orm
• dbal
• migrations
• doctrine
• bot
• telegram
• php84
• zero-config
• tueen

Published on Packagist.org on 2026-10-10 22:53 UTC

README

Tueen Database 👑

The Zero-Config, High-Throughput Relational Engine for Modern Telegram Bots
Part of the Tueen ecosystem — "The Queen of Telegram"

Tueen Database is an enterprise-grade, zero-config relational database layer crafted specifically for high-throughput Telegram bots. Built on PHP 8.4+ and Doctrine ORM 3, it works seamlessly both inside the Tueen Bot Framework and as a high-performance standalone library.

⚡ Highlights

• 🚀 Declarative Zero-Config Schema Synchronization: Automatic lazy schema diff synchronization on boot — no manual CLI migrations required!
• 🪝 Modern PHP 8.4 Architecture: Property hooks, asymmetric visibility (public private(set)), native lazy objects, and backed enums.
• 💬 Telegram-Native Domain: Built-in models for chats (64-bit signed IDs), users, channels, groups, messages, contacts, and bridging relays.
• 💳 Multi-Currency Ledger & Billing: Arbitrary-precision wallets (TON, Stars, USDT, fiat), double-entry transactions, orders, discounts, and subscriptions.
• 📦 Plug & Play Multi-Database Support: SQLite (in-memory & file), MySQL 8+, MariaDB, and PostgreSQL out of the box.
• 🏎️ Tiered Caching: PSR-16 SimpleCache database store + Redis/APCu Doctrine metadata and query caching.
• 🧩 Extensible: Register custom entity paths and third-party migrations effortlessly.

🚀 Quickstart

composer require tueen/database

use Tueen\Database\Config\DatabaseConfig;
use Tueen\Database\DatabaseManager;

// Initialize with zero-config auto-migration (SQLite file or :memory:)
$db = DatabaseManager::create(DatabaseConfig::createSqlite(':memory:'));

// 1. Find or create a Telegram user
$chat = $db->chats()->findOrCreate(
    chatId: 123456789,
    username: '@telegram_user',
    name: 'Alice',
);

// 2. Perform atomic wallet credit
$tx = $db->wallets()->credit($chat, '50.000000000000000000', 'TON', 'welcome_bonus');

// 3. Store global bot options and configuration
$db->options()->set('maintenance_mode', false, 'system');

🛠️ CLI Tooling

Manage your schema, status, and caches with the bundled tueen-db CLI:

# Verify schema & entity mappings
php bin/tueen-db tueen:db:validate

# Inspect engine status
php bin/tueen-db tueen:db:status

# Synchronize schema diffs
php bin/tueen-db tueen:db:sync

# Clear caches
php bin/tueen-db tueen:cache:clear

📖 Complete Documentation

Exhaustive documentation, architecture deep dives, entity guides, and interactive diagrams are available in the VitePress Documentation Suite.

cd docs
npm install
npm run docs:dev

📄 License

Tueen Database is open-sourced software licensed under the MIT License.