Go Postgresql

Open-source Go projects categorized as Postgresql

Top 23 Go Postgresql Projects

  • usql

    Universal command-line interface for SQL databases

    Project 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

  • pgweb

    Cross-platform client for PostgreSQL databases

  • SonarLint

    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.

  • sqlc

    Generate type-safe code from SQL

    Project mention: ORMs | reddit.com/r/golang | 2022-11-14


  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

    Project mention: Go overtook Ruby and ranked #3 among the most used backend languages for pull requests since 2021 | reddit.com/r/golang | 2022-11-07

    FWIW, the other posts point to https://gobuffalo.io/ and https://github.com/volatiletech/sqlboiler as possibilities.

  • go-pg

    Golang ORM with focus on PostgreSQL features and performance

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

  • FerretDB

    A truly Open Source MongoDB alternative

    Project mention: When writing free and open source software that interfaces with a database, which databases are preferred or recommended? | reddit.com/r/freesoftware | 2022-11-24

    Big? FerretDB

  • bytebase

    Database CI/CD for DevOps teams. https://www.bytebase.com

    Project mention: Upgrade a 1TB PostgreSQL DB In | news.ycombinator.com | 2022-10-14

    You can check out https://github.com/bytebase/bytebase. It provides a GUI for managing schema and data changes for Postgres, MySQL, Snowflake, ClickHouse, TiDB.

    Disclaimer: I am one of the authors.

  • Zigi

    Close all those tabs. Zigi will handle your updates.. 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%.

  • Miniflux

    Minimalist and opinionated feed reader

    Project mention: Breaking out my old Pi 1b. Anything lightweight I can put it to work on? | reddit.com/r/homelab | 2022-11-16

    I have my 3B+ running a Wireguard server (https://pivpn.io/) for remote access to my home network, and Miniflux (https://miniflux.app/) as I've long mourned the death of Google Reader. It has plenty of resources left for any future projects I want to throw on it as well.

  • 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: 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[0], which is itself 5x slower than something like DataFusion[1]. 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.

    [0]: https://github.com/cube2222/octosql

    [1]: https://github.com/apache/arrow-datafusion

    Disclaimer: author of OctoSQL

  • steampipe

    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

  • stolon

    PostgreSQL cloud native High Availability and more.

    Project mention: Falling for Kubernetes | news.ycombinator.com | 2022-08-09
  • pREST

    PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new

    Project mention: Constant work to onboarding new members into engineering team | dev.to | 2022-01-07

    Improve local tests execution — it is frustrating that someone wants to contribute and cannot run the local tests (we use e2e tests, making requests to prestd's own API), a way was implemented where the tests run inside docker using docker-compose;

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

  • upper.io/db

    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.

  • goose

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

    Project mention: DB schema management strategy (migrations) | reddit.com/r/golang | 2022-10-25

    Try: github.com/pressly/goose

  • postgres-operator

    Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.

    Project mention: Do people use DBs as Pods? | reddit.com/r/kubernetes | 2022-10-01
  • postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes (by zalando)

    Project mention: Best way for high-available database at home? | reddit.com/r/selfhosted | 2022-11-29

    I don't have much experience with HA databases, so I can't really decide which way I should go. I found a postgres-operator to be run on a kubernetes cluster: https://github.com/zalando/postgres-operator. And a guide to setup postgres HA with patroni: https://arctype.com/blog/postgres-patroni/

  • dbmate

    :rocket: A lightweight, framework-agnostic database migration tool.

    Project mention: I greatly dislike ORMs, but I find myself wanting ORM agnostic SQL migration tools. What do you use to perform RDBMS table migrations outside of an ORM? | reddit.com/r/ExperiencedDevs | 2022-11-08
  • graphjin

    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?

  • wal-g

    Archival and Restoration for databases in the Cloud

    Project mention: WAL-G 2.0: backup and restore for database in the cloud | news.ycombinator.com | 2022-06-23
  • algernon

    :tophat: Small self-contained pure-Go web server with Lua, Markdown, HTTP/2, QUIC, Redis and PostgreSQL support

  • sqler

    write APIs using direct SQL queries with no hassle, let's rethink about SQL

    Project mention: sqler: Write APIs using direct SQL queries with no hassle, let's rethink about SQL | reddit.com/r/himigifavievcu | 2022-07-29
  • goqu

    SQL builder and query library for golang

    Project mention: ORM in Golang? | reddit.com/r/golang | 2022-11-28

    Try this

  • Scout APM

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

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). The latest post mention was on 2022-11-30.

Go Postgresql related posts


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

Project Stars
1 usql 7,668
2 pgweb 7,572
3 sqlc 6,780
4 SQLBoiler 5,357
5 go-pg 5,271
6 FerretDB 4,950
7 bytebase 4,339
8 Miniflux 4,298
9 octosql 4,192
10 steampipe 4,107
11 stolon 3,905
12 pREST 3,442
13 xo 3,270
14 upper.io/db 3,221
15 goose 3,156
16 postgres-operator 3,042
17 postgres-operator 2,940
18 dbmate 2,925
19 graphjin 2,412
20 wal-g 2,384
21 algernon 2,145
22 sqler 2,020
23 goqu 1,747
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.