SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Go Postgre Projects
-
Gravitational Teleport
The easiest, and most secure way to access and protect all of your infrastructure.
To save others the search: https://github.com/gravitational/teleport/pull/35259 Apache to AGPLv3
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Go doesn't support migrations natively for that propuso we can use the popular golang-migrate package also if you use an ORM like GORM you can use it for that.
-
bytebase
World's most advanced database DevSecOps solution for Developer, Security, DBA and Platform Engineering teams. The GitHub/GitLab for database DevSecOps.
Bytebase is a database DevSecOps platform designed for developers, security, DBA, and platform engineering teams.
-
-
Project mention: Usql: Universal command-line interface for SQL databases | news.ycombinator.com | 2024-11-16
It seems to support quite a large number of database drivers. If file size is such a concern you could recompile it with unneeded drivers omitted.
https://github.com/xo/usql?tab=readme-ov-file#building
-
goose
-
Project mention: Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go | news.ycombinator.com | 2024-05-28
If you're using Go, sqlboiler can do this for you in most common cases (e.g., fetch all the Users matching this filter, and for each User, fetch the related Company)
https://github.com/volatiletech/sqlboiler
-
Project mention: Seamless Integration Testing for Your Go Application on GitHub Actions with PostgreSQL | dev.to | 2024-11-22
name: ci-test on: push: branches: [main] pull_request: branches: [main] env: POSTGRES_USER: postgres POSTGRES_PASSWORD: Password123 POSTGRES_DB: crud_db jobs: build: name: tests runs-on: ubuntu-latest services: postgres: image: postgres env: POSTGRES_USER: ${{ env.POSTGRES_USER }} POSTGRES_PASSWORD: ${{ env.POSTGRES_PASSWORD }} POSTGRES_DB: ${{ env.POSTGRES_DB }} ports: - 5432:5432 options: >- --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 steps: - uses: actions/checkout@v4 - name: Set up Go uses: actions/setup-go@v4 with: go-version: "1.22" - name: Install dbmate for golang migrations run: | sudo curl -fsSL -o /usr/local/bin/dbmate https://github.com/amacneil/dbmate/releases/latest/download/dbmate-linux-amd64 sudo chmod +x /usr/local/bin/dbmate which dbmate - name: Construct DB URL id: construct_url run: echo "DB_URL=postgres://${{ env.POSTGRES_USER }}:${{ env.POSTGRES_PASSWORD }}@localhost:5432/${{ env.POSTGRES_DB }}?sslmode=disable" >> $GITHUB_ENV - run: env - name: Make Migrations run: make migrations URL=${{ env.DB_URL }} - name: Seed test DB run: go run db/seed.go - name: Test run: make test
-
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: Data on Kubernetes: Part 2 - Deploying Databases in K8s with PostgreSQL, CloudNative-PG, and Ceph Rook on Amazon EKS | dev.to | 2024-07-15In this blog post, we'll explore how to combine CloudNative-PG (a PostgreSQL operator) and Ceph Rook (a storage orchestrator) to create a PostgreSQL cluster that scales easily, recovers from failures, and ensures data persistence - all within an Amazon Elastic Kubernetes Service EKS cluster.
-
Project mention: Zalando Postgres-Operator: creates and manages PostgreSQL clusters in Kubernetes | news.ycombinator.com | 2024-09-10
-
pREST
PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
-
postgres-operator
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service. (by CrunchyData)
-
space-cloud
Open source Firebase + Heroku to develop, scale and secure serverless apps on Kubernetes
-
Project mention: Do you need Redis? PostgreSQL does queuing, locking, and pub/sub | news.ycombinator.com | 2024-11-03
https://riverqueue.com/ (Go)
-
Project mention: WAL-G 3.0.0 – fast disaster recovery for Postgres | news.ycombinator.com | 2024-03-17
-
It gets mentioned a lot in the context of database/sql and sqlc alternatives, but Jet has been a great alternative so far, most notably because of its non-issue with dynamic queries support.
https://github.com/go-jet/jet/
-
I've been using Go with Goqu [1] for SQL for a lot of things lately. But, the language shouldn't matter much. The functions are just building the appropriate SQL clauses.
For some of the operations, the method I was using required marshaling the inputs to JSON before sending them over the wire. And that's nicer in a non SQL programming language. But both db's ultimately do have json_build_array/json_build_object for PostgreSQL or json_array/json_object for SQLite3.
[1] https://github.com/doug-martin/goqu
-
peerdb
Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage
Sai from ClickHouse here. Have been living and breathing past year helping customers integrating Postgres and ClickHouse to form their data stack. Totally agreed with this statement - there are numerous production grade workloads solving most of their data problems using these purpose-built Open Source database. My team at ClickHouse has been working to make the integration even seamless. :) We work on PeerDB, an open source tool enabling seamless Postgres CDC to ClickHouse https://github.com/PeerDB-io/peerdb/ This integration is now als natively available in the Cloud through ClickPipes. The private preview was released just last week https://clickhouse.com/blog/postgres-cdc-connector-clickpipe...
-
Project mention: Show HN: I built jq-like scriptable tool to query CSV and JSON with SQLite | news.ycombinator.com | 2024-02-24
Is this related to the other SQ? https://github.com/neilotoole/sq
-
-
-
gnomock
Test your code without writing mocks with ephemeral Docker containers 📦 Setup popular services with just a couple lines of code ⏱️ No bash, no yaml, only code 💻
-
kubegres
Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.
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 Postgres discussion
Go Postgres related posts
-
Show HN: SRTD – Live-reloading SQL templates for Supabase migrations
-
Top DevSecOps Tools for 2025
-
Kuvasz-streamer: open-source CDC for Postgres for low latency replication
-
Ask HN: Seeking feedback on my Postgres TypeScript thing
-
Pg_flo – Stream, transform, and route PostgreSQL data in real-time
-
Stream, transform, and route PostgreSQL data in real-time
-
Stream, transform, and route PostgreSQL data in real-time (early build)
-
A note from our sponsor - SaaSHub
www.saashub.com | 20 Jan 2025
Index
What are some of the best open-source Postgre projects in Go? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Gravitational Teleport | 17,886 |
| 2 | migrate | 15,914 |
| 3 | bytebase | 11,824 |
| 4 | FerretDB | 9,282 |
| 5 | usql | 9,169 |
| 6 | goose | 7,456 |
| 7 | SQLBoiler | 6,792 |
| 8 | dbmate | 5,610 |
| 9 | cloudnative-pg | 5,130 |
| 10 | postgres-operator | 4,477 |
| 11 | pREST | 4,267 |
| 12 | postgres-operator | 4,022 |
| 13 | space-cloud | 3,955 |
| 14 | river | 3,729 |
| 15 | wal-g | 3,386 |
| 16 | jet | 2,828 |
| 17 | goqu | 2,440 |
| 18 | peerdb | 2,353 |
| 19 | sq | 2,198 |
| 20 | go-oauth2-server | 2,120 |
| 21 | go-base | 1,520 |
| 22 | gnomock | 1,418 |
| 23 | kubegres | 1,320 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com