embedded-postgres
Run a real Postgres database locally on Linux, OSX or Windows as part of another Go application or test (by fergusstrange)
testfixtures
Ruby on Rails like test fixtures for Go. Write tests against a real database (by go-testfixtures)
Our great sponsors
| embedded-postgres | testfixtures | |
|---|---|---|
| 4 | 4 | |
| 744 | 1,045 | |
| - | 2.7% | |
| 5.2 | 6.6 | |
| about 1 month ago | 26 days 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.
testfixtures
Posts with mentions or reviews of testfixtures.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-27.
-
How to mock database calls
I'm the author of https://github.com/go-testfixtures/testfixtures, a library written to make it easier to write tests with a real database and test data. You might want to use it together with docker-compose, for example.
-
Integration tests with Go and testcontainers
To solve the problem we will use testfixtures. Create a folders fixtures и fixtures/storage and put a file users.yaml inside:
-
Mocking database or use a test database
A lot of good suggestions here, I would also take a look at go-testfixtures which allows you to create some simple yaml-based fixture data to use with unit testing. It's quick and easy, but yes can get unwieldy the more you add.
-
Ask HN: What are some tools / libraries you built yourself?
I built an alternative to Make written in Go that is simpler to use and cross-platform: https://taskfile.dev/
Also, a library to write tests with databases for Go: https://github.com/go-testfixtures/testfixtures
What are some alternatives?
When comparing embedded-postgres and testfixtures you can also consider the following projects:
go-mutesting - Mutation testing for Go source code
go-vcr - Record and replay your HTTP interactions for fast, deterministic and accurate tests
goc - A Comprehensive Coverage Testing System for The Go Programming Language
Hamcrest - Hamcrest matchers for the Go programming language
Testify - A toolkit with common assertions and mocks that plays nicely with the standard library
ginkgo - A Modern Testing Framework for Go
GoSpec - Testing framework for Go. Allows writing self-documenting tests/specifications, and executes them concurrently and safely isolated. [UNMAINTAINED]
assert - :exclamation:Basic Assertion Library used along side native go testing, with building blocks for custom assertions
schema - Quick and easy expression matching for JSON schemas used in requests and responses
dbcleaner - Clean database for testing, inspired by database_cleaner for Ruby
embedded-postgres vs go-mutesting
testfixtures vs go-vcr
embedded-postgres vs goc
testfixtures vs Hamcrest
embedded-postgres vs Testify
testfixtures vs ginkgo
embedded-postgres vs ginkgo
testfixtures vs GoSpec
embedded-postgres vs go-vcr
testfixtures vs assert
embedded-postgres vs schema
testfixtures vs dbcleaner