Go Postgres

Open-source Go projects categorized as Postgres

Top 23 Go Postgre Projects

  • Gravitational Teleport

    The easiest, most secure way to access infrastructure.

    Project mention: Passkeys for Infrastructure | news.ycombinator.com | 2023-02-21

    OP here, thanks for posting! Happy to Answer any questions. I have to give our a shoutout to Alan at Teleport for all his work on Passwordless and his work to make Passwordless / TouchID work with MacOS CLI https://github.com/gravitational/teleport/blob/master/rfd/00...

  • migrate

    Database migrations. CLI and Golang library.

    Project mention: is golang-migrate safe in production,i may be obsessive here , but anything that deals with db in production makes me very worried.. this tool installed in linux by a bash , then use cli to get the connection string , so is there any vulnerability to send the connection string out of my project? | reddit.com/r/golang | 2023-03-06
  • 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.

  • usql

    Universal command-line interface for SQL databases

    Project mention: Usql – Universal command-line interface for SQL databases | news.ycombinator.com | 2022-12-30
  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

    Project mention: Are there any decent ORMs in Golang? | reddit.com/r/golang | 2023-03-11


  • FerretDB

    A truly Open Source MongoDB alternative

    Project mention: FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale | dev.to | 2023-01-19

    YugabyteDB has a Cassandra-compatible API (called YCQL) and a PostgreSQL-compatible one (called YSQL). What if you have an application written for MongoDB that you want to move to a SQL database? You probably want to rewrite it to benefit from SQL features but, rather than re-writing all at the same time, you can add a MongoDB-compatible API on top of PostgreSQL thanks to FerretDB.

  • bytebase

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

    Project mention: Ask HN: How do you test SQL? | news.ycombinator.com | 2023-01-31

    We built a GUI based solution called https://github.com/bytebase/bytebase. You may also take a look.

  • space-cloud

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

    Project mention: Show HN: Algorithmic Trading for Everyone | news.ycombinator.com | 2022-04-21
  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • 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 | reddit.com/r/vuejs | 2023-03-12
  • goose

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

    Project mention: Are there any decent ORMs in Golang? | reddit.com/r/golang | 2023-03-11
  • postgres-operator

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

    Project mention: My girlfriend left me... I have a K8S cluster, argocd, longhorn, traefik, metallb, on 3 optiplex mff with proxmox... This is the start gentlemen, i'll post back in 1 year. This dashboard will be full my friends, I promise, see you in the rabbit hole o/ | reddit.com/r/homelab | 2023-02-13

    For postgres you can also have a look at PGO or bitnami helm chart

  • postgres-operator

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

    Project mention: Databases on Kubernetes is fundamentally same as a database on a VM | news.ycombinator.com | 2023-02-11

    And that repo you linked to has 1846 issues, 161 open. Which doesn't seem extraordinary based on my limited exposure to k8s.

    Another example: https://github.com/zalando/postgres-operator/issues with 445 open issues. Why?

    Maybe I'm wrong and this is all a good sign of progress, but my impression is that the entire k8s ecosystem is held together with reused duct tape.

  • dbmate

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

    Project mention: Working with TypeORM 0.3x with Nestjs - I wasn't aware so many people were facing issues with it | reddit.com/r/nestjs | 2023-02-27

    In general with ORMs, you will face a problem in one way or another. I ended up simply using https://github.com/gajus/slonik and https://github.com/amacneil/dbmate for migrations. My life is way much better since then.

  • 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
  • go-oauth2-server

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

  • goqu

    SQL builder and query library for golang

    Project mention: ORM or no ORM (and which ones)? | reddit.com/r/golang | 2023-01-17

    SQL Builders (think squirrel or goqu)

  • database-lab-engine

    DLE enables 🖖 DB branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.

    Project mention: Neon – Serverless Postgres | news.ycombinator.com | 2022-05-27

    Agreed, this direction is underestimated and should be developed better -- we (Postgres.ai) do it for any Postgres with our Database Lab Engine [1], and Neon would bring even more power if it's installed on production

    [1] https://github.com/postgres-ai/database-lab-engine

  • go-base

    Go RESTful API Boilerplate with JWT Authentication backed by PostgreSQL

    Project mention: Go-RN StarterKit: Crafting the idea | dev.to | 2022-06-15

    Go RESTful API Boilerplate by dhax https://github.com/dhax/go-base

  • 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: Any self hostable postgres, clustering, replication and fail over system? | reddit.com/r/selfhosted | 2023-01-25

    I don't know if you're using Kubernetes, but Kubegres is great for self hosting postgres on a cluster.

  • jet

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

    Project mention: Any mid sized / big open source code base in golang that makes use of SQL DBs? | reddit.com/r/golang | 2023-02-18

    I have tried doing that, but was unable to get it to work. I posted about it in a discussion here: https://github.com/go-jet/jet/discussions/215

  • 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: Writing tests for APIs | reddit.com/r/golang | 2023-03-07

    gnomock https://github.com/orlangure/gnomock - like testcontainers

  • 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: Can you create a Postgres Deployment with multiple replicas consuming to the same PV? | reddit.com/r/devops | 2022-11-28

    Another option would be https://github.com/cloudnative-pg/cloudnative-pg I got to see this talk at Kubecon last month that might be of use to you too -> https://www.youtube.com/watch?v=99uSJXkKpeI That talk is run in part by EDB, who are the company behind CloudNativePG, they are talking about their commercial offering, but the principle is the same.

  • inquery

    Safeguard your Postgres database

    Project mention: Inquery: Open-Source Safe Data Changes for PostgreSQL | reddit.com/r/selfhosted | 2023-03-14
  • pgmetrics

    Collect and display information and stats from a running PostgreSQL server

  • 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 2023-03-14.

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 13,958
2 migrate 11,038
3 usql 7,914
4 SQLBoiler 5,668
5 FerretDB 5,242
6 bytebase 5,081
7 space-cloud 3,747
8 pREST 3,672
9 goose 3,652
10 postgres-operator 3,205
11 postgres-operator 3,170
12 dbmate 3,152
13 wal-g 2,483
14 go-oauth2-server 1,993
15 goqu 1,849
16 database-lab-engine 1,545
17 go-base 1,267
18 kubegres 1,139
19 jet 1,088
20 gnomock 1,084
21 cloudnative-pg 1,057
22 inquery 1,013
23 pgmetrics 830
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives