datajudge
squire
datajudge | squire | |
---|---|---|
1 | 1 | |
38 | 24 | |
- | - | |
8.1 | 10.0 | |
29 days ago | about 1 year ago | |
Python | Go | |
BSD 3-clause "New" or "Revised" License | MIT License |
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.
datajudge
-
Ask HN: How do you test SQL?
https://github.com/QuantCo/datajudge
We've also written a blog post trying to illustrate a use case:
squire
-
Ask HN: How do you test SQL?
On a related note (though it does touch upon testing) mitchellh open sourced Squire[1] recently (today?). Note though, that it's PostgreSQL specific.
[1] https://github.com/mitchellh/squire
What are some alternatives?
SS-Unit - A 100% T-SQL based unit testing framework for SQL Server
pg_temp - create a temporary, disposable, userland pg database
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
spark-style-guide - Spark style guide
pg-mem - An in memory postgres DB instance for your unit tests
fugue - A unified interface for distributed computing. Fugue executes SQL, Python, Pandas, and Polars code on Spark, Dask and Ray without any rewrites.
hash-db - Experimental distributed pseudomultimodel keyvalue database (it uses python dictionaries) imitating dynamodb querying with join only SQL support, distributed joins and simple Cypher graph support and document storage
bytebase - The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
testcontainers-dotnet - A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
dbt-unit-testing - This dbt package contains macros to support unit testing that can be (re)used across dbt projects.