Go Postgres

Open-source Go projects categorized as Postgres

Top 23 Go Postgre Projects

  • Gravitational Teleport

    Protect access to all of your infrastructure

    Project mention: Release Radar • February 2024 Edition | dev.to | 2024-02-29

    Are you looking to set up SSO for your cloud infrastructure? Or maybe establish tunnels to access services behind NATs and firewalls. Then Teleport is for you. It provides connectivity, authentication, access controls and audit for infrastructure. The newest update has a tonne of new features and improvements including enhanced device trust support, SSH connection resumption, MFA for admin actions, improved provisioning for Okta, and heaps. more. Check out all the changes in the Teleport release notes.

  • migrate

    Database migrations. CLI and Golang library.

    Project mention: How to use SQLC with Golang | dev.to | 2024-01-03

    $ curl -L https://github.com/golang-migrate/migrate/releases/download/$version/migrate.$os-$arch.tar.gz | tar xvz

  • 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: Resend – Incident report for February 21st, 2024 | news.ycombinator.com | 2024-02-23

    We have been working on bytebase (https://github.com/bytebase/bytebase) for 3+ years to address this. With a change review workflow, environment propagations, and try not to disturb the dev flow if possible.

  • 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: NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB | dev.to | 2024-02-23

    FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.

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

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

  • WorkOS

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

  • 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
  • space-cloud

    Open source Firebase + Heroku to develop, scale and secure serverless apps on Kubernetes

    Project mention: ⚡⚡ Level Up Your Cloud Experience with These 7 Open Source Projects 🌩️ | /r/Cloud | 2023-12-07

    Space Cloud

  • 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
  • wal-g

    Archival and Restoration for databases in the Cloud

    Project mention: Introducing Read Replicas | dev.to | 2023-12-15

    Streaming replication minimizes replication lag, while file-based log shipping provides a fallback. For file-based log shipping, we use our existing Point In Time Recovery (PITR) infrastructure. We regularly archive files from the primary using WAL-G, an open source archival and restoration tool, and ship the WAL files to S3.

  • cloudnative-pg

    CloudNativePG is a Kubernetes operator that covers the full lifecycle of a PostgreSQL database cluster with a primary/standby architecture, using native streaming replication

    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.

  • goqu

    SQL builder and query library for golang

    Project mention: newbie here looking for a framework | /r/golang | 2023-10-03

    For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/

  • pgroll

    PostgreSQL zero-downtime migrations made easy

    Project mention: Revolutionizing PostgreSQL Schema Changes with pg-osc | news.ycombinator.com | 2024-02-18
  • go-oauth2-server

    A standalone, specification-compliant, OAuth2 server written in Golang.

  • jet

    Type safe SQL builder with code generation and automatic query result data mapping

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

    We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.


  • river

    Fast and reliable background jobs in Go (by riverqueue)

    Project mention: Postgres as Queue | news.ycombinator.com | 2024-02-09
  • peerdb

    Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage

    Project mention: Show HN: Open-source x64 and Arm GitHub runners. Reduces GitHub Actions bill 10x | news.ycombinator.com | 2024-01-30

    We've been using the Ubicloud runner for a while at PeerDB[1]. Great value and specially the ARM runners have been helpful to get our CI costs down. The team is really responsive and added the arm runner support within a few weeks of us requesting it.

    [1] https://github.com/PeerDB-io/peerdb

  • go-base

    Go RESTful API Boilerplate with JWT Authentication backed by PostgreSQL

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

    Project mention: How to unit test your database interactions with Docker | /r/golang | 2023-03-24

    https://github.com/orlangure/gnomock does this pretty well, but I liked your solution too, it is neat.

  • kubegres

    Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances and manage databases replication, failover and backup.

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

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

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

Go Postgres related posts


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

Project Stars
1 Gravitational Teleport 15,927
2 migrate 13,525
3 bytebase 9,449
4 usql 8,482
5 FerretDB 8,312
6 SQLBoiler 6,324
7 goose 5,274
8 dbmate 4,187
9 pREST 4,045
10 space-cloud 3,889
11 postgres-operator 3,856
12 postgres-operator 3,647
13 wal-g 2,920
14 cloudnative-pg 2,910
15 goqu 2,178
16 pgroll 2,136
17 go-oauth2-server 2,082
18 jet 1,903
19 river 1,722
20 peerdb 1,473
21 go-base 1,410
22 gnomock 1,290
23 kubegres 1,278
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives