Go w/ MSSQL - Experiences?

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

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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • 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.

  • 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.

    InfluxDB logo
  • 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.

  • 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.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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

  • Show HN: Roast my SQLite encryption at-rest

    9 projects | news.ycombinator.com | 30 Apr 2024
  • Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App

    2 projects | dev.to | 22 Apr 2024
  • Replacing Complicated Hashmaps with SQLite

    1 project | news.ycombinator.com | 6 Apr 2024
  • The DDD Hamburger for Go

    2 projects | dev.to | 6 Jan 2024
  • Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go

    1 project | /r/patient_hackernews | 6 Oct 2023