relational-schemas

RDBMSs' schema templates for relational-query

http://khibino.github.io/haskell-relational-record/

Version on this page:0.1.7.0
LTS Haskell 22.21:0.1.8.1
Stackage Nightly 2024-05-06:0.1.8.1
Latest on Hackage:0.1.8.1

See all snapshots relational-schemas appears in

BSD-3-Clause licensed by Kei Hibino, Shohei Murayama, Shohei Yasutake, Sho KURODA
This version can be pinned in stack with:relational-schemas-0.1.7.0@sha256:dd23231572f3886298561426621a7b1242c9fc1854759d0a9fc165f8b09f941d,5989

Module documentation for 0.1.7.0

  • Database
    • Database.Custom
      • Database.Custom.IBMDB2
      • Database.Custom.MySQL
      • Database.Custom.Oracle
      • Database.Custom.PostgreSQL
      • Database.Custom.SQLServer
      • Database.Custom.SQLite3
    • Database.Relational
      • Database.Relational.Schema
        • Database.Relational.Schema.DB2Syscat
          • Database.Relational.Schema.DB2Syscat.Columns
          • Database.Relational.Schema.DB2Syscat.Config
        • Database.Relational.Schema.IBMDB2
          • Database.Relational.Schema.IBMDB2.Columns
        • Database.Relational.Schema.MySQL
          • Database.Relational.Schema.MySQL.Columns
        • Database.Relational.Schema.MySQLInfo
          • Database.Relational.Schema.MySQLInfo.Columns
          • Database.Relational.Schema.MySQLInfo.Config
        • Database.Relational.Schema.Oracle
          • Database.Relational.Schema.Oracle.TabColumns
        • Database.Relational.Schema.OracleDataDictionary
          • Database.Relational.Schema.OracleDataDictionary.Config
          • Database.Relational.Schema.OracleDataDictionary.TabColumns
        • Database.Relational.Schema.PgCatalog
          • Database.Relational.Schema.PgCatalog.Config
          • Database.Relational.Schema.PgCatalog.PgAttribute
          • Database.Relational.Schema.PgCatalog.PgType
        • Database.Relational.Schema.PostgreSQL
          • Database.Relational.Schema.PostgreSQL.PgAttribute
          • Database.Relational.Schema.PostgreSQL.PgType
        • Database.Relational.Schema.SQLServer
          • Database.Relational.Schema.SQLServer.Columns
          • Database.Relational.Schema.SQLServer.Types
        • Database.Relational.Schema.SQLServerSyscat
          • Database.Relational.Schema.SQLServerSyscat.Columns
          • Database.Relational.Schema.SQLServerSyscat.Config
          • Database.Relational.Schema.SQLServerSyscat.Types
        • Database.Relational.Schema.SQLite3
          • Database.Relational.Schema.SQLite3.IndexInfo
          • Database.Relational.Schema.SQLite3.IndexList
          • Database.Relational.Schema.SQLite3.TableInfo
        • Database.Relational.Schema.SQLite3Syscat
          • Database.Relational.Schema.SQLite3Syscat.Config
          • Database.Relational.Schema.SQLite3Syscat.IndexInfo
          • Database.Relational.Schema.SQLite3Syscat.IndexList
          • Database.Relational.Schema.SQLite3Syscat.TableInfo

This package contains some RDBMSs' schema structure definitions.

Supported RDBMS schemas are below:

  • IBM DB2

  • PostgreSQL

  • Microsoft SQLServer

  • SQLite3

  • Oracle

  • MySQL

Changes

0.1.7.0

  • adjust sub-directory modules of each DBMS to top module name.
  • enable addModifyTableAliasAS flag of SQLite3 configuration.
  • add custom API modules for each DBMS with appropriate configuration.

0.1.6.2

  • update tested-with.

0.1.6.1

  • update version constraint. ( along with re-versioned relational-query. )

0.1.6.0

  • apply projections with overloaded-labels to schema tables.

0.1.5.0

  • apply relational-query-0.10.0

0.1.4.1

  • apply relational-query-0.9.5

0.1.4.0

  • add tested-with 8.2.1.
  • switch 3rd number of version to separate from no-generic version.

0.1.3.3

  • Use Haskell implementation test instead of flag test in .cabal

0.1.3.2

  • Apply generic instances to schema queries.
  • Drop unused implicit imports.

0.1.3.1

  • Add tested-with.

0.1.3.0

  • Update typeMap of SQLite3 schema.

0.1.2.0

  • Get type info of network address in PostgreSQL schema.

0.1.1.0

  • Add medium-int to typeMap of MySQL schema.