MyNixOS website logo
Description

SQL Server client library implemented in Haskell.

Please see the README on GitHub at https://github.com/mitsuji/mssql-simple#readme

mssql-simple: SQL Server client library implemented in Haskell

This is a Haskell implementation of client library for Microsoft SQL Server.

Usage Example

https://github.com/mitsuji/mssql-simple-example/blob/master/app/Main.hs

Related projects

  • mssql-simple-example : Usage example of mssql-simple
    https://github.com/mitsuji/mssql-simple-example

  • ms-tds : TDS Protocol implemented in Haskell
    https://github.com/mitsuji/ms-tds

Advantage

  • ODBC independent

  • Implemented only with Haskell (Independent of other languages ​​and environments)

  • Supports encryption at login

  • Supports simultaneous acquisition of multiple record sets

  • Supports stored procedure RPC

  • Supports Transaction

  • 7.1 Revision 1 (SQL Server 2000 SP1 and later)

  • Tested with SQL Server 2008 R2, SQL Server 2014

Todo

  • Write tests

    • Write general tests
  • ETC

    • Encrypt entire connection support

    • Mars support

    • SSPI support

    • FedAuth support

    • TDS protocol versions other than 7.1

    • Bulk Load
      https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/88176081-df75-4b24-bcfb-4c16ff03cbfa

    • Distributed Transaction
      https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/b4b78564-5440-4fc0-b5ef-c9e1925aaefe.

Metadata

Version

0.6.0.5

Platforms (75)

    Darwin
    FreeBSD
    Genode
    GHCJS
    Linux
    MMIXware
    NetBSD
    none
    OpenBSD
    Redox
    Solaris
    WASI
    Windows
Show all
  • aarch64-darwin
  • aarch64-genode
  • aarch64-linux
  • aarch64-netbsd
  • aarch64-none
  • aarch64_be-none
  • arm-none
  • armv5tel-linux
  • armv6l-linux
  • armv6l-netbsd
  • armv6l-none
  • armv7a-darwin
  • armv7a-linux
  • armv7a-netbsd
  • armv7l-linux
  • armv7l-netbsd
  • avr-none
  • i686-cygwin
  • i686-darwin
  • i686-freebsd
  • i686-genode
  • i686-linux
  • i686-netbsd
  • i686-none
  • i686-openbsd
  • i686-windows
  • javascript-ghcjs
  • loongarch64-linux
  • m68k-linux
  • m68k-netbsd
  • m68k-none
  • microblaze-linux
  • microblaze-none
  • microblazeel-linux
  • microblazeel-none
  • mips-linux
  • mips-none
  • mips64-linux
  • mips64-none
  • mips64el-linux
  • mipsel-linux
  • mipsel-netbsd
  • mmix-mmixware
  • msp430-none
  • or1k-none
  • powerpc-netbsd
  • powerpc-none
  • powerpc64-linux
  • powerpc64le-linux
  • powerpcle-none
  • riscv32-linux
  • riscv32-netbsd
  • riscv32-none
  • riscv64-linux
  • riscv64-netbsd
  • riscv64-none
  • rx-none
  • s390-linux
  • s390-none
  • s390x-linux
  • s390x-none
  • vc4-none
  • wasm32-wasi
  • wasm64-wasi
  • x86_64-cygwin
  • x86_64-darwin
  • x86_64-freebsd
  • x86_64-genode
  • x86_64-linux
  • x86_64-netbsd
  • x86_64-none
  • x86_64-openbsd
  • x86_64-redox
  • x86_64-solaris
  • x86_64-windows