Go SQL

Open-source Go projects categorized as SQL
Edit details
Topics: Golang Go Database Postgresql MySQL
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

Top 23 Go SQL Projects

  • tidb

    TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial

    • Project mention: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09

    tidb has been around for a while, it is distributed, written in Go and Rust, and MySQL compatible. https://github.com/pingcap/tidb

    Somewhat relatedly, StarRocks is also MySQL compatible, written in Java and C++, but it's tackling OLAP use-cases. https://github.com/StarRocks/starrocks

  • cockroach

    CockroachDB - the open source, cloud-native distributed SQL database.

    • Project mention: 11 Planetscale alternatives with free tiers | dev.to | 2024-04-11

    CockroachDB is an open source distributed SQL database designed for scalability and resilience. While it offers SQL databases, CockroachDB is also compatible with PostgreSQL.

  • 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

  • dolt

    Dolt – Git for Data

    • Project mention: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09

    Hi, this is my project :)

    For us this package is most important as the query engine that powers Dolt:

    https://github.com/dolthub/dolt

    We aren't the original authors but have contributed the vast majority of its code at this point. Here's the origin story if you're interested:

    https://www.dolthub.com/blog/2020-05-04-adopting-go-mysql-se...

  • rqlite

    The lightweight, distributed relational database built on SQLite.

    • Project mention: The lightweight, easy-to-use, distributed relational database built on SQLite | news.ycombinator.com | 2024-02-23

  • go-sql-driver/mysql

    Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)

  • migrate

    Database migrations. CLI and Golang library.

    • Project mention: Using migrations with Golang | dev.to | 2024-04-17

    Go does not natively support the use of migrations, but we could use the ORM that has this functionality, such as GORM which is the most used by the community, but We can use migrations without using an ORM, for this we will use the golang-migrate package.

  • sqlc

    Generate type-safe code from SQL

    • Project mention: Show HN: Riza – Safely run untrusted code from your app | news.ycombinator.com | 2024-04-30

    Hi HN, I’m Kyle and together with Andrew (https://news.ycombinator.com/user?id=stanleydrew) we’ve been working on Riza (https://riza.io), a project to make WASM sandboxing more approachable. We’re excited to share a developer preview of our code interpreter API with HN.

    There’s a bit of a backstory here. A few months ago, an old coworker reached out asking how to execute untrusted code generated by an LLM. Based on our experience building a plugin system for sqlc (https://sqlc.dev), we thought a sandboxed WASM runtime would be a good fit. A bit of hacking later, we got everything wired up to solve his issue. Now the API is ready for other developers to try out.

    The Riza Code Interpreter API is an HTTP interface to various dynamic language interpreters, each running inside a WASM sandbox without access to the outside world (for now). We modeled the API to align with a POSIX shell-style interface.

    We made a playground so you can try it out without signing up: https://riza.io

    The API documentation lives here: https://docs.riza.io

    There are many limitations at the moment, but we expect to rapidly expand capabilities so that programs can e.g. access the network and filesystem. Our roadmap has more details: https://docs.riza.io/reference/roadmap

    If you need to execute LLM-generated code we’d love to have you try the API and let us know if you run into any issues. You can email us directly at [email protected].

  • SaaSHub

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

    SaaSHub logo

  • bytebase

    The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.

    • Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14

    We have been building https://github.com/bytebase/bytebase for 3+ years. You can think it of as GitHub/GitLab for SQL changes, with integrated GitOps, code review and deployment.

    You can further check out this tutorial to get a feel of our GitOps solution

    https://www.bytebase.com/docs/tutorials/database-change-mana...

  • go-clean-arch

    Go (Golang) Clean Architecture based on Reading Uncle Bob's Clean Architecture

  • usql

    Universal command-line interface for SQL databases

    • Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08

  • immudb

    immudb - immutable database based on zero trust, SQL/Key-Value/Document model, tamperproof, data change history

    • Project mention: Ask HN: What is your experience of tamper proof systems? | news.ycombinator.com | 2024-01-05

  • steampipe

    Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

    • Project mention: Steampipe: Dynamically query APIs, code and more with SQL | news.ycombinator.com | 2024-04-04

  • go-sqlmock

    Sql mock driver for golang to test database interactions

    • Project mention: How do you unit-test code that reaches out to the db, without introducing interfaces everywhere? | /r/golang | 2023-08-16

  • goose

    A database migration tool. Supports SQL migrations and Go functions.

    • Project mention: Recent improvements to the pressly/goose migration tool | /r/golang | 2023-11-14

    In v3.16.0 we added a new Provider feature that unlocks the ability to implement a lot of highly requested features. More details in the blog post:

  • cloudquery

    The open source high performance ELT framework powered by Apache Arrow

    • Project mention: We might want to regularly keep track of how important each server is | news.ycombinator.com | 2024-02-06

    Check out CloudQuery - https://github.com/cloudquery/cloudquery for an easy cloud asset inventory.

  • go-pg

    Golang ORM with focus on PostgreSQL features and performance

  • octosql

    OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

    • Project mention: Wazero: Zero dependency WebAssembly runtime written in Go | news.ycombinator.com | 2023-07-01

    Never got it to anything close to a finished state, instead moving on to doing the same prototype in llvm and then cranelift.

    That said, here's some of the wazero-based code on a branch - https://github.com/cube2222/octosql/tree/wasm-experiment/was...

    It really is just a very very basic prototype.

  • dsq

    Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

    • Project mention: Tracking SQLite Database Changes in Git | news.ycombinator.com | 2023-11-02

    You might want to look at tsv-utils, or a similar project: https://github.com/eBay/tsv-utils

    For the SQL part, but maybe a lot heavier, you can use one of the projects listed on this page: https://github.com/multiprocessio/dsq (No longer maintained, but has links to lots of other projects)

  • xo

    Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

    • Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02

    i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.

  • upper.io/db

    Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.

  • cloudnative-pg

    CloudNativePG is a comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments, covering the entire operational lifecycle from initial deployment to ongoing maintenance

    • Project mention: Homelab: Running Postgres on Kubernetes | news.ycombinator.com | 2024-01-02

    My holiday project was doing another pass at my Homelab Kubernetes cluster, part of which involved switching to a proper operator to manage Postgres. Coincidentally, I setup cloudnative-pg (https://github.com/cloudnative-pg/cloudnative-pg) yesterday.

  • mergestat-lite

    Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊

  • bun

    SQL-first Golang ORM (by uptrace)

  • SaaSHub

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

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Go SQL related posts

  • PeerDB Streams – Simple, Native Postgres Change Data Capture

    4 projects | news.ycombinator.com | 6 May 2024

  • Show HN: Riza – Safely run untrusted code from your app

    1 project | news.ycombinator.com | 30 Apr 2024

  • Using migrations with Golang

    5 projects | dev.to | 17 Apr 2024

  • A MySQL compatible database engine written in pure Go

    10 projects | news.ycombinator.com | 9 Apr 2024

  • Steampipe: Dynamically query APIs, code and more with SQL

    1 project | news.ycombinator.com | 4 Apr 2024

  • Cloud Tools You Probably Haven't Heard Of

    3 projects | dev.to | 31 Mar 2024

  • The Great Migration from MongoDB to PostgreSQL

    1 project | news.ycombinator.com | 29 Mar 2024
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 7 May 2024
    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. Learn more →

Index

What are some of the best open-source SQL projects in Go? This list will help you:

Project Stars
1 tidb 36,169
2 cockroach 29,119
3 dolt 16,993
4 rqlite 14,898
5 go-sql-driver/mysql 14,187
6 migrate 14,062
7 sqlc 11,012
8 bytebase 10,107
9 go-clean-arch 8,717
10 usql 8,634
11 immudb 8,494
12 steampipe 6,401
13 go-sqlmock 5,837
14 goose 5,684
15 cloudquery 5,591
16 go-pg 5,586
17 octosql 4,699
18 dsq 3,638
19 xo 3,567
20 upper.io/db 3,479
21 cloudnative-pg 3,425
22 mergestat-lite 3,419
23 bun 3,161

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com