relational-schemas

RDBMSs' schema templates for relational-query

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

LTS Haskell 23.14:	0.1.8.1
Stackage Nightly 2025-03-14:	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

Maintained by ex8k.hibino@gmail.com, shohei.murayama@gmail.com, amutake.s@gmail.com, krdlab@gmail.com

This version can be pinned in stack with:relational-schemas-0.1.8.1@sha256:d930c71f5481d621007a7a94f0042c843a3aee1aec966808d0e80da0f4634653,6319

Module documentation for 0.1.8.1

Database
- Database.Custom
- 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.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.SQLite3
    - Database.Relational.Schema.SQLite3Syscat

Depends on 7 packages(full list with versions):

base, bytestring, containers, relational-query, sql-words, template-haskell, time

Used by 1 package in nightly-2025-01-21(full list with versions):

relational-query-HDBC

This package contains some RDBMSs' schema structure definitions.

Supported RDBMS schemas are below:

IBM DB2
PostgreSQL
Microsoft SQLServer
SQLite3
Oracle
MySQL

Changes

0.1.8.1

fix typo.

0.1.8.0

update for GHC 8.8.x.
allow more type-categories of PostgreSQL.

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.