datajudge
pg_temp
| datajudge | pg_temp | |
|---|---|---|
| 1 | 1 | |
| 38 | 12 | |
| - | - | |
| 8.1 | 0.0 | |
| 29 days ago | about 1 month ago | |
| Python | Python | |
| 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:
pg_temp
-
Ask HN: How do you test SQL?
Here's a nifty python module for testing against postgres that a friend wrote. It creates a temporary database on the fly for testing and tears it down at the end. You can then populate the database and run all kinds of integration tests against it.
https://github.com/ugtar/pg_temp
What are some alternatives?
SS-Unit - A 100% T-SQL based unit testing framework for SQL Server
spark-style-guide - Spark style guide
sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
fugue - A unified interface for distributed computing. Fugue executes SQL, Python, Pandas, and Polars code on Spark, Dask and Ray without any rewrites.
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
testcontainers-dotnet - A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
Flyway - Flyway by Redgate • Database Migrations Made Easy.
pg-mem - An in memory postgres DB instance for your unit tests