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: Forgejo forks its own path forward | news.ycombinator.com | 2024-02-16

    > 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?

  • sqlc

    Generate type-safe code from SQL

  • Project mention: Show HN: Riza – Safely run untrusted code from your app | news.ycombinator.com | 2024-04-30

    Hi HN, I’m Kyle and together with Andrew (https://news.ycombinator.com/user?id=stanleydrew) we’ve been working on Riza (https://riza.io), a project to make WASM sandboxing more approachable. We’re excited to share a developer preview of our code interpreter API with HN.

    There’s a bit of a backstory here. A few months ago, an old coworker reached out asking how to execute untrusted code generated by an LLM. Based on our experience building a plugin system for sqlc (https://sqlc.dev), we thought a sandboxed WASM runtime would be a good fit. A bit of hacking later, we got everything wired up to solve his issue. Now the API is ready for other developers to try out.

    The Riza Code Interpreter API is an HTTP interface to various dynamic language interpreters, each running inside a WASM sandbox without access to the outside world (for now). We modeled the API to align with a POSIX shell-style interface.

    We made a playground so you can try it out without signing up: https://riza.io

    The API documentation lives here: https://docs.riza.io

    There are many limitations at the moment, but we expect to rapidly expand capabilities so that programs can e.g. access the network and filesystem. Our roadmap has more details: https://docs.riza.io/reference/roadmap

    If you need to execute LLM-generated code we’d love to have you try the API and let us know if you run into any issues. You can email us directly at [email protected].

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

    InfluxDB logo
  • bytebase

    The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.

  • Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14

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

  • usql

    Universal command-line interface for SQL databases

  • Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
  • FerretDB

    A truly Open Source MongoDB alternative

  • Project mention: Figma's Databases team lived to tell the scale | news.ycombinator.com | 2024-03-14

    if you have postgres, just use https://github.com/FerretDB/FerretDB

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

  • SQLBoiler

    Generate a Go ORM tailored to your database schema.

  • Project mention: Go ORMs Compared | dev.to | 2024-01-18

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

  • SaaSHub

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

    SaaSHub logo
  • steampipe

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

  • Project mention: Steampipe: Dynamically query APIs, code and more with SQL | news.ycombinator.com | 2024-04-04
  • Miniflux

    Minimalist and opinionated feed reader

  • Project mention: Show HN: OpenOrb, a curated search engine for Atom and RSS feeds | news.ycombinator.com | 2024-04-22

    https://github.com/miniflux/v2 in case anyone else was also wondering

  • goose

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

  • Project mention: Recent improvements to the pressly/goose migration tool | /r/golang | 2023-11-14

    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:

  • go-pg

    Golang ORM with focus on PostgreSQL features and performance

  • 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: Wazero: Zero dependency WebAssembly runtime written in Go | news.ycombinator.com | 2023-07-01

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

  • Encore

    Encore is the Backend Development Platform purpose-built to help you create event-driven and distributed systems.

  • Project mention: Build and deploy a REST API with Postgres database in TypeScript | dev.to | 2024-04-15

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

  • 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

  • dbmate

    :rocket: A lightweight, framework-agnostic database migration tool.

  • Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14

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

  • pREST

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

  • postgres-operator

    Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

  • Project mention: Run PostgreSQL. The Kubernetes Way | news.ycombinator.com | 2023-09-22

    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

  • 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: No disk space crashloop but pod healthy · Issue #3788 · CrunchyData/postgres-operator | /r/Health2020 | 2023-12-09
  • 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: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02

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

  • 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

  • Project mention: Homelab: Running Postgres on Kubernetes | news.ycombinator.com | 2024-01-02

    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.

  • goxygen

    Generate a modern Web project with Go and Angular, React, or Vue in seconds 🎲

  • Project mention: Goxygen v0.6.0 is released adding support for Go 1.20 | /r/golang | 2023-06-30
  • 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 related posts

  • Show HN: Riza – Safely run untrusted code from your app

    1 project | news.ycombinator.com | 30 Apr 2024
  • Ask HN: What tool(s) do you use to code review and deploy SQL scripts?

    5 projects | news.ycombinator.com | 14 Apr 2024
  • 11 Planetscale alternatives with free tiers

    8 projects | dev.to | 11 Apr 2024
  • Breaking the Myth: Scalable, Multi-Region, Low-Latency App Exists And Will Not Cost You A Kidney.

    4 projects | dev.to | 11 Apr 2024
  • Steampipe: Dynamically query APIs, code and more with SQL

    1 project | news.ycombinator.com | 4 Apr 2024
  • WAL-G 3.0.0 – fast disaster recovery for Postgres

    1 project | news.ycombinator.com | 17 Mar 2024
  • Parsing the Postgres protocol – logging executed statements

    5 projects | news.ycombinator.com | 14 Mar 2024
  • A note from our sponsor - SaaSHub
    www.saashub.com | 7 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

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

Project Stars
1 Gogs 44,167
2 sqlc 11,012
3 bytebase 10,107
4 usql 8,634
5 FerretDB 8,564
6 pgweb 8,291
7 SQLBoiler 6,453
8 steampipe 6,401
9 Miniflux 6,286
10 goose 5,684
11 go-pg 5,586
12 octosql 4,699
13 Encore 4,595
14 stolon 4,532
15 dbmate 4,364
16 pREST 4,098
17 postgres-operator 3,989
18 go-coffeeshop 3,952
19 postgres-operator 3,737
20 xo 3,567
21 upper.io/db 3,479
22 cloudnative-pg 3,425
23 goxygen 3,350

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com