Home

doix-db is an extension to the doix framework for working with relational databases.

tl;dr

Connect to PostgreSQL or to ClickHouse and hack on.

• DbClient — the database API available to doix Jobs;
• DbModel — the set of classes representing the database structure;
• DbQuery — a DbModel based SELECT builder;
• DbMigrationPlan — a DbModel based deployment automation tool;
• DbLang — a set of SQL generating functions for miscellaneous application tasks.

For each individual DBMS product, it requires a specific library, such as:

• doix-db-postgresql
• doix-db-clickhouse

Reference

• DbLang
• DbPool
  • DbClient
    • DbCall
• DbModel
  • DbSchema
    • DbObject
      • DbRelation: DbTable, DbView (+DbQueue)
        • DbColumn
          • DbReference
          • DbType
            • DbTypeArithmetic
              • DbTypeArithmeticFixed
              • DbTypeArithmeticFloat
              • DbTypeArithmeticInt
            • DbTypeCharacter
            • DbTypeTemporal
              • DbTypeDate
              • DbTypeTimestamp
        • DbIndex
        • DbTrigger
      • DbRoutine: DbProcedure, DbFunction
        • DbRoutineParameter
    • DbSchemaSource
      • DbObjectMerger
• DbQuery
  • DbQueryColumn
  • DbQueryTable
    • DbQueryTableColumnComparison
  • DbQueryOr
• DbMigrationPlan
• DbCsvPrinter