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 →
Top 23 Go Postgresql Projects
-
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.
-
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-29This 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.
-
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.
-
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
-
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
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
-
goose
-
Project mention: steampipe: Zero-ETL way to query APIs and services using SQL | news.ycombinator.com | 2024-10-15
-
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
-
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
-
-
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: 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-15In 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.
-
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)
-
-
xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)
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
-
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
Go Postgresql discussion
Go Postgresql related posts
-
Pg_flo – Stream, transform, and route PostgreSQL data in real-time
-
How I spent a few hours using advanced technology to save $2
-
Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝
-
steampipe: Zero-ETL way to query APIs and services using SQL
-
SPQR 2.0 Released
-
Some Go web dev notes
-
PostgreSQL 17 Released
-
A note from our sponsor - CodeRabbit
coderabbit.ai | 10 Nov 2024
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 |