embedded-postgres
Run a real Postgres database locally on Linux, OSX or Windows as part of another Go application or test (by fergusstrange)
chai
Modern embedded SQL database (by chaisql)
| embedded-postgres | chai | |
|---|---|---|
| 4 | 13 | |
| 745 | 1,468 | |
| - | 2.3% | |
| 5.3 | 8.5 | |
| 5 days ago | about 2 months ago | |
| Go | Go | |
| MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
embedded-postgres
Posts with mentions or reviews of embedded-postgres.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-12.
-
If you could go back in time | What would you do different regarding go
So what can you do insted? For testing databases, setup a docker instance for tests (e.g. like in https://github.com/ardanlabs/service), or start an embedded-postgres daemon (see https://github.com/fergusstrange/embedded-postgres). For communication with external APIs, just pass the http.Client (either in context.Context or as a field on the struct). Then in tests, you can override the http.Client.Transport func.
-
Embedded database options
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.
-
Ask HN: Tips on hosting your own Postgres instance
depending on the language you have chosen for your side project you might also be able to run postgresql in embedded mode here is the one for golang https://github.com/fergusstrange/embedded-postgres . There is similar solution for java as well.
chai
Posts with mentions or reviews of chai.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-29.
-
Polygon: Json Database System designed to run on small servers (as low as 16MB) and still be fast and flexible.
Some example of embeddable database could be genji, badger and boltdb
- Resource for making database from scratch
-
Databases: 2021 in Review and Predictions for 2022
I keep reaching for SQLite and it keeps working. Although I've been needing a better review of what other embedded databases I should be considering in 2022. I tried Genji[1] recently and tore it out as it wasn't doing ORDER BY with multiple columns.
1. https://genji.dev/
- Genji – Document-oriented, embedded SQL database written in Go
-
Open Source Databases in Go
Genji is a document-oriented, embedded, SQL database. It is build over Pebble which is a port of RocksDB in Go, by the authors of CockroachDB.
-
Looking for: library to turn SQL (or abstracted) to code & execute against custom backend (slice of structs)
Use sth like https://github.com/genjidb/genji, which is an embedded DB with SQL
-
Embedded database options
Another option could be also Genji - https://github.com/genjidb/genji
-
Alternative to MongoDB?
There is Genji, this is a document-oriented embedded SQL database written in Go. It's still a work in progress though, but it looks great!
- A pure Go embedded SQL database
- Which Go database/storage package do you go for first when your program needs to store a moderate amount of organized data?
What are some alternatives?
When comparing embedded-postgres and chai you can also consider the following projects:
go-mutesting - Mutation testing for Go source code
sqlite
goc - A Comprehensive Coverage Testing System for The Go Programming Language
awesome-go-storage - A curated list of awesome Go storage projects and libraries
Testify - A toolkit with common assertions and mocks that plays nicely with the standard library
ent - An entity framework for Go
ginkgo - A Modern Testing Framework for Go
rqlite - The lightweight, distributed relational database built on SQLite.
go-vcr - Record and replay your HTTP interactions for fast, deterministic and accurate tests
go-sqlite - Low-level Go interface to SQLite 3
schema - Quick and easy expression matching for JSON schemas used in requests and responses
sqlite - Go SQLite3 driver