pg_temp vs testcontainers-dotnet

pg_temp

create a temporary, disposable, userland pg database (by ugtar)

testcontainers-dotnet

A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions. (by testcontainers)

Testing Automation .NET Docker testcontainers Test test-framework

Source Code

dotnet.testcontainers.org

Suggest alternative

Edit details

Scout Monitoring - Free Django app performance insights with Scout Monitoring

Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.

www.scoutapm.com

featured

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

pg_temp		testcontainers-dotnet
	Project
1	Mentions	16
13	Stars	3,591
-	Growth	1.6%
0.0	Activity	8.9
2 months ago	Latest Commit	5 days ago
Python	Language	C#
MIT License	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.

pg_temp

Posts with mentions or reviews of pg_temp. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-01-31.

Ask HN: How do you test SQL?
18 projects | news.ycombinator.com | 31 Jan 2023

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

testcontainers-dotnet

Posts with mentions or reviews of testcontainers-dotnet. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-11-07.

Integration tests with AWS S3 buckets using Localstack and Testcontainers
2 projects | dev.to | 7 Nov 2023

Testcontainers
Integration Tests with In Memory DB vs Real DB on Docker
1 project | /r/dotnet | 28 Aug 2023

Like others said, it's better to test with an actual database. I recommend using Testcontainers (https://dotnet.testcontainers.org), you can even create multiple instances so your tests can run in parallel independently.
Unit Testing
2 projects | /r/dotnet | 5 Jul 2023
Running untrusted (user-provided) Python code on ASP.NET/C# backend
2 projects | /r/dotnet | 20 Jun 2023
Integration tests for AWS serverless solution
4 projects | dev.to | 15 May 2023

To launch a container in code we will use Testcontainers. Testcontainers is a library that is built on top of the .NET Docker remote API and provides a lightweight implementation to support your test environment in all circumstances. This library supports pre-defined packages for containers or you can use your .dockerfile. We will use a pre-defined package for LocalStak. LocalStack is a cloud service emulator that runs in a single container for AWS service. LocalStack supports a growing number of AWS services.
If i want to do testing CRUD should I use in memory or just do integration test where I use a seperate database?
1 project | /r/csharp | 22 Apr 2023
Do you guys mock everything in your Unit Tests?
5 projects | /r/csharp | 12 Apr 2023

Bogus - For creating fake data Verify - Snapshot testing for .NET MELT - For testing ILogger usage Stryker - Mutation Testing for .NET TestContainers - run docker programmatically in integration tests
Testes de integração com containers
2 projects | dev.to | 3 Mar 2023
What C# tools would you like to use that don't exist today?
9 projects | /r/csharp | 25 Feb 2023
Ask HN: How do you test SQL?
18 projects | news.ycombinator.com | 31 Jan 2023

.NET Shop using SQL Server here, but I think something similar to what we do can apply to any stack. We use TestContainers [1] to spin up a container with SQL Server engine running on it. Then use FluentMigrator [2] to provision tables and test data to run XUnit integration tests against. This has worked remarkably well.
[1] https://dotnet.testcontainers.org/

What are some alternatives?

When comparing pg_temp and testcontainers-dotnet you can also consider the following projects:

spark-style-guide - Spark style guide

NUnit - NUnit Framework

sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code.

SpecFlow - #1 .NET BDD Framework. SpecFlow automates your testing & works with your existing code. Find Bugs before they happen. Behavior Driven Development helps developers, testers, and business representatives to get a better understanding of their collaboration

SS-Unit - A 100% T-SQL based unit testing framework for SQL Server

testcontainers-go - Testcontainers for Go is a Go package that makes it simple to create and clean up container-based dependencies for automated integration/smoke tests. The clean, easy-to-use API enables developers to programmatically define containers that should be run as part of a test and clean up those resources when the test is done.

datajudge - Assessing whether data from database complies with reference information.

testcontainers-python - Testcontainers is a Python library that providing a friendly API to run Docker container. It is designed to create runtime environment to use during your automatic tests.

fugue - A unified interface for distributed computing. Fugue executes SQL, Python, Pandas, and Polars code on Spark, Dask and Ray without any rewrites.

Docker.DotNet - :whale: .NET (C#) Client Library for Docker API

sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.

ephemeral-mongo - EphemeralMongo is a set of three NuGet packages wrapping the binaries of MongoDB 4, 5 and 6 built for .NET Standard 2.0.