Kinetiqo Logo Kinetiqo
GitHub
Feature Deep Dive

Multi-Database Zero-ORM SQL Repository Engine

Kinetiqo is engineered around a clean Repository pattern using raw parameterized SQL queries for maximum throughput across PostgreSQL, MySQL, and Firebird.

Zero ORM Overhead

Raw Parameterized SQL Repository Architecture

Object-Relational Mappers (ORMs) introduce query overhead, hidden subqueries, and slow bulk imports. Kinetiqo uses a unified abstract DatabaseRepository interface backed by three hand-optimized concrete SQL drivers.

  • 100% Parameterized Statements: Prevents SQL injection vulnerabilities by design using native driver placeholders (%s for PostgreSQL & MySQL, ? for Firebird).
  • Automated Schema Migration: Automatically checks schema versions, creates missing tables, indexes, and triggers on application startup.
  • Seamless Engine Switch: Switch database engines anytime via DATABASE_TYPE environment variable or CLI -d flag without modifying code.
Database Repository Performance in Kinetiqo

Supported Database Engine Backends

🐘 PostgreSQL (12+)

Default high-concurrency SQL warehouse engine. Features connection pooling, full SSL mode support (disable, require, verify-full), and rapid bulk stream upserts using psycopg2-binary.

Default Port: 5432 | Env: POSTGRESQL_HOST

🐬 MySQL 8 / MariaDB 10+

Standard LAMP/LEMP web stack compatibility. Powered by mysql-connector-python with full transactional support, automated table schema management, and UTF8MB4 character sets.

Default Port: 3306 | Env: MYSQL_HOST

🔥 Firebird (3.0, 4.0, 5.0)

Zero-config embedded or standalone SQL database. Uses firebird-driver with generator sequences, triggers, FIRST/SKIP pagination, and automatic .fdb file creation on startup.

Default Port: 3050 | Env: FIREBIRD_DATABASE

Database Benchmark & Compatibility

All three database implementations undergo rigorous automated testing matrixes (`test_sync_logic.py`) asserting that queries run cleanly without dialect mismatch. Whether you run PostgreSQL on a cloud cluster, MySQL on NAS, or Firebird in a container volume, Kinetiqo delivers uniform sub-millisecond query performance.