Go Postgresql

Open-source Go projects categorized as Postgresql

Top 23 Go Postgresql Projects

  • Gogs

    Gogs is a painless self-hosted Git service

    Project mention: 100+ Must-Have Web Development Resources | dev.to | 2024-10-14

    Gogs: An easy-to-setup self-hosted Git service.

  • CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  • sqlc

    Generate type-safe code from SQL

    Project mention: Some Go web dev notes | news.ycombinator.com | 2024-09-29

    I really wanted to like sqlc, but it had some major limitations and minor annoyances last time I tried it a few months ago. You might want to go through its list of issues[1] before adopting it.

    Things like no support for dynamic queries[2], one-to-many relationships[3], embedded CTEs[4], composite types[5], etc.

    It might work fine if you only have simple needs, but if you ever want to do something slightly sophisticated, you'll have to fallback to the manual approach. It's partly understandable, though. It cannot realistically support every feature of every DBMS, and it's explicitly not an ORM. But I still decided to stick to the manual approach for everything, instead of wondering whether something is or isn't supported by sqlc.

    [1]: https://github.com/sqlc-dev/sqlc/issues/

    [2]: https://github.com/sqlc-dev/sqlc/issues/3414

    [3]: https://github.com/sqlc-dev/sqlc/issues/3394

    [4]: https://github.com/sqlc-dev/sqlc/issues/3128

    [5]: https://github.com/sqlc-dev/sqlc/issues/2760

  • bytebase

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

    Project mention: Building a better and scalable system for data migrations | news.ycombinator.com | 2024-10-29

    This post addresses the data migration specifics well. Besides, there is the part about scaling the organization to deploy database migrations. We've built a project https://github.com/bytebase/bytebase to address this.

  • FerretDB

    A truly Open Source MongoDB alternative

    Project mention: Mongo but on Postgres and with strong consistency benefits | news.ycombinator.com | 2024-07-07

    Hmmm how does this compare to https://www.ferretdb.com ?

    How does this handle large files? Is it enough to replace GridFS? One of main attraction for MongoDb is it's handling of large files.

  • usql

    Universal command-line interface for SQL databases

    Project mention: JetBrains DataGrip doesn't accept JSON1 data type | news.ycombinator.com | 2024-06-15

    Does JSON1 data type works fine with usql [1]? I haven't use it yet.

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

  • pgweb

    Cross-platform client for PostgreSQL databases

    Project mention: Ask HN: What apps have you created for your own use? | news.ycombinator.com | 2023-12-12

    Built Pgweb (Postgres GUI) some time ago since I could not find a good minimalistic database explorer.

    https://github.com/sosedoff/pgweb

    The app is super simple, made with Go + jQuery and I still use it almost every day, and has brought it to every single company I've been with.

  • Encore

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

    Project mention: TypeScript vs Go: Choosing Your Backend Language | dev.to | 2024-11-08

    Encore.ts: The TypeScript native version of Encore, introduced in early 2024, is a fully-featured framework for building type-safe microservices application. Comes with built-in automation for running local infrastructure and integration for easy deployment to cloud infrastructure.

  • SaaSHub

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

    SaaSHub logo
  • goose

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

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

    goose

  • steampipe

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

    Project mention: steampipe: Zero-ETL way to query APIs and services using SQL | news.ycombinator.com | 2024-10-15
  • Miniflux

    Minimalist and opinionated feed reader

    Project mention: Hacker News RSS | news.ycombinator.com | 2024-10-03

    I like Miniflux[0]. It being a hosted RSS reader means I can easily browse on my PC as well as on my phone.

    [0] https://github.com/miniflux/v2

  • 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

  • go-pg

    Golang ORM with focus on PostgreSQL features and performance

  • dbmate

    🚀 A lightweight, framework-agnostic database migration tool.

    Project mention: Dbmate: A lightweight, framework-agnostic database migration tool | news.ycombinator.com | 2024-06-16
  • 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
  • stolon

    PostgreSQL cloud native High Availability and more.

    Project mention: Ask HN: Are there any open source forks of nomad smd consul? | news.ycombinator.com | 2024-05-02

    > I think etcd is basically a k8s only project now

    I hate etcd with the best of them, but etcd is used in a lot more places than just kubernetes:

    https://github.com/apache/apisix/blob/master/docs/en/latest/...

    https://github.com/traefik/traefik#:~:text=Etcd,

    https://github.com/zalando/patroni#patroni-a-template-for-po...

    https://github.com/purpleidea/mgmt/tree/0.0.26/etcd (this one shows up on HN quite a bit)

    https://github.com/sorintlab/stolon#features

    It's actually one of the major reasons I wouldn't touch those projects

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

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

  • postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

    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

  • go-coffeeshop

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

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

    SQL-first Golang ORM (by uptrace)

  • xo

    Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

    Project mention: Sqlc: Compile SQL to type-safe code | news.ycombinator.com | 2024-09-08

    XO doesn’t have them built-in, but it uses easily customizable templates.

    I added support for a bunch of postgres fancy stuff in a previous app, it wasn’t too difficult

    https://github.com/xo/xo

  • pgroll

    PostgreSQL zero-downtime migrations made easy

    Project mention: Pgroll: PostgreSQL zero-downtime migrations made easy | news.ycombinator.com | 2024-09-22
  • 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

  • Pg_flo – Stream, transform, and route PostgreSQL data in real-time

    12 projects | news.ycombinator.com | 3 Nov 2024
  • How I spent a few hours using advanced technology to save $2

    2 projects | dev.to | 1 Nov 2024
  • Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

    3 projects | dev.to | 29 Oct 2024
  • steampipe: Zero-ETL way to query APIs and services using SQL

    1 project | news.ycombinator.com | 15 Oct 2024
  • SPQR 2.0 Released

    1 project | news.ycombinator.com | 15 Oct 2024
  • Some Go web dev notes

    16 projects | news.ycombinator.com | 29 Sep 2024
  • PostgreSQL 17 Released

    4 projects | news.ycombinator.com | 26 Sep 2024
  • A note from our sponsor - CodeRabbit
    coderabbit.ai | 10 Nov 2024
    Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR. Learn more →

Index

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

Project Stars
1 Gogs 45,052
2 sqlc 13,375
3 bytebase 11,402
4 FerretDB 9,172
5 usql 8,963
6 pgweb 8,637
7 Encore 7,427
8 goose 7,059
9 steampipe 6,918
10 Miniflux 6,867
11 SQLBoiler 6,745
12 go-pg 5,668
13 dbmate 5,437
14 octosql 4,820
15 stolon 4,658
16 cloudnative-pg 4,585
17 postgres-operator 4,357
18 pREST 4,232
19 go-coffeeshop 4,122
20 postgres-operator 3,934
21 bun 3,750
22 xo 3,732
23 pgroll 3,567

Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai

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