What is the fastest way to clear my SQL database between integration tests?

• schemata

  1 0 0.0 Go

  Helper methods for creating test schemas in PostgreSQL databases with copies of tables from the live schema for unit testing.

I wrote something to copy the production schema into a test schema. I could then load test data, run tests, and then drop the schema.

• txdriver

  1 1 1.8 Go

  txdriver provides transaction isolation for Go SQL tests

I do option 1 and it can be super fast. Here's my implementation of it: https://github.com/bouk/txdriver//

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• sql-migrate

  9 3,086 6.7 Go

  SQL schema migration tool for Go.

Keep your migrations in the code repo and use a tool like sql-migrate to automatically apply them for you. At my job, we run a new container for each package's tests, and create a new db with the migration scripts for every test. It's certainly a bit slower, but the reproducibility is worth it.

• krok

  9 13 0.0 Go

  The main server of the hook management system

  

This creates a temporary database in a docker container while you are running your test. For an example look here: https://github.com/krok-o/krok/blob/main/tests/livestore/init_test.go

• dockertest

  48 3,967 3.0 Go

  Write better integration tests! Dockertest helps you boot up ephermal docker images for your Go tests with minimal work.

  

I'm amazed that no-one is suggesting this gem: https://github.com/ory/dockertest/

• InfluxDB

  www.influxdata.com sponsored

  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.

  

Suggest a related project