Feature Deep Dive

Multi-DB Zero-ORM Warehouse Engine

Zero ORM overhead. Parameterized raw SQL performance benchmarked across PostgreSQL, MySQL, and Firebird.

Repository Pattern

Triple-Backend SQL Support

Kinetiqo implements an explicit repository pattern (db/repository.py) with native implementations for three major relational database engines without heavy ORMs like SQLAlchemy.

PostgreSQL 12+: Powering production deployments with psycopg2-binary
MySQL 8.0+ / MariaDB: Optimized using mysql-connector-python
Firebird 3.0/4.0/5.0: Native support via firebird-driver
100% Parameterized SQL: Strict SQL injection immunity with zero raw string concatenation

Multi-DB Architecture: PostgreSQL, MySQL, and Firebird connected to Kinetiqo Engine

Built-in Automated Database Benchmark Utility

Kinetiqo includes a built-in CLI benchmark utility (kinetiqo benchmark) to measure query performance across engines under identical telemetry workloads:

cli — database benchmark

# Benchmark database performance for the last 365 days
python src/kinetiqo.py benchmark --scope 365 --database postgresql