Re: Binding Postgres to port 0 for testing

2023-03-25 Thread Erik Wienhold
> On 25/03/2023 20:10 CET Markus Pilman wrote: > > Thanks for the suggestions. I didn't know about pg_virtualenv, that's > interesting. Though it seems to achieve something similar as to containerize > the test (potentially in a more platform independent way). Though it seems > pg_virtualenv is mo

Re: Binding Postgres to port 0 for testing

2023-03-25 Thread Erik Wienhold
> On 25/03/2023 18:01 CET Markus Pilman wrote: > > I am building a simple integration test framework for an application that I > am building. For this project I am planning to use PostgreSQL. > > For testing purposes I'd like to always start with an empty database, > populate data, and, if the tes

Re: Binding Postgres to port 0 for testing

2023-03-25 Thread Thorsten Glaser
Hi Markus, >I am building a simple integration test framework for an application that I >am building. For this project I am planning to use PostgreSQL. check pg_virtualenv(1), which apparently is a Debian thing. It auto-creates and auto-deletes at the end, if desired, a cluster and runs your prog

Binding Postgres to port 0 for testing

2023-03-25 Thread Markus Pilman
Hi all, I am building a simple integration test framework for an application that I am building. For this project I am planning to use PostgreSQL. For testing purposes I'd like to always start with an empty database, populate data, and, if the test was successful, delete everything. These tests a

Re: PostgreSQL vs MariaDB

2023-03-25 Thread Achilleas Mantzios
Στις 24/3/23 13:07, ο/η Inzamam Shafiq έγραψε: Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)? I would say that for small shops and