Go Postgres

Open-source Go projects categorized as Postgres | Edit details

Top 23 Go Postgre Projects

  • GitHub repo Gravitational Teleport

    Certificate authority and access plane for SSH, Kubernetes, web apps, databases and desktops

    Project mention: Problem with setting up Teleport cluster | reddit.com/r/kubernetes | 2022-01-16

    I don't know how many of you know of teleport or use it, but I have some problems setting it up in a new k8s cluster. I've created a GitHub Issue but it seems activity on issues in general in that repo is a bit scarce. I'm in no hurry setting up something like teleport but it still blocks me from further working on my projects.

  • GitHub repo migrate

    Database migrations. CLI and Golang library.

    Project mention: Clean Architecture based sample in Golang | reddit.com/r/golang | 2022-01-10

    Makefile requires migrate - a migration tool: https://github.com/golang-migrate/migrate. I stated it in Makefile and in README, but it's probably not very obvious: Requirements: migrate Migration tool: https://github.com/golang-migrate/migrate

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • GitHub repo SQLBoiler

    Generate a Go ORM tailored to your database schema.

    Project mention: Sql generator but for SQLite | reddit.com/r/golang | 2021-12-26

    Try sqlboiler. https://github.com/volatiletech/sqlboiler

  • GitHub repo FerretDB

    A truly Open Source MongoDB alternative

    Project mention: Use PostgreSQL as pure NoSQL database | reddit.com/r/PostgreSQL | 2022-01-07

    Well, alternatively there's FerretDB (formerly MangoDB), which

  • GitHub repo space-cloud

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

    Project mention: Firebase Alternative for iOS | reddit.com/r/iOSProgramming | 2021-09-04
  • GitHub repo pREST

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

    Project mention: Constant work to onboarding new members into engineering team | dev.to | 2022-01-07

    Improve local tests execution — it is frustrating that someone wants to contribute and cannot run the local tests (we use e2e tests, making requests to prestd's own API), a way was implemented where the tests run inside docker using docker-compose;

  • GitHub repo postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

    Project mention: PostgreSQL on Cloud SQL or GKE a Kubernetes Node? | reddit.com/r/googlecloud | 2021-11-26

    Here are a couple kubernetes operators for Postgres: zaland /postgres-operator, CrunchyData/postgres-operator.

  • SonarLint

    Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  • GitHub repo postgres-operator

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

    Project mention: PostgreSQL on Cloud SQL or GKE a Kubernetes Node? | reddit.com/r/googlecloud | 2021-11-26

    Here are a couple kubernetes operators for Postgres: zaland /postgres-operator, CrunchyData/postgres-operator.

  • GitHub repo goose

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

    Project mention: Golang for backend | reddit.com/r/golang | 2021-12-01

    https://github.com/pressly/goose. This migration tool is close to alembic.

  • GitHub repo wal-g

    Archival and Restoration for Postgres

    Project mention: Optimizing Postgres Queries at Scale | news.ycombinator.com | 2021-12-28
  • GitHub repo go-oauth2-server

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

  • GitHub repo goqu

    SQL builder and query library for golang

    Project mention: Migrating from PHP to Go | reddit.com/r/golang | 2021-09-30

    https://github.com/doug-martin/goqu for building SQL queries. Supports MySQL and Postgres at least - super handy!

  • GitHub repo pgmetrics

    Collect and display information and stats from a running PostgreSQL server

    Project mention: How to monitor streaming relication. | reddit.com/r/PostgreSQL | 2021-07-30

    pgmetrics is an open source tool that queries such things from relevant pg_catalog views and outputs json. You can even just copy out the queries you want from the code

  • GitHub repo 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 mock DB for unit tests? | reddit.com/r/golang | 2021-02-08

    You could check out Gnomock (https://github.com/orlangure/gnomock). It offers a different approach than what you asked, but maybe it'll suit your use case. It allows to easily setup a real DB like postgres in a docker container and then delete ot when tests are done.

  • GitHub repo jet

    Type safe SQL builder with code generation and automatic query result data mapping (by go-jet)

    Project mention: Sql generator but for SQLite | reddit.com/r/golang | 2021-12-26

    Jet has full support for SQLite. https://github.com/go-jet/jet

  • GitHub repo dat

    Go Postgres Data Access Toolkit (by mgutz)

    Project mention: Twelve Years of Go | news.ycombinator.com | 2021-11-10

    There are ORMs available for Golang, but my experience has been better with packages like sqlx [1] or dat [2]. We've since been using SQLX for pretty much all DBMS related work, and regret nothing. In my experience SQLX gave us the right balance between abstraction and control.

    [1] http://jmoiron.github.io/sqlx/

    [2] https://github.com/mgutz/dat

  • GitHub repo Satellity

    Yet another open source forum written in Golang, React and PostgreSQL.

  • GitHub repo gnorm

    A database-first code generator for any language

    Project mention: We Went All in on Sqlc/Pgx for Postgres and Go | news.ycombinator.com | 2021-09-08

    I'm a big fan of the database first code generator approach to talking to an SQL database, so much so that I wrote pggen[1] (not to be confused with pggen[2], as far as I can tell a sqlc fork, which I just recently learned about).

    I'm a really big partisan of this approach, but I think I'd like to play the devil's advocate here and lay out some of the weaknesses of both a database first approach in general and sqlc in particular.

    All database first approaches struggle with SQL metaprogramming when compared with a query builder library or an ORM. For the most part, this isn't an issue. Just writing SQL and using parameters correctly can get you very far, but there are a few times when you really need it. In particular, faceted search and pagination are both most naturally expressed via runtime metaprogramming of the SQL queries that you want to execute.

    Another drawback is poor support from the database for this kind of approach. I only really know how postgres does here, and I'm not sure how well other databases expose their queries. When writing one of these tools you have to resort to tricks like creating temporary views in order infer the argument and return types of a query. This is mostly opaque to the user, but results in weird stuff bubbling up to the API like the tool not being able to infer nullability of arguments and return values well and not being able to support stuff like RETURNING in statements. sqlc is pretty brilliant because it works around this by reimplementing the whole parser and type checker for postgres in go, which is awesome, but also a lot of work to maintain and potentially subtlety wrong.

    A minor drawback is that you have to retrain your users to write `x = ANY($1)` instead of `x IN ?`. Most ORMs and query builders seem to lean on their metaprogramming abilities to auto-convert array arguments in the host language into tuples. This is terrible and makes it really annoying when you want to actually pass an array into a query with an ORM/query builder, but it's the convention that everyone is used to.

    There are some other issues that most of these tools seem to get wrong, but are not impossible in principle to deal with for a database first code generator. The biggest one is correct handling of migrations. Most of these tools, sqlc included, spit out the straight line "obvious" go code that most people would write to scan some data out of a db. They make a struct, then pass each of the field into Scan by reference to get filled in. This works great until you have a query like `SELECT * FROM foos WHERE field = $1` and then run `ALTER TABLE foos ADD COLUMN new_field text`. Now the deployed server is broken and you need to redeploy really fast as soon as you've run migrations. opendoor/pggen handles this, but I'm not aware of other database first code generators that do (though I could definitely have missed one).

    Also the article is missing a few more tools in this space. https://github.com/xo/xo. https://github.com/gnormal/gnorm.

    [1]: https://github.com/opendoor/pggen

  • GitHub repo integresql

    IntegreSQL manages isolated PostgreSQL databases for your integration tests.

    Project mention: IntegreSQL – isolated PostgreSQL databases for integration tests | news.ycombinator.com | 2021-04-30
  • GitHub repo dbq

    Zero boilerplate database operations for Go

    Project mention: Does gorm worth learning? | reddit.com/r/golang | 2021-11-08

    I'm the author of https://github.com/rocketlaunchr/dbq. It is not an orm but I built it to be much much faster than gorm.

  • GitHub repo Shield

    A standalone system that can perform backup and restore functions for a wide variety of pluggable data systems

  • GitHub repo postgres

    🐘 Run PostgreSQL in Kubernetes (by kubedb)

    Project mention: "Crossplane project is blatantly copying Kubeform without even the basic decency of attribution" | reddit.com/r/kubernetes | 2021-09-02

    Links to relevant issue and PR, and our article on the problem (FR): https://github.com/kubedb/postgres/pull/248 https://github.com/kubedb/project/issues/385 https://github.com/kubedb/project/issues/405 https://github.com/kubedb/project/issues/461 https://github.com/kubedb/project/issues/555 https://github.com/kubedb/project/issues/556 https://rtfn.fr/news/cri.news/95/

  • GitHub repo database-lab-engine

    Thin PostgreSQL clones. DLE provides blazing fast database cloning to build powerful development, test, QA, staging environments. Follow to stay updated.

    Project mention: Optimizing Postgres Queries at Scale | news.ycombinator.com | 2021-12-28
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 2022-01-16.

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 10,858
2 migrate 7,884
3 SQLBoiler 4,567
4 FerretDB 3,962
5 space-cloud 3,350
6 pREST 3,071
7 postgres-operator 2,234
8 postgres-operator 2,218
9 goose 2,172
10 wal-g 2,012
11 go-oauth2-server 1,846
12 goqu 1,371
13 pgmetrics 717
14 gnomock 622
15 jet 607
16 dat 606
17 Satellity 519
18 gnorm 434
19 integresql 426
20 dbq 326
21 Shield 275
22 postgres 210
23 database-lab-engine 195
Find remote jobs at our new job board 99remotejobs.com. There are 29 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
OPS - Build and Run Open Source Unikernels
Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.