crystal-tds

crystal-tds

A crystal native database driver for Microsoft SQL Server.

spec

The C implementation (freetds), the the Java implementation (jTDS) but also the Wiresharp Protocol Plugin for TDS were a real treasure trove for the realization of this project.

Installation

  1. Add the dependency to your shard.yml:

    dependencies:
      crystal-tds:
        github: wonderix/crystal-tds
    
  2. Run shards install

Usage

This driver now uses the crystal-db project. Documentation on connecting, querying, etc, can be found at:

Supported data types

  • TINYINT
  • SMALLINT
  • INT
  • BIGINT
  • DECIMAL
  • NUMERIC
  • FLOAT
  • REAL
  • VARCHAR
  • NVARCHAR
  • DATE
  • DATETIME
  • DATETIME2
  • SMALLDATETIME
  • TEXT
  • NTEXT

Restriction

Have a look at the issue tracker to get an overview over all restrictions.

Development

  • Install Docker

Contributing

  1. Fork it (https://github.com/wonderix/crystal-tds/fork)
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request

Contributors

Testing

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=My-Secret-Pass' -e 'MSSQL_PID=Express' -p 1433:1433 -d mcr.microsoft.com/mssql/server
crystal spec
Owner
github statistic
  • 0
  • 0
  • 0
  • 8
  • 2 days ago
  • November 14, 2020
License

MIT License

Links
Synced at

Fri, 27 Nov 2020 06:47:35 GMT