hmssql

hmssql is a native Haskell client for Microsoft SQL Server (2017 and later) and Azure SQL Database. It implements SQL Server’s wire protocol directly (TDS 7.4 and 8.0), so no ODBC driver or client library is needed.

Contents#

1. Getting started
   1. A first program — Requirements, and a program that runs a query
   2. Connecting — Local servers, Azure SQL Database and Microsoft Entra ID
   3. Pools and threads — One thread per connection, and a pool recipe
2. Queries
   1. Reading rows — Records, tuples and your own column types
   2. Parameters — param, mkQuery and named parameters
   3. Composing queries — Queries as values
   4. Several result sets — Reading the results of several SELECT statements in one batch
   5. Stored procedures — Output parameters and the return status
3. Writing data
   1. Transactions — withTransaction and isolation levels
   2. Many statements in one round trip — executeMany and BatchQuery
   3. Bulk copy — Inserting many rows efficiently
4. Streaming
   1. Streaming rows — Processing rows without collecting the whole result in memory
   2. MARS — Several open streams on one connection
5. Decoders and encoders
   1. Decoders — Row decoders built by hand, and decoders chosen at runtime
   2. Encoders — How values are declared to the server, and encoders for your own types
   3. Streaming values — A single value too large for memory, in either direction
6. Errors and security
   1. Errors and timeouts — Handling exceptions and setting timeouts
   2. Encryption and security — Encryption modes, certificates and credentials
7. Under the hood
   1. How it works — The protocol, in one page

Where to go next#

• Examples — Complete programs over a sample database, among them a streaming OData server
• Developer documentation — Design decisions and implementation notes for contributors