sqlx icon indicating copy to clipboard operation
sqlx copied to clipboard

[Proposal] Replace the Test Host Level DB's with containers.

Open bearrito opened this issue 1 year ago • 1 comments

It looks like the unit tests for this project require installing host level db instances. That's reasonable given the projects inception date.

However, I think there are better alternatives available.

Namely using https://github.com/testcontainers/testcontainers-go

Advantages

  1. Less overhead for development (If actually ongoing in this project)
  2. Easier to test within a vendors versions eg. we could have Postgres 12-16
  3. Easier to test across vendors e.g Mysql, Maria, Postgres, MSSQL etc.

If the maintainers accepted this I would contribute the suite.

bearrito avatar Mar 22 '24 03:03 bearrito

As a user of this lib who was thinking about adding test coverage for clickhouse. This would be great.

stephen-up avatar Oct 04 '24 01:10 stephen-up