Embedded database options

• embedded-postgres

  4 747 5.3 Go

  Run a real Postgres database locally on Linux, OSX or Windows as part of another Go application or test

This is down to nuance, but all databases are "file based" as they all write to files. But most of them require a separate process with lock coordination to get away from writer lock delays and ensure ACID, which includes Postgresql. Calling any version of pgl "embedded" is confusing because I see that being used to describe pgl databases which are run in a localhost mode with a single reader/writer client. Regardless, those still require a postgres process and access it over IP. For simplicity, if one uses a database by touching its files directly from the process accessing the database, then it's "embedded"; but then again I guess that semantic ship has sailed: https://github.com/fergusstrange/embedded-postgres so the point may be moot.

• awesome-go-storage

  7 4,290 4.1

  A curated list of awesome Go storage projects and libraries

  

• InfluxDB

  www.influxdata.com featured

  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.

  

• chai

  13 1,469 8.5 Go

  Modern embedded SQL database (by chaisql)

  

Another option could be also Genji - https://github.com/genjidb/genji

• litestream

  165 10,026 7.5 Go

  Streaming replication for SQLite.

And with litestream.io/ you can have semi-non-blocking backups.

• ObjectBox Go Database

  1 1,035 5.8 Go

  Embedded Go Database, the fast alternative to SQLite, gorm, etc.

  

You could try https://github.com/objectbox/objectbox-go. I have not used the go version, but a coworker is using it for dart and it made a good impression. I like that its type safe

• badger

  30 13,422 6.7 Go

  Fast key-value DB in Go.

  

• bytebase

  36 10,107 10.0 Go

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

  

Bytebase embedds postgresql per platform. If it helps. https://github.com/bytebase/bytebase/tree/main/resources/postgres

• SaaSHub

  www.saashub.com featured

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

  

• migrate

  72 14,062 8.0 Go

  Database migrations. CLI and Golang library.

  

This is indeed a concern, but not one I've needed to care about (or the ordering of columns on disk in general). Using an intermediate table might be OK if you use it as part of automatic DB migrations. I use golang-migrate, YMMV.

• badger

  1 127 0.0 Go

  Fast Key-Value DB in Go (by outcaste-io)

  

Just know that dgraph (which you also mentioned) appears to be in its death throws. The original developer has left, forked it and is working on starting a new company around it. I'm rooting for him because it's a great database.

Suggest a related project