Embedded database options

• embedded-postgres

  3 412 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

  4 3,605 4.3

  A curated list of awesome Go storage projects and libraries

  

• SonarLint

  www.sonarlint.org

  sponsored

  Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  

• genji

  7 978 8.9 Go

  Document-oriented, embedded SQL database

  

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

• litestream

  45 7,110 8.5 Go

  Streaming replication for SQLite.

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

• ObjectBox Go Database

  1 777 6.1 Go

  Fast Golang database for easy Go structs/objects persistence; plus out-of-the-box Data Sync

  

  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

  15 11,153 6.0 Go

  Fast key-value DB in Go.

  

• Bytebase

  19 3,423 10.0 Go

  Safe database schema change and version control for DevOps teams. https://www.bytebase.com

  

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

• Scout APM

  scoutapm.com

  sponsored

  Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  

• migrate

  30 9,318 6.4 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 91 8.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