SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Go Postgresql Projects
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
bytebase
The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
octosql
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
-
Encore
Encore is the Backend Development Platform purpose-built to help you create event-driven and distributed systems.
-
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)
-
upper.io/db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
-
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
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
> Gitea but the other one
Wouldn't that also be Gogs? https://gogs.io/
I remember when that one was what a lot of people were looking into, before the Gitea fork happened. It's odd to see how this has happened yet again, but I guess is a good thing that it's even possible in the first place, if there are indeed differing values and goals?
"Is there a way to get sqlc to use pointers for nullable columns instead of the sql.Null types?"
Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14We have been building https://github.com/bytebase/bytebase for 3+ years. You can think it of as GitHub/GitLab for SQL changes, with integrated GitOps, code review and deployment.
You can further check out this tutorial to get a feel of our GitOps solution
https://www.bytebase.com/docs/tutorials/database-change-mana...
Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
if you have postgres, just use https://github.com/FerretDB/FerretDB
Project mention: Ask HN: What apps have you created for your own use? | news.ycombinator.com | 2023-12-12Built 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.
SQLBoiler takes a database-first approach, generating Go code from your database schema. This means it creates highly optimized and custom-tailored code for your specific database schema. SQLBoiler is great for applications where the database schema is well-defined and changes infrequently. However, like sqlc, it requires regenerating the code when the database schema changes. It's well-suited for projects where performance is a key concern and the database design is stable.
Project mention: Steampipe: Dynamically query APIs, code and more with SQL | news.ycombinator.com | 2024-04-04
Project mention: Show HN: OpenOrb, a curated search engine for Atom and RSS feeds | news.ycombinator.com | 2024-04-22https://github.com/miniflux/v2 in case anyone else was also wondering
In v3.16.0 we added a new Provider feature that unlocks the ability to implement a lot of highly requested features. More details in the blog post:
Project mention: Wazero: Zero dependency WebAssembly runtime written in Go | news.ycombinator.com | 2023-07-01Never got it to anything close to a finished state, instead moving on to doing the same prototype in llvm and then cranelift.
That said, here's some of the wazero-based code on a branch - https://github.com/cube2222/octosql/tree/wasm-experiment/was...
It really is just a very very basic prototype.
Project mention: Build and deploy a REST API with Postgres database in TypeScript | dev.to | 2024-04-15In this tutorial you will create a REST API for a URL Shortener service using Encore for TypeScript, a new way of building fully type-safe and production-ready distributed systems in TypeScript using declarative infrastructure.
There's one in the stolon repo.
Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14A regular code repo with the scripts (with pull/merge requests for review) and then a CI job that builds containers with something like dbmate https://github.com/amacneil/dbmate that can then be run against any staging/prod environment.
yes, precisely. It's UI part that's broken, which cannot list snapshots. Issue is here, no fix since 2020, sadly: https://github.com/zalando/postgres-operator/issues/937
Project mention: No disk space crashloop but pod healthy · Issue #3788 · CrunchyData/postgres-operator | /r/Health2020 | 2023-12-09
Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.
My holiday project was doing another pass at my Homelab Kubernetes cluster, part of which involved switching to a proper operator to manage Postgres. Coincidentally, I setup cloudnative-pg (https://github.com/cloudnative-pg/cloudnative-pg) yesterday.
Go Postgresql related posts
- Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
- 11 Planetscale alternatives with free tiers
- Breaking the Myth: Scalable, Multi-Region, Low-Latency App Exists And Will Not Cost You A Kidney.
- Steampipe: Dynamically query APIs, code and more with SQL
- WAL-G 3.0.0 – fast disaster recovery for Postgres
- Parsing the Postgres protocol – logging executed statements
- Give Up Sooner
-
A note from our sponsor - SaaSHub
www.saashub.com | 24 Apr 2024
Index
What are some of the best open-source Postgresql projects in Go? This list will help you:
Project | Stars | |
---|---|---|
1 | Gogs | 44,097 |
2 | sqlc | 10,837 |
3 | bytebase | 9,977 |
4 | usql | 8,605 |
5 | FerretDB | 8,509 |
6 | pgweb | 8,277 |
7 | SQLBoiler | 6,424 |
8 | steampipe | 6,379 |
9 | Miniflux | 6,228 |
10 | go-pg | 5,581 |
11 | goose | 5,637 |
12 | octosql | 4,689 |
13 | Encore | 4,531 |
14 | stolon | 4,525 |
15 | dbmate | 4,321 |
16 | pREST | 4,078 |
17 | postgres-operator | 3,961 |
18 | go-coffeeshop | 3,925 |
19 | postgres-operator | 3,719 |
20 | xo | 3,563 |
21 | upper.io/db | 3,479 |
22 | goxygen | 3,344 |
23 | cloudnative-pg | 3,342 |
Sponsored