Go w/ MSSQL - Experiences?

This page summarizes the projects mentioned and recommended in the original post on /r/golang

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • go-mssqldb

    Microsoft SQL server driver written in go language

    I switched to the "denisnkom" driver (https://github.com/denisenkom/go-mssqldb) as the stability of that improved.

  • odbc

    odbc driver written in go (by alexbrainman)

    I started out using the ODBC driver wrapper when there weren't good choices for native drivers. I wrote a little helper package to figure out the best ODBC driver to use: https://github.com/billgraziano/mssqlodbc. Lots of the code I wrote would run in different environments with different configurations. That package is a little out of date now.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • mssqlodbc

    GO helper library for MSSQL ODBC connections

    I started out using the ODBC driver wrapper when there weren't good choices for native drivers. I wrote a little helper package to figure out the best ODBC driver to use: https://github.com/billgraziano/mssqlodbc. Lots of the code I wrote would run in different environments with different configurations. That package is a little out of date now.

  • xelogstash

    Send SQL Server Extended Events to Logstash, Elastic Search, or JSON

    (More shameless self-promotion) I also have a utility that pulls SQL Server extended events into Logstash or Elastic: https://github.com/billgraziano/xelogstash. This uses the native GO driver also without issues.

  • go-mssqldb

    Microsoft SQL server driver written in go language (by microsoft)

    However, if I were starting today, I would use the Microsoft driver - especially if I was doing anything with Azure. Over the next year I will likely migrate to use this package. I'm just not sure how much the original driver will be updated now that Microsoft is working on a fork.

  • sqlexp

    Experimental golang database/sql

    Plus, if you look in the MS repository, you see a GO port of sqlcmd using the driver. Which also uses a different version of the "sql" package that handles PRINT statements. That certainly looks interesting.

  • sqlx

    general purpose extensions to golang's database/sql

    I typically use sqlx to deal with query results.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts