testsql VS dbcleaner

Compare testsql vs dbcleaner and see what are their differences.

testsql

Generate test data from SQL files before testing and clear it after finished. (by zhulongcheng)
Testing Testing Frameworks
Source Code
Suggest alternative
Edit details

dbcleaner

Clean database for testing, inspired by database_cleaner for Ruby (by khaiql)
Testing Testing Frameworks Golang clean-database database-engine Driver unit-testing
Source Code
Suggest alternative
Edit details
InfluxDB - 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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
testsql dbcleaner
- 1
17 157
- -
0.0 1.8
over 4 years ago over 2 years 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.

testsql

Posts with mentions or reviews of testsql. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning testsql yet.
Tracking mentions began in Dec 2020.

dbcleaner

Posts with mentions or reviews of dbcleaner. We have used some of these posts to build our list of alternatives and similar projects.
  • The Big Unit Test Misunderstanding
    1 project | news.ycombinator.com | 21 Mar 2022
    It is not hard to isolate and stub a database the problem is you will not catch a lot of errors, e.g. writing a 40 char string into a VCHAR(10), DateTime conversations, ...

    In Ruby on Rails it is quite common to use a real database in the unit tests. Even before containers came out and it is still fast (yes, less than 1 second).

    In rails you use the same database instance for all the tests, so you do not have spin up a database instance for every case. Instead you use a database cleaner.

    There also exists a JS implementation: https://github.com/khaiql/dbcleaner

What are some alternatives?

When comparing testsql and dbcleaner you can also consider the following projects:

go-cmp - Package for comparing Go values in tests

go-carpet - Tool for show test coverage in terminal for Go source files

goc - A Comprehensive Coverage Testing System for The Go Programming Language

bro - bro watch files in directory and run tests for them

frisby - API testing framework inspired by frisby-js

Gauge - Light weight cross-platform test automation

wstest - go websocket client for unit testing of a websocket handler

goblin - Minimal and Beautiful Go testing framework

go-vcr - Record and replay your HTTP interactions for fast, deterministic and accurate tests

testfixtures - Ruby on Rails like test fixtures for Go. Write tests against a real database

go-mutesting - Mutation testing for Go source code

testsql vs go-cmp dbcleaner vs go-carpet testsql vs goc dbcleaner vs bro testsql vs frisby dbcleaner vs Gauge testsql vs wstest dbcleaner vs goblin testsql vs go-vcr dbcleaner vs testfixtures testsql vs go-mutesting dbcleaner vs goc