Home

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

tl;dr

Start a trivial Web service project with doix-http, add a connection to PostgreSQL or to ClickHouse and hack on.

Description

Basically, this is the common database interface for doix, the same as ODBC for Windows, JDBC for Java and so on. Like all those *DBCs, for each individual DBMS, it requires a vendor specific driver.

For application developers, main entry point here is DbClient, which instances are injected in the execution context (e. g. as this.db) and provide methods to invoke SQL statements (e. g. await this.db.do ('DROP TABLE log')).

To make it happen, a corresponding DbPool instance must be registered as one of the hosting Application's pools.

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