Go Postgresql

Open-source Go projects categorized as Postgresql

Top 23 Go Postgresql Projects

  • Gogs

    Gogs is a painless self-hosted Git service

    Project mention: Forgejo forks its own path forward | news.ycombinator.com | 2024-02-16

    > Gitea but the other one

    Wouldn't that also be Gogs? https://gogs.io/

    I remember when that one was what a lot of people were looking into, before the Gitea fork happened. It's odd to see how this has happened yet again, but I guess is a good thing that it's even possible in the first place, if there are indeed differing values and goals?

  • sqlc

    Generate type-safe code from SQL

    Project mention: API completa em Golang - Parte 7 | dev.to | 2024-02-03
  • 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.

  • 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: PostgreSQL Is Enough | news.ycombinator.com | 2024-02-06

    Migrations. All my database logic lives in version control.

    Popular tooling like Phoenix, Hasura, etc have good built in migration stories.

    https://www.bytebase.com looks really promising.

    Hover, I do struggle with one big issue: changing database logic (views, functions, etc) that has other logic dependent on it. This seems like a solvable problem.

  • usql

    Universal command-line interface for SQL databases

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

    A truly Open Source MongoDB alternative

    Project mention: FerretDB – Run Mongo over your Postgres instance | news.ycombinator.com | 2024-02-18
  • pgweb

    Cross-platform client for PostgreSQL databases

    Project mention: Ask HN: What apps have you created for your own use? | news.ycombinator.com | 2023-12-12

    Built Pgweb (Postgres GUI) some time ago since I could not find a good minimalistic database explorer.


    The app is super simple, made with Go + jQuery and I still use it almost every day, and has brought it to every single company I've been with.

  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

    Project mention: Go ORMs Compared | dev.to | 2024-01-18

    SQLBoiler takes a database-first approach, generating Go code from your database schema. This means it creates highly optimized and custom-tailored code for your specific database schema. SQLBoiler is great for applications where the database schema is well-defined and changes infrequently. However, like sqlc, it requires regenerating the code when the database schema changes. It's well-suited for projects where performance is a key concern and the database design is stable​.

  • WorkOS

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

  • steampipe

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

    Project mention: How to run an AWS CIS v3.0 assessment in CloudShell | dev.to | 2024-02-08

    In a prior post I showed how to install Steampipe in AWS CloudShell to instantly query over 460+ resource types from your AWS APIs using SQL, and another post on how to use the Steampipe AWS Compliance mod to assess over 25+ security benchmarks across your AWS accounts.

  • Miniflux

    Minimalist and opinionated feed reader

    Project mention: First-Gen Social Media Users Have Nowhere to Go | news.ycombinator.com | 2024-02-05

    I see this all the time and while at the time I thought the same there's so many good alternatives these days, even better than back then. All the interesting and small websites I want to follow still have RSS feeds so I feel like we can move on.

    The two I use for many years already are:

    - https://miniflux.app (OS, Minimal, web interface and can be used with all clients that support Fever or Google Reader API)

    - https://reederapp.com

  • go-pg

    Golang ORM with focus on PostgreSQL features and performance

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

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

  • stolon

    PostgreSQL cloud native High Availability and more.

    Project mention: How to create postgres cluster in docker swarm? | /r/node | 2023-06-18

    There's one in the stolon repo.

  • Encore

    Encore is the end-to-end Backend Development Platform that lets you escape cloud complexity.

    Project mention: Using Pub/Sub for event-driven Go backends | dev.to | 2024-02-16

    At Encore, we've made it easier by making Pub/Sub is a native component in Encore's Open Source Infrastructure SDK.

  • dbmate

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

    Project mention: Level UP your RDBMS Productivity in GO | dev.to | 2023-12-05

    As we want to maintain the track of our changes to the DB, we are going to use migrations. In this case, we are going to use dbmate. But, you can use any other tool you want.

  • pREST

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

    Project mention: Need help connecting VueJS 3 UI to a database | /r/vuejs | 2023-03-12
  • go-coffeeshop

    ☕ A practical event-driven microservices demo built with Golang. Nomad, Consul Connect, Vault, and Terraform for deployment

    Project mention: Could you share an microservices architecture having synchronous and async(kafka) and Caching(Redis) used in your Organization. | /r/microservices | 2023-03-28
  • postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

    Project mention: Run PostgreSQL. The Kubernetes Way | news.ycombinator.com | 2023-09-22

    yes, precisely. It's UI part that's broken, which cannot list snapshots. Issue is here, no fix since 2020, sadly: https://github.com/zalando/postgres-operator/issues/937

  • postgres-operator

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

    Project mention: No disk space crashloop but pod healthy · Issue #3788 · CrunchyData/postgres-operator | /r/Health2020 | 2023-12-09
  • 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.

  • goxygen

    Generate a modern Web project with Go and Angular, React, or Vue in seconds 🎲

    Project mention: Goxygen v0.6.0 is released adding support for Go 1.20 | /r/golang | 2023-06-30
  • tbls

    tbls is a CI-Friendly tool for document a database, written in Go.

    Project mention: FLaNK 25 December 2023 | dev.to | 2023-12-26
  • Onboard AI

    ChatGPT with full context of any GitHub repo. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at app.getonboardai.com.

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 2024-02-18.

Go Postgresql related posts


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

Project Stars
1 Gogs 43,815
2 sqlc 10,148
3 bytebase 9,395
4 usql 8,466
5 FerretDB 8,260
6 pgweb 8,211
7 SQLBoiler 6,312
8 steampipe 6,144
9 Miniflux 5,873
10 go-pg 5,538
11 goose 5,209
12 octosql 4,665
13 stolon 4,477
14 Encore 4,315
15 dbmate 4,154
16 pREST 4,039
17 go-coffeeshop 3,865
18 postgres-operator 3,848
19 postgres-operator 3,641
20 xo 3,525
21 upper.io/db 3,443
22 goxygen 3,323
23 tbls 2,958
ChatGPT with full context of any GitHub repo.
Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at app.getonboardai.com.