Zigi monitors Jira and GitHub updates, pings you when PRs need approval and lets you take fast actions - all directly from Slack! Plus it reduces cycle time by up to 75%. Learn more →
Top 23 Go SQL Projects
TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try free: https://tidbcloud.com/free-trialProject mention: Banco de dados puramente com go | reddit.com/r/brdev | 2022-11-08
Pesquise por CockroachDB ou TiDB
CockroachDB - the open source, cloud-native distributed SQL database.Project mention: How do I implement a HA PostgreSQL setup in k8s/k3s ? | reddit.com/r/kubernetes | 2022-11-23
Technically not postgres, but could be worth checking out cockroach db, it can use any postgres driver from programming languages and is build for distribution. I recently moved from postgres to cockroach (with golang postgres driver) and didnt need to change a single query
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Data Platform where developers build real-time applications for analytics, IoT and cloud-native services in less time with less code.
Dolt – Git for DataProject mention: You've heard of big data, now get ready for cozy data | reddit.com/r/DataHoarder | 2022-11-18
Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)Project mention: Question about inserting date into MySQL? | reddit.com/r/golang | 2022-11-15
If you are using https://github.com/go-sql-driver/mysql you need to add parseTime=true to the DSN to be able to use time.Time.
The lightweight, distributed relational database built on SQLiteProject mention: Crsql – Multi-writer and CRDT support for SQLite | news.ycombinator.com | 2022-11-14
Database migrations. CLI and Golang library.Project mention: Libraries you use most of your projects? | reddit.com/r/golang | 2022-11-02
There are other things I generally drag around out of habit like migrate, but I don't necessarily love those as much.
immudb - immutable database based on zero trust, SQL and Key-Value, tamperproof, data change historyProject mention: AWS and Blockchain | news.ycombinator.com | 2022-11-20
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
Universal command-line interface for SQL databasesProject mention: Is there a CLI interface to browse SQL databases? | reddit.com/r/commandline | 2022-08-10
take a look at: https://github.com/xo/usql
Go (Golang) Clean Architecture based on Reading Uncle Bob's Clean ArchitectureProject mention: Best practices for structuring Go HTTP applications | reddit.com/r/golang | 2022-10-25
Generate type-safe code from SQLProject mention: ORMs | reddit.com/r/golang | 2022-11-14
Golang ORM with focus on PostgreSQL features and performanceProject mention: What SQL library are you using? | reddit.com/r/golang | 2022-07-02
I usually work with PostgreSQL and have used https://github.com/go-pg/pg. https://github.com/uptrace/bun is its successor.
Sql mock driver for golang to test database interactionsProject mention: Creating an API using Go and sqlc | dev.to | 2022-10-24
For that, I used the lib go-sqlmock. So, for example, the following snippet is part of the person/service_test.go file:
Database CI/CD for DevOps teams. https://www.bytebase.com
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.Project mention: Steampipe – Select * from Cloud; | news.ycombinator.com | 2022-09-30
To add somewhat of a counterpoint to the other response, I've tried the Steampipe CSV plugin and got 50x slower performance vs OctoSQL, which is itself 5x slower than something like DataFusion. The CSV plugin doesn't contact any external API's so it should be a good benchmark of the plugin architecture, though it might just not be optimized yet.
That said, I don't imagine this ever being a bottleneck for the main use case of Steampipe - in that case I think the APIs themselves will always be the limiting part. But it does - potentially - speak to what you can expect if you'd like to extend your usage of Steampipe to more than just DevOps data.
Disclaimer: author of OctoSQL
Use SQL to instantly query your cloud services (AWS, Azure, GCP and more). Open source CLI. No DB required.Project mention: List all resources by ARN in Service in AWS CLI | reddit.com/r/aws | 2022-11-30
go look at steampipe.io
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)Project mention: Help with XO's new templating, how to access fields and params | reddit.com/r/golang | 2022-08-23
I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.Project mention: [Hiring] Remote Golang job: Senior Backend Engineer (Go) at Horizon (Toronto, Canada) | reddit.com/r/jobbit | 2022-05-28
You will be joining the expert Go team at Horizon, previously who in our spare time + for fun, authored OSS projects like chi (https://github.com/go-chi/chi), upper/db (https://github.com/upper/db), webrpc (https://github.com/webrpc/webrpc), goware (https://github.com/goware), and much more. Our Go codebases are extremely clean and the patterns we've built have been shaped over 7 years of writing production Go systems and open source projects. These are the patterns which we apply to our infrastructure at Horizon in our products Skyweaver and Sequence.
Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊Project mention: SQLite Doesn't Use Git | reddit.com/r/programming | 2022-09-12
You can query git with this: https://github.com/mergestat/mergestat if you like the idea.
A database migration tool. Supports SQL migrations and Go functions.Project mention: DB schema management strategy (migrations) | reddit.com/r/golang | 2022-10-25
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.Project mention: Command-line data analytics made easy | news.ycombinator.com | 2022-11-03
SPyQL is really cool and its design is very smart, with it being able to leverage normal Python functions!
As far as similar tools go, I recommend taking a look at DataFusion, dsq, and OctoSQL.
DataFusion is a very (very very) fast command-line SQL engine but with limited support for data formats.
dsq is based on SQLite which means it has to load data into SQLite first, but then gives you the whole breath of SQLite, it also supports many data formats, but is slower at the same time.
OctoSQL is faster, extensible through plugins, and supports incremental query execution, so you can i.e. calculate a running group by + count while tailing a log file. It also supports normal databases, not just file formats, so you can i.e. join with a Postgres table.
Disclaimer: Author of OctoSQL
SQL schema migration tool for Go.Project mention: How to use sql-migrate in Kubernetes? | reddit.com/r/golang | 2022-11-27
The open-source data integration platform for security and infrastructure teamsProject mention: Sync all your cloud asses to Snowflake and build an "Infrastructure Lake" | reddit.com/r/devops | 2022-11-25
Hey! Im the founder of https://github.com/cloudquery/cloudquery we are an open source high performance data integration platform focused on cloud infrastructure. We just released a new integration to Snowflake which can be super useful if you already use it and/or if you want historical data of your cloud infra and query it later.
GraphJin - Build APIs in 5 minutes with GraphQL. An instant GraphQL to SQL compiler.Project mention: [Question] What will it take to create an automated graphQL API with Elixir? | reddit.com/r/elixir | 2022-10-29
There are tools like Hasura/Haskell, Postgraphile/Node.js or Graphjin/Golang that could generate an automatic graphQL API from a Postgres database. Im new to Elixir and really love it. I wonder if there is anything similar these. I heard about Absinthe for graphQL, however as far as I understand it requires to write your own resolvers. What will it take to create a similar tool in Elixir like the one stated above? How would one go about it?
Truly a developer’s best friend. Scout APM is great for developers who want to find and fix performance issues in their applications. With Scout, we'll take care of the bugs so you can focus on building great things 🚀.
Go SQL related posts
List all resources by ARN in Service in AWS CLI
1 project | reddit.com/r/aws | 30 Nov 2022
ORM in Golang?
1 project | reddit.com/r/golang | 28 Nov 2022
How to use sql-migrate in Kubernetes?
1 project | reddit.com/r/golang | 27 Nov 2022
JQL in go
6 projects | reddit.com/r/golang | 26 Nov 2022
How do I implement a HA PostgreSQL setup in k8s/k3s ?
4 projects | reddit.com/r/kubernetes | 23 Nov 2022
Tiny lib to scan SQL rows directly to structs, slices, and primitive types
1 project | news.ycombinator.com | 20 Nov 2022
3 projects | dev.to | 19 Nov 2022
A note from our sponsor - Zigi
www.zigi.ai | 30 Nov 2022
What are some of the best open-source SQL projects in Go? This list will help you: