Go Postgresql

Open-source Go projects categorized as Postgresql

Top 23 Go Postgresql Projects

  1. Gogs

    Gogs is a painless self-hosted Git service

    Project mention: Revolutionize Your Workflow: Gogs, the Self-Hosted Git Server You've Been Waiting For! | dev.to | 2025-04-20

    View the Project on GitHub

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. sqlc

    Generate type-safe code from SQL

    Project mention: Sqlc: Generate type-safe code from SQL | news.ycombinator.com | 2025-04-16
  4. bytebase

    World's most advanced database DevSecOps solution for Developer, Security, DBA and Platform Engineering teams. The GitHub/GitLab for database DevSecOps.

    Project mention: Postgres 🐘 vs. SQL Server: a Complete Comparison βš–οΈ in 2025 | dev.to | 2025-04-01

    This post is maintained by Bytebase, an open-source database DevSecOps tool that can manage both Postgres and SQL Server. We update the post every year.

  5. FerretDB

    A truly Open Source MongoDB alternative

    Project mention: Beekeeper-studio/queryleaf: SQL for Mongo | news.ycombinator.com | 2025-05-08

    FerretDB v2 is built on top of this extension. See https://github.com/FerretDB/FerretDB

  6. Encore

    Open Source Development Platform for building robust type-safe distributed systems with declarative infrastructure

    Project mention: Go doesn't believe in frameworks, but teams still need them | dev.to | 2025-04-30

    Encore.go brings the structure, defaults, and tooling that Go leaves out, helping teams ship faster with fewer DevOps headaches and less duplicated effort.

  7. usql

    Universal command-line interface for SQL databases

    Project mention: Why is database support in every language bad? | news.ycombinator.com | 2025-03-02

    frameworks / ORM are just specilized database graphical user interface front ends designed to simplify how data is displayed/inputed

    Database management systems usually provide a way of importing/exporting 'raw' data via sql statement(s) results. aka cvs, comma delimited, html formatted, json formatted, etc. aka do command line sql query with 'html formatted output' and open results of file in a brower.

    postgres psql provides an interactive 'cli' environment; windows sql server - sqlcmd;

    usql[1] provides something similar to psql for no-sql databases.

    sqlc is sorta the equivalent of combining the command line shell & sql queries. SQLx rust is rust extention for handling 'sql from command line, just via rust language, instead of going through command line shell.'

    ----

    [1] : https://github.com/xo/usql

  8. pgweb

    Cross-platform client for PostgreSQL databases

    Project mention: Database management in a single PHP file | news.ycombinator.com | 2025-03-17

    Another in this vein is "pgweb" for PostgreSQL, just need a binary to run its web interface.

    https://github.com/sosedoff/pgweb

  9. SaaSHub

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

    SaaSHub logo
  10. goose

    A database migration tool. Supports SQL migrations and Go functions. (by pressly)

    Project mention: How to handle migrations in Golang | dev.to | 2024-06-11

    goose

  11. Miniflux

    Minimalist and opinionated feed reader

    Project mention: Reading RSS content is a skilled activity | news.ycombinator.com | 2025-04-25

    My problem with RSS is that I tend to subscribe to too many things and then it's too much. Also I wanted a solution that was free or self hosted, but I realized it's much better if someone manages the complexity for me, so I just ended up going with the paid hosting for miniflux (https://miniflux.app/).

    Now I've just subscribed to a few things I care about, I open the website from time to time, quickly mark as "read" stuff I'm not interested in, and when I have more time I just go through everything that is still unread, because it's been "filtered in". Seems to work!

  12. steampipe

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

    Project mention: Show HN: TextQuery – Query CSV, JSON, XLSX Files with SQL | news.ycombinator.com | 2025-05-05

    Readers may also enjoy Steampipe [1], an open source tool to live query 140+ services with SQL (e.g. AWS, GitHub, CSV, Kubernetes, etc). It uses Postgres Foreign Data Wrappers under the hood and supports joins etc with other tables. (Disclaimer - I'm a lead on the project.)

    1 - https://github.com/turbot/steampipe

  13. SQLBoiler

    Generate a Go ORM tailored to your database schema.

    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

  14. dbmate

    πŸš€ A lightweight, framework-agnostic database migration tool.

    Project mention: FastAPI in Prod: Handling DB migrations, auth, and more | dev.to | 2025-02-18

    dbmate – A simple, language-agnostic approach to managing database migrations.

  15. 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: Xata: Postgres at scale, with copy-on-write branching and anonymization | news.ycombinator.com | 2025-05-17

    > we deploy the Postgres instances on Kubernetes via the CloudNativePG operator.

    I'm curious if split brain cases already happeened. At scale, it should be so https://github.com/cloudnative-pg/cloudnative-pg/issues/7407

  16. go-pg

    Golang ORM with focus on PostgreSQL features and performance

  17. 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: Feldera Incremental Compute Engine | news.ycombinator.com | 2024-09-29
  18. pgroll

    PostgreSQL zero-downtime migrations made easy

    Project mention: EdgeDB is now Gel and Postgres is the Future | news.ycombinator.com | 2025-02-25

    (xata employee)

    I totally agree with schema migrations being painful, have you seen the open-sourc e tool we developed to tackle this problem? It is called pgroll: https://github.com/xataio/pgroll

    Any feedback is appreciated!

  19. stolon

    PostgreSQL cloud native High Availability and more.

  20. postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

    Project mention: Postgres in prod. Part 1 - setup and startup for growth. | dev.to | 2025-01-30

    There are two major ways to deploy Postgres to Kubernetes. First is using Helm charts like bitnami/postgresql or Serge’s postgresql-single, which has benefits compared to bitnami chart. The second way to run Postgres is to use the Kubernetes operator. There are a couple of them, here we will talk about Zalando Postgres operator. The helm way is better when in the future you will not plan to use more than one or two Postgres clusters per Kubernetes cluster. If you realize, that you will run more, then the Operator way is for you with all its automation and management advantages. Here is an example of PostgreSQL database manifest for Zalando Postgres Operator pg-prod.yaml. This example was tested for intensive transaction processing with query rates up to 3000-4000 per second and database size up to 350GB (data and indexes). It is enough to start most projects with thousands of active users like medium-volume webshops, news- and community-support websites, medium-sized gaming or gambling, etc. We assume, that we already set up the operator and the S3 bucket with encryption and access control for backups and WAL-log storage.

  21. pREST

    PostgreSQL βž• REST, low-code, simplify and accelerate development, ⚑ instant, realtime, high-performance on any Postgres application, existing or new

  22. go-coffeeshop

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

  23. bun

    SQL-first Golang ORM (by uptrace)

  24. postgres-operator

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

    Project mention: Show HN: Serverless Postgres | news.ycombinator.com | 2024-05-29
  25. river

    Fast and reliable background jobs in Go (by riverqueue)

    Project mention: Show HN: Hatchet v1 – a task orchestration platform built on Postgres | news.ycombinator.com | 2025-04-03

    Perceived only at this stage, though the kind of volume we’re looking at is 10s to 100s of millions of jobs per day. https://github.com/riverqueue/river/issues/746 talks about some of the same things you mention.

    To be clear, I really like the model of riverqueue and will keep going at a leisurely pace since this is a personal time interest at the moment. I’m sick of celery and believe a service is a better model for background tasks than a language-specific tool.

    If you guys were to build http ingestion and http targets I’d try and deploy it right away.

  26. SaaSHub

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

    SaaSHub logo
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 Postgresql discussion

Log in or Post with

Go Postgresql related posts

  • CloudNativePG: Run PostgreSQL inside Kubernetes

    1 project | dev.to | 5 May 2025
  • DoltgreSQL – Version Controlled PostgreSQL

    1 project | news.ycombinator.com | 20 Apr 2025
  • Sqlc: Generate type-safe code from SQL

    1 project | news.ycombinator.com | 16 Apr 2025
  • Show HN: Beta for Doltgres, the Postgres Version of Dolt

    1 project | news.ycombinator.com | 16 Apr 2025
  • Hacking the Postgres Wire Protocol

    8 projects | news.ycombinator.com | 15 Apr 2025
  • Postgres 🐘 vs. SQL Server: a Complete Comparison βš–οΈ in 2025

    1 project | dev.to | 1 Apr 2025
  • You Can Make Postgres Scale

    5 projects | news.ycombinator.com | 14 Mar 2025
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 19 May 2025
    InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now. Learn more β†’

Index

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

# Project Stars
1 Gogs 46,362
2 sqlc 15,023
3 bytebase 12,399
4 FerretDB 10,130
5 Encore 9,992
6 usql 9,365
7 pgweb 8,879
8 goose 8,354
9 Miniflux 7,614
10 steampipe 7,321
11 SQLBoiler 6,863
12 dbmate 5,988
13 cloudnative-pg 5,973
14 go-pg 5,716
15 octosql 5,035
16 pgroll 4,986
17 stolon 4,726
18 postgres-operator 4,696
19 pREST 4,351
20 go-coffeeshop 4,235
21 bun 4,163
22 postgres-operator 4,116
23 river 4,109

Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com

Did you know that Go is
the 4th most popular programming language
based on number of references?